PREVIEW / futures_daily / 2012-12-24
file: by_date/futures_daily/2012/2012-12-24.parquet size: 9 KB rows: 87
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2012-12-24 | ES | Futures | 1457.29 | 1457.54 | 1450.38 | 1452.68 | 318126.0 |
| 2012-12-24 | NQ | Futures | 3068.15 | 3071.32 | 3052.58 | 3055.17 | 40306.0 |
| 2012-12-24 | YM | Futures | 12878.2 | 12881.1 | 12806.6 | 12811.5 | 22366.0 |
| 2012-12-24 | CL | Futures | 157.25 | 157.71 | 156.54 | 157.27 | 48516.0 |
| 2012-12-24 | GC | Futures | 2209.5 | 2220.8 | 2202.4 | 2211.5 | 44006.0 |
| 2012-12-24 | ZN | Futures | 116.776377 | 116.845288 | 116.652338 | 116.721249 | 74527.0 |
| 2012-12-24 | A6 | Futures | 0.94676 | 0.9474 | 0.94154 | 0.94264 | 32045.0 |
| 2012-12-24 | AD | Futures | 1.00791 | 1.01051 | 1.0064 | 1.01001 | 21991.0 |
| 2012-12-24 | B | Futures | 101.66 | 101.85 | 100.83 | 101.45 | 49454.0 |
| 2012-12-24 | B6 | Futures | 1.6888 | 1.6934 | 1.6821 | 1.6858 | 35338.0 |
| 2012-12-24 | BFX | Futures | 3003.9 | 3003.9 | 3001.9 | 3001.9 | 1.0 |
| 2012-12-24 | BR | Futures | 0.23409 | 0.23409 | 0.23409 | 0.23409 | 23.0 |
| 2012-12-24 | BZ | Futures | 104.84 | 104.84 | 103.9 | 104.52 | 287.0 |
| 2012-12-24 | C | Futures | 1573.0 | 1574.0 | 1559.0 | 1565.0 | 992.0 |
| 2012-12-24 | CB | Futures | 85.879 | 85.879 | 85.879 | 85.879 | 1.0 |
| 2012-12-24 | CC | Futures | 1738.0 | 1743.0 | 1713.0 | 1715.0 | 5422.0 |
| 2012-12-24 | CSC | Futures | 3.873 | 3.916 | 3.862 | 3.912 | 26.0 |
| 2012-12-24 | CT | Futures | 95.87 | 96.28 | 95.63 | 96.15 | 6520.0 |
| 2012-12-24 | DC | Futures | 29.02 | 29.48 | 29.02 | 29.15 | 34.0 |
| 2012-12-24 | DX | Futures | 76.866 | 76.962 | 76.62 | 76.909 | 8263.0 |
| 2012-12-24 | E1 | Futures | 1.40775 | 1.41328 | 1.40608 | 1.40917 | 8474.0 |
| 2012-12-24 | E6 | Futures | 1.55587 | 1.56236 | 1.55481 | 1.55693 | 59433.0 |
| 2012-12-24 | E7 | Futures | 1.5449 | 1.5517 | 1.5443 | 1.5463 | 1268.0 |
| 2012-12-24 | EBM | Futures | 282.01 | 283.41 | 281.18 | 283.13 | 19555.0 |
| 2012-12-24 | ED | Futures | 95.2151 | 95.2247 | 95.2008 | 95.2103 | 43887.0 |
| 2012-12-24 | ER | Futures | 97.852 | 97.852 | 97.827 | 97.827 | 13184.0 |
| 2012-12-24 | EW | Futures | 1039.5 | 1040.8 | 1035.4 | 1037.8 | 6324.0 |
| 2012-12-24 | FCE | Futures | 2762.0 | 2771.5 | 2750.4 | 2753.4 | 10454.0 |
| 2012-12-24 | FTI | Futures | 295.17 | 296.59 | 295.17 | 296.51 | 2280.0 |
| 2012-12-24 | FTUK | Futures | 4348.6 | 4355.2 | 4333.9 | 4350.5 | 80002.0 |
| 2012-12-24 | G | Futures | 98.21 | 98.28 | 98.09 | 98.22 | 60339.0 |
| 2012-12-24 | GF | Futures | 288.426 | 289.185 | 287.477 | 287.477 | 750.0 |
| 2012-12-24 | GSCI | Futures | 1026.73 | 1027.21 | 1025.6 | 1026.57 | 5.0 |
| 2012-12-24 | HE | Futures | 99.728 | 100.618 | 99.499 | 100.474 | 11189.0 |
| 2012-12-24 | HG | Futures | 4.5722 | 4.596 | 4.5523 | 4.5536 | 14265.0 |
| 2012-12-24 | HH | Futures | 39.541 | 39.565 | 39.283 | 39.283 | 161.0 |
| 2012-12-24 | HO | Futures | 2.4151 | 2.4177 | 2.3918 | 2.395 | 6577.0 |
| 2012-12-24 | HRC | Futures | 2409.5 | 2409.5 | 2409.5 | 2409.5 | 0.0 |
| 2012-12-24 | J1 | Futures | 0.0148586 | 0.0148712 | 0.0147734 | 0.014791 | 38760.0 |
| 2012-12-24 | J7 | Futures | 0.01479 | 0.014797 | 0.0147 | 0.014717 | 374.0 |
| 2012-12-24 | JB | Futures | 127.15 | 127.17 | 127.07 | 127.1 | 273.0 |
| 2012-12-24 | KC | Futures | 307.63 | 310.46 | 304.48 | 308.46 | 3768.0 |
| 2012-12-24 | KE | Futures | 2779.03 | 2785.62 | 2766.68 | 2781.5 | 1742.0 |
| 2012-12-24 | L | Futures | 98.901 | 98.901 | 98.881 | 98.891 | 18184.0 |
| 2012-12-24 | LBS | Futures | 666.1 | 680.2 | 666.1 | 680.2 | 451.0 |
| 2012-12-24 | LE | Futures | 169.085 | 169.562 | 169.022 | 169.276 | 6626.0 |
| 2012-12-24 | MFS | Futures | 1468.1 | 1468.1 | 1461.6 | 1464.4 | 1567.0 |
| 2012-12-24 | MGC | Futures | 2180.6 | 2191.1 | 2172.8 | 2181.5 | 360.0 |
| 2012-12-24 | MME | Futures | 962.9 | 966.1 | 960.6 | 962.5 | 2960.0 |
| 2012-12-24 | MP | Futures | 0.04492 | 0.04497 | 0.04298 | 0.04449 | 21443.0 |
> showing 50 of 87 rows — these rows as CSV