Security Definitions

| Type    | Name                         |
|---------|------------------------------|
| Number  | contractmultiplier           |
| Number  | couponperiod                 |
| Number  | dividendnetpx                |
| Number  | exchangetradingsessionid     |
| Number  | facevalue                    |
| Number  | flags                        |
| Number  | highlimitpx                  |
| Number  | initialcapitalization        |
| Number  | initiald                     |
| Number  | initialmarginonbuy           |
| Number  | initialmarginonsell          |
| Number  | initialmarginsyntetic        |
| Number  | initialvalue                 |
| Number  | lowlimitpx                   |
| Number  | minpriceincrement            |
| Number  | minpriceincrementamount      |
| Number  | nosharesissued               |
| Number  | ordernote                    |
| Number  | pricetype                    |
| Number  | product                      |
| Number  | roundlot                     |
| Number  | sec_scale                    |
| Number  | securityidsource             |
| Number  | securitytradingstatus        |
| Number  | strikeprice                  |
| Number  | theorprice                   |
| Number  | theorpricelimit              |
| Number  | underlyingfutureid           |
| Number  | underlyingsecurityid         |
| Number  | volatility                   |
| Integer | lotdivider                   |
| Boolean | eveningsessiontradingallowed |
| Boolean | mainsessiontrading           |
| Boolean | nonanonymoustradingallowed   |
| Boolean | multileg                     |
| String  | anonymoustradingallowed      |
| String  | auctionindicator             |
| String  | cficode                      |
| String  | currency                     |
| String  | datetime                     |
| String  | encodedsecuritydesc          |
| String  | encodedshortsecuritydesc     |
| String  | firsttradedate               |
| String  | iqstradingallowed            |
| String  | lasttradedate                |
| String  | marketcode                   |
| String  | marketid                     |
| String  | marketsegmentid              |
| String  | maturitydate                 |
| String  | maturitytime                 |
| String  | minpriceincrementamountcurr  |
| String  | securityaltid                |
| String  | securityaltidsource          |
| String  | securitydesc                 |
| String  | securityid                   |
| String  | securitytype                 |
| String  | sendercompid                 |
| String  | settlcurrency                |
| String  | settldate                    |
| String  | settlfixingdate              |
| String  | settlpriceopen               |
| String  | statesecurityid              |
| String  | symbol                       |
| String  | tradingsessionid             |
| String  | tradingsessionsubid          |
| String  | underlyingsymbol             |
SELECT name,
SEC_DEF.anonymoustradingallowed,
SEC_DEF.auctionindicator,
SEC_DEF.cficode,
SEC_DEF.contractmultiplier,
SEC_DEF.couponperiod,
SEC_DEF.currency,
SEC_DEF.datetime,
SEC_DEF.dividendnetpx,
SEC_DEF.encodedsecuritydesc,
SEC_DEF.encodedshortsecuritydesc,
SEC_DEF.eveningsessiontradingallowed,
SEC_DEF.exchangetradingsessionid,
SEC_DEF.facevalue,
SEC_DEF.firsttradedate,
SEC_DEF.flags,
SEC_DEF.highlimitpx,
SEC_DEF.initialmarginonbuy,
SEC_DEF.initialmarginonsell,
SEC_DEF.iqstradingallowed,
SEC_DEF.lasttradedate,
SEC_DEF.lotdivider,
SEC_DEF.lowlimitpx,
SEC_DEF.mainsessiontrading,
SEC_DEF.marketcode,
SEC_DEF.marketid,
SEC_DEF.marketsegmentid,
SEC_DEF.maturitydate,
SEC_DEF.maturitytime,
SEC_DEF.minpriceincrement,
SEC_DEF.minpriceincrementamount,
SEC_DEF.minpriceincrementamountcurr,
SEC_DEF.multileg,
SEC_DEF.nonanonymoustradingallowed,
SEC_DEF.nosharesissued,
SEC_DEF.ordernote,
SEC_DEF.pricetype,
SEC_DEF.product,
SEC_DEF.roundlot,
SEC_DEF.sec_scale,
SEC_DEF.securityaltid,
SEC_DEF.securityaltidsource,
SEC_DEF.securitydesc,
SEC_DEF.securityid,
SEC_DEF.securityidsource,
SEC_DEF.securitytradingstatus,
SEC_DEF.securitytype,
SEC_DEF.sendercompid,
SEC_DEF.settlcurrency,
SEC_DEF.settldate,
SEC_DEF.settlfixingdate,
SEC_DEF.settlpriceopen,
SEC_DEF.statesecurityid,
SEC_DEF.symbol,
SEC_DEF.tradingsessionid,
SEC_DEF.tradingsessionsubid,
SEC_DEF.underlyingsymbol
FROM atsd_entity
  WHERE tags.class_code = '<class>' AND tags.symbol = '<symbol>'