PREVIEW / futures_daily / 2011-01-28
file: by_date/futures_daily/2011/2011-01-28.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-28 | ES | Futures | 1274.95 | 1279.13 | 1250.58 | 1251.57 | 3238629.0 |
| 2011-01-28 | NQ | Futures | 2636.18 | 2646.39 | 2563.52 | 2574.87 | 434902.0 |
| 2011-01-28 | YM | Futures | 11169.4 | 11198.4 | 11000.0 | 11020.6 | 172262.0 |
| 2011-01-28 | CL | Futures | 173.49 | 182.54 | 173.15 | 181.75 | 584789.0 |
| 2011-01-28 | GC | Futures | 1784.5 | 1829.4 | 1776.6 | 1820.8 | 251014.0 |
| 2011-01-28 | ZN | Futures | 100.322562 | 100.920494 | 99.9846 | 100.790508 | 1402926.0 |
| 2011-01-28 | A6 | Futures | 0.83639 | 0.84249 | 0.8335 | 0.83817 | 115096.0 |
| 2011-01-28 | AD | Futures | 0.99691 | 0.99781 | 0.98977 | 0.99135 | 85639.0 |
| 2011-01-28 | B | Futures | 83.01 | 85.07 | 82.88 | 84.83 | 126773.0 |
| 2011-01-28 | B6 | Futures | 1.6524 | 1.6558 | 1.6411 | 1.6455 | 122793.0 |
| 2011-01-28 | BFX | Futures | 3086.4 | 3089.3 | 3056.2 | 3070.9 | 25.0 |
| 2011-01-28 | BR | Futures | 0.25545 | 0.25545 | 0.25394 | 0.25394 | 39.0 |
| 2011-01-28 | BZ | Futures | 89.16 | 90.64 | 88.51 | 90.64 | 1316.0 |
| 2011-01-28 | C | Futures | 2394.0 | 2415.0 | 2356.0 | 2364.0 | 5476.0 |
| 2011-01-28 | CB | Futures | 116.162 | 116.162 | 114.989 | 115.781 | 20.0 |
| 2011-01-28 | CC | Futures | 2721.0 | 2725.0 | 2642.0 | 2659.0 | 10452.0 |
| 2011-01-28 | CSC | Futures | 4.031 | 4.031 | 4.008 | 4.017 | 25.0 |
| 2011-01-28 | CT | Futures | 145.25 | 146.72 | 141.07 | 141.27 | 13049.0 |
| 2011-01-28 | DC | Futures | 28.71 | 28.77 | 28.43 | 28.61 | 637.0 |
| 2011-01-28 | DX | Futures | 77.705 | 78.284 | 77.565 | 78.139 | 25466.0 |
| 2011-01-28 | E1 | Futures | 1.38623 | 1.39462 | 1.3844 | 1.39187 | 31405.0 |
| 2011-01-28 | E6 | Futures | 1.62373 | 1.6255 | 1.6061 | 1.61001 | 368088.0 |
| 2011-01-28 | E7 | Futures | 1.6112 | 1.6133 | 1.594 | 1.598 | 6086.0 |
| 2011-01-28 | EBM | Futures | 239.66 | 243.3 | 239.44 | 241.48 | 5042.0 |
| 2011-01-28 | ED | Futures | 94.8384 | 94.8432 | 94.8289 | 94.8337 | 207550.0 |
| 2011-01-28 | ER | Futures | 97.242 | 97.262 | 97.227 | 97.242 | 191915.0 |
| 2011-01-28 | EW | Futures | 919.1 | 922.3 | 900.8 | 902.9 | 27582.0 |
| 2011-01-28 | FBTP | Futures | 63.6 | 63.81 | 63.53 | 63.77 | 7177.0 |
| 2011-01-28 | FCE | Futures | 2713.2 | 2719.8 | 2651.7 | 2670.8 | 154401.0 |
| 2011-01-28 | FDAX | Futures | 7669.5 | 7693.6 | 7581.7 | 7619.2 | 149613.0 |
| 2011-01-28 | FESX | Futures | 1860.7 | 1868.2 | 1822.8 | 1837.7 | 1446293.0 |
| 2011-01-28 | FEU3 | Futures | 97.795 | 97.8 | 97.795 | 97.8 | 5.0 |
| 2011-01-28 | FGBL | Futures | 97.83 | 98.11 | 97.55 | 97.99 | 824471.0 |
| 2011-01-28 | FGBM | Futures | 103.28 | 103.43 | 103.05 | 103.33 | 554116.0 |
| 2011-01-28 | FGBS | Futures | 106.665 | 106.709 | 106.532 | 106.65 | 786457.0 |
| 2011-01-28 | FGBX | Futures | 95.18 | 95.92 | 94.81 | 95.63 | 6328.0 |
| 2011-01-28 | FTDX | Futures | 772.7 | 772.7 | 757.8 | 763.1 | 988.0 |
| 2011-01-28 | FTI | Futures | 292.82 | 293.22 | 288.87 | 290.2 | 32458.0 |
| 2011-01-28 | FTUK | Futures | 4120.0 | 4120.4 | 4030.4 | 4064.8 | 136153.0 |
| 2011-01-28 | FXXP | Futures | 182.3 | 182.9 | 181.2 | 181.6 | 1510.0 |
| 2011-01-28 | G | Futures | 80.45 | 80.66 | 80.27 | 80.62 | 81310.0 |
| 2011-01-28 | GF | Futures | 309.883 | 312.719 | 309.266 | 311.363 | 2579.0 |
| 2011-01-28 | GSCI | Futures | 1006.39 | 1025.42 | 1006.39 | 1023.11 | 224.0 |
| 2011-01-28 | HE | Futures | 105.335 | 107.698 | 105.16 | 106.91 | 18904.0 |
| 2011-01-28 | HG | Futures | 5.7574 | 5.8733 | 5.7121 | 5.828 | 42515.0 |
| 2011-01-28 | HO | Futures | 2.2228 | 2.264 | 2.2099 | 2.2532 | 67183.0 |
| 2011-01-28 | HRC | Futures | 2709.3 | 2709.3 | 2709.3 | 2709.3 | 0.0 |
| 2011-01-28 | J1 | Futures | 0.0151611 | 0.0153219 | 0.0151473 | 0.0152892 | 160146.0 |
| 2011-01-28 | J7 | Futures | 0.015055 | 0.015212 | 0.015055 | 0.015181 | 481.0 |
| 2011-01-28 | JB | Futures | 120.54 | 121.0 | 120.48 | 120.89 | 1981.0 |
> showing 50 of 94 rows — these rows as CSV