PREVIEW / futures_daily / 2016-10-24
file: by_date/futures_daily/2016/2016-10-24.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-24 | ES | Futures | 2311.37 | 2324.35 | 2308.94 | 2319.21 | 1010790.0 |
| 2016-10-24 | NQ | Futures | 5712.72 | 5785.2 | 5707.42 | 5778.13 | 182257.0 |
| 2016-10-24 | YM | Futures | 18984.9 | 19107.7 | 18964.9 | 19041.6 | 111904.0 |
| 2016-10-24 | CL | Futures | 55.49 | 55.63 | 54.15 | 55.13 | 623398.0 |
| 2016-10-24 | GC | Futures | 1625.4 | 1633.0 | 1616.7 | 1621.3 | 156822.0 |
| 2016-10-24 | ZN | Futures | 126.815681 | 126.937283 | 126.542076 | 126.633278 | 807829.0 |
| 2016-10-24 | A6 | Futures | 0.77469 | 0.77856 | 0.77356 | 0.77479 | 58011.0 |
| 2016-10-24 | AD | Futures | 0.76808 | 0.77125 | 0.7648 | 0.76608 | 72833.0 |
| 2016-10-24 | ALI | Futures | 2179.53 | 2179.53 | 2179.53 | 2179.53 | 0.0 |
| 2016-10-24 | B | Futures | 40.16 | 40.25 | 39.08 | 39.83 | 277239.0 |
| 2016-10-24 | B6 | Futures | 1.2881 | 1.2908 | 1.284 | 1.2881 | 70368.0 |
| 2016-10-24 | BR | Futures | 0.2151 | 0.21753 | 0.2151 | 0.21726 | 625.0 |
| 2016-10-24 | BZ | Futures | 39.98 | 40.01 | 38.86 | 39.6 | 39723.0 |
| 2016-10-24 | C | Futures | 2382.0 | 2384.0 | 2359.0 | 2380.0 | 4934.0 |
| 2016-10-24 | CB | Futures | 228.149 | 228.769 | 228.149 | 228.769 | 5.0 |
| 2016-10-24 | CC | Futures | 2009.0 | 2015.0 | 1981.0 | 2001.0 | 10543.0 |
| 2016-10-24 | CNH | Futures | 7.3123 | 7.3183 | 7.3045 | 7.3088 | 60.0 |
| 2016-10-24 | CSC | Futures | 3.698 | 3.698 | 3.665 | 3.668 | 66.0 |
| 2016-10-24 | CT | Futures | 77.26 | 77.51 | 76.77 | 77.04 | 11586.0 |
| 2016-10-24 | DC | Futures | 29.15 | 29.17 | 28.84 | 28.94 | 83.0 |
| 2016-10-24 | DX | Futures | 91.844 | 91.979 | 91.713 | 91.911 | 15328.0 |
| 2016-10-24 | E1 | Futures | 1.25665 | 1.26001 | 1.2549 | 1.25715 | 16471.0 |
| 2016-10-24 | E6 | Futures | 1.26391 | 1.2664 | 1.26171 | 1.26374 | 115649.0 |
| 2016-10-24 | E7 | Futures | 1.2572 | 1.2595 | 1.255 | 1.2569 | 1903.0 |
| 2016-10-24 | EBM | Futures | 192.11 | 192.7 | 190.06 | 190.64 | 13669.0 |
| 2016-10-24 | ED | Futures | 95.6249 | 95.6297 | 95.62 | 95.6249 | 167844.0 |
| 2016-10-24 | ER | Futures | 98.279 | 98.283 | 98.274 | 98.279 | 41722.0 |
| 2016-10-24 | EW | Futures | 1622.8 | 1640.0 | 1621.9 | 1630.0 | 12450.0 |
| 2016-10-24 | FBON | Futures | 124.54 | 124.88 | 124.41 | 124.45 | 817.0 |
| 2016-10-24 | FBTP | Futures | 108.7 | 108.89 | 108.41 | 108.52 | 81963.0 |
| 2016-10-24 | FBTS | Futures | 101.221 | 101.248 | 101.203 | 101.212 | 11809.0 |
| 2016-10-24 | FCE | Futures | 4041.5 | 4077.5 | 4041.5 | 4052.2 | 66071.0 |
| 2016-10-24 | FDAX | Futures | 11306.1 | 11431.9 | 11305.6 | 11375.9 | 69392.0 |
| 2016-10-24 | FDXM | Futures | 11289.1 | 11406.1 | 11282.8 | 11351.3 | 18837.0 |
| 2016-10-24 | FESX | Futures | 2461.4 | 2484.6 | 2459.8 | 2473.4 | 748234.0 |
| 2016-10-24 | FEU3 | Futures | 98.956 | 98.956 | 98.956 | 98.956 | 120.0 |
| 2016-10-24 | FGBL | Futures | 150.1 | 150.23 | 149.61 | 149.7 | 607305.0 |
| 2016-10-24 | FGBM | Futures | 128.91 | 128.95 | 128.77 | 128.8 | 303342.0 |
| 2016-10-24 | FGBS | Futures | 111.927 | 111.937 | 111.902 | 111.912 | 101046.0 |
| 2016-10-24 | FGBX | Futures | 183.39 | 183.81 | 181.04 | 181.35 | 37415.0 |
| 2016-10-24 | FMWO | Futures | 5703.8 | 5708.6 | 5696.5 | 5700.1 | 780.0 |
| 2016-10-24 | FOAT | Futures | 137.83 | 138.02 | 137.4 | 137.49 | 117898.0 |
| 2016-10-24 | FTDX | Futures | 1753.8 | 1754.8 | 1731.8 | 1731.8 | 69.0 |
| 2016-10-24 | FTI | Futures | 419.32 | 424.29 | 419.32 | 421.11 | 24318.0 |
| 2016-10-24 | FTUK | Futures | 5919.6 | 5942.8 | 5868.1 | 5874.8 | 109115.0 |
| 2016-10-24 | FVSA | Futures | 1326.4 | 1326.4 | 1292.39 | 1307.85 | 12130.0 |
| 2016-10-24 | FXXP | Futures | 284.1 | 285.8 | 283.1 | 283.4 | 22744.0 |
| 2016-10-24 | G | Futures | 113.4 | 113.57 | 112.96 | 113.09 | 149939.0 |
| 2016-10-24 | GF | Futures | 261.997 | 264.896 | 261.084 | 263.124 | 3561.0 |
| 2016-10-24 | GSCI | Futures | 519.46 | 520.43 | 517.87 | 519.95 | 123.0 |
> showing 50 of 109 rows — these rows as CSV