PREVIEW / futures_daily / 2015-11-12
file: by_date/futures_daily/2015/2015-11-12.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-12 | ES | Futures | 2200.37 | 2209.94 | 2169.52 | 2170.59 | 1807653.0 |
| 2015-11-12 | NQ | Futures | 5414.9 | 5440.62 | 5356.44 | 5361.11 | 268158.0 |
| 2015-11-12 | YM | Futures | 18211.9 | 18277.9 | 17943.6 | 17950.9 | 172359.0 |
| 2015-11-12 | CL | Futures | 68.35 | 68.8 | 65.96 | 66.29 | 545351.0 |
| 2015-11-12 | GC | Futures | 1401.1 | 1405.8 | 1385.1 | 1395.4 | 208297.0 |
| 2015-11-12 | ZN | Futures | 120.817778 | 121.057258 | 120.713005 | 120.892615 | 1114026.0 |
| 2015-11-12 | A6 | Futures | 0.70583 | 0.71443 | 0.70503 | 0.71103 | 124050.0 |
| 2015-11-12 | AD | Futures | 0.7722 | 0.77424 | 0.76748 | 0.77066 | 65244.0 |
| 2015-11-12 | ALI | Futures | 2108.07 | 2108.07 | 2108.07 | 2108.07 | 0.0 |
| 2015-11-12 | B | Futures | 41.23 | 41.52 | 39.69 | 39.86 | 363154.0 |
| 2015-11-12 | B6 | Futures | 1.6021 | 1.6054 | 1.5976 | 1.6025 | 77383.0 |
| 2015-11-12 | BR | Futures | 0.16435 | 0.16435 | 0.15998 | 0.16195 | 2443.0 |
| 2015-11-12 | BZ | Futures | 40.99 | 41.25 | 39.49 | 39.61 | 31825.0 |
| 2015-11-12 | C | Futures | 2404.0 | 2426.0 | 2403.0 | 2425.0 | 3949.0 |
| 2015-11-12 | CB | Futures | 215.767 | 215.767 | 215.275 | 215.275 | 18.0 |
| 2015-11-12 | CC | Futures | 2440.0 | 2455.0 | 2433.0 | 2454.0 | 31842.0 |
| 2015-11-12 | CNH | Futures | 7.1075 | 7.1187 | 7.1058 | 7.1127 | 27.0 |
| 2015-11-12 | CSC | Futures | 4.253 | 4.255 | 4.199 | 4.209 | 63.0 |
| 2015-11-12 | CT | Futures | 74.59 | 74.94 | 74.04 | 74.18 | 21128.0 |
| 2015-11-12 | DC | Futures | 33.79 | 33.92 | 33.5 | 33.57 | 404.0 |
| 2015-11-12 | DX | Futures | 92.483 | 92.96 | 92.123 | 92.321 | 44538.0 |
| 2015-11-12 | E1 | Futures | 1.26438 | 1.27098 | 1.2588 | 1.26781 | 28901.0 |
| 2015-11-12 | E6 | Futures | 1.26058 | 1.26925 | 1.25285 | 1.26492 | 281637.0 |
| 2015-11-12 | E7 | Futures | 1.2536 | 1.2621 | 1.2459 | 1.2579 | 5091.0 |
| 2015-11-12 | EBM | Futures | 265.63 | 265.99 | 261.61 | 261.97 | 20531.0 |
| 2015-11-12 | ED | Futures | 95.6919 | 95.6919 | 95.6823 | 95.6871 | 156331.0 |
| 2015-11-12 | ER | Futures | 98.225 | 98.239 | 98.22 | 98.229 | 99346.0 |
| 2015-11-12 | EW | Futures | 1524.9 | 1530.5 | 1492.6 | 1493.4 | 23241.0 |
| 2015-11-12 | FBON | Futures | 114.06 | 114.59 | 114.06 | 114.26 | 441.0 |
| 2015-11-12 | FBTP | Futures | 104.11 | 104.68 | 104.04 | 104.38 | 124219.0 |
| 2015-11-12 | FBTS | Futures | 100.606 | 100.642 | 100.588 | 100.597 | 22879.0 |
| 2015-11-12 | FCE | Futures | 4130.0 | 4143.8 | 4027.2 | 4055.2 | 2542.0 |
| 2015-11-12 | FDAX | Futures | 11993.9 | 12071.5 | 11796.7 | 11880.5 | 113566.0 |
| 2015-11-12 | FDXM | Futures | 11203.7 | 11278.9 | 11025.7 | 11100.8 | 11997.0 |
| 2015-11-12 | FESX | Futures | 2576.7 | 2591.6 | 2516.7 | 2537.7 | 1274348.0 |
| 2015-11-12 | FGBL | Futures | 139.04 | 139.36 | 138.96 | 139.11 | 564241.0 |
| 2015-11-12 | FGBM | Futures | 125.69 | 125.8 | 125.63 | 125.66 | 369248.0 |
| 2015-11-12 | FGBS | Futures | 111.513 | 111.538 | 111.493 | 111.498 | 226865.0 |
| 2015-11-12 | FGBX | Futures | 154.31 | 155.76 | 154.19 | 155.35 | 27150.0 |
| 2015-11-12 | FMWO | Futures | 5657.0 | 5660.7 | 5612.5 | 5612.5 | 443.0 |
| 2015-11-12 | FOAT | Futures | 127.81 | 128.14 | 127.72 | 127.91 | 77920.0 |
| 2015-11-12 | FTDX | Futures | 1739.6 | 1749.6 | 1712.6 | 1718.3 | 237.0 |
| 2015-11-12 | FTI | Futures | 405.76 | 407.72 | 397.34 | 399.47 | 88.0 |
| 2015-11-12 | FTUK | Futures | 5036.5 | 5061.8 | 4920.7 | 4968.1 | 118595.0 |
| 2015-11-12 | FVSA | Futures | 2058.62 | 2181.66 | 2011.29 | 2101.21 | 9861.0 |
| 2015-11-12 | FXXP | Futures | 294.0 | 295.9 | 288.9 | 290.2 | 21615.0 |
| 2015-11-12 | G | Futures | 102.97 | 103.41 | 102.95 | 103.34 | 181012.0 |
| 2015-11-12 | GF | Futures | 322.838 | 329.015 | 318.881 | 322.163 | 7014.0 |
| 2015-11-12 | GSCI | Futures | 550.27 | 550.27 | 543.54 | 544.1 | 2838.0 |
| 2015-11-12 | HE | Futures | 83.756 | 85.476 | 82.821 | 83.905 | 25214.0 |
> showing 50 of 107 rows — these rows as CSV