PREVIEW / futures_daily / 2019-12-13
file: by_date/futures_daily/2019/2019-12-13.parquet size: 10 KB rows: 117
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-13 | ES | Futures | 3437.96 | 3447.98 | 3417.39 | 3433.9 | 1834941.0 |
| 2019-12-13 | NQ | Futures | 9778.29 | 9822.95 | 9721.25 | 9788.66 | 335038.0 |
| 2019-12-13 | YM | Futures | 29585.3 | 29728.2 | 29448.8 | 29579.0 | 210338.0 |
| 2019-12-13 | CL | Futures | 60.61 | 61.76 | 60.52 | 61.34 | 512288.0 |
| 2019-12-13 | GC | Futures | 1809.5 | 1823.9 | 1803.0 | 1822.3 | 356682.0 |
| 2019-12-13 | ZN | Futures | 127.003057 | 127.916748 | 126.770763 | 127.885776 | 2715224.0 |
| 2019-12-13 | A6 | Futures | 0.71168 | 0.7126 | 0.70512 | 0.70563 | 151478.0 |
| 2019-12-13 | AD | Futures | 0.76554 | 0.76665 | 0.76348 | 0.76459 | 95533.0 |
| 2019-12-13 | ALI | Futures | 2179.12 | 2179.12 | 2155.74 | 2157.56 | 184.0 |
| 2019-12-13 | B | Futures | 52.07 | 53.06 | 52.02 | 52.6 | 232747.0 |
| 2019-12-13 | B6 | Futures | 1.3674 | 1.3739 | 1.3533 | 1.3566 | 251342.0 |
| 2019-12-13 | BR | Futures | 0.19851 | 0.19851 | 0.19595 | 0.19685 | 604.0 |
| 2019-12-13 | BTC | Futures | 10855.8 | 11036.4 | 10833.2 | 10931.0 | 3653.0 |
| 2019-12-13 | BZ | Futures | 51.26 | 52.35 | 51.24 | 51.9 | 34575.0 |
| 2019-12-13 | C | Futures | 1692.0 | 1708.0 | 1676.0 | 1707.0 | 14339.0 |
| 2019-12-13 | CB | Futures | 246.303 | 246.303 | 245.272 | 245.832 | 19.0 |
| 2019-12-13 | CC | Futures | 1665.0 | 1687.0 | 1655.0 | 1682.0 | 15969.0 |
| 2019-12-13 | CNH | Futures | 6.9324 | 7.0077 | 6.9281 | 6.9863 | 1626.0 |
| 2019-12-13 | CSC | Futures | 3.309 | 3.309 | 3.309 | 3.309 | 36.0 |
| 2019-12-13 | CT | Futures | 64.2 | 64.49 | 63.19 | 63.54 | 31004.0 |
| 2019-12-13 | DC | Futures | 27.86 | 27.91 | 27.72 | 27.75 | 82.0 |
| 2019-12-13 | DX | Futures | 93.585 | 93.963 | 93.463 | 93.9 | 27496.0 |
| 2019-12-13 | E1 | Futures | 1.16862 | 1.17307 | 1.16633 | 1.16896 | 39434.0 |
| 2019-12-13 | E6 | Futures | 1.21196 | 1.21341 | 1.20458 | 1.2056 | 297265.0 |
| 2019-12-13 | E7 | Futures | 1.202 | 1.2069 | 1.1983 | 1.1993 | 4553.0 |
| 2019-12-13 | EBM | Futures | 201.65 | 202.75 | 201.1 | 201.38 | 18558.0 |
| 2019-12-13 | ED | Futures | 95.2986 | 95.3277 | 95.2889 | 95.318 | 477522.0 |
| 2019-12-13 | ER | Futures | 98.382 | 98.386 | 98.372 | 98.377 | 89640.0 |
| 2019-12-13 | EW | Futures | 2150.8 | 2161.0 | 2129.0 | 2136.2 | 47233.0 |
| 2019-12-13 | FBON | Futures | 142.26 | 143.52 | 142.26 | 143.32 | 289.0 |
| 2019-12-13 | FBTP | Futures | 128.2 | 129.4 | 128.12 | 129.24 | 86991.0 |
| 2019-12-13 | FBTS | Futures | 108.105 | 108.297 | 108.105 | 108.268 | 37237.0 |
| 2019-12-13 | FCE | Futures | 5381.0 | 5405.9 | 5341.6 | 5352.1 | 8754.0 |
| 2019-12-13 | FDAX | Futures | 14064.7 | 14200.8 | 13984.0 | 14004.0 | 170859.0 |
| 2019-12-13 | FDIV | Futures | 161.54 | 161.54 | 161.17 | 161.17 | 40.0 |
| 2019-12-13 | FDXM | Futures | 13894.8 | 14032.6 | 13843.6 | 13856.6 | 1394.0 |
| 2019-12-13 | FESX | Futures | 3273.1 | 3310.1 | 3266.0 | 3271.3 | 820198.0 |
| 2019-12-13 | FEU3 | Futures | 99.09 | 99.09 | 99.09 | 99.09 | 42.0 |
| 2019-12-13 | FGBL | Futures | 163.55 | 164.58 | 163.09 | 164.38 | 729864.0 |
| 2019-12-13 | FGBM | Futures | 133.45 | 133.69 | 133.36 | 133.62 | 493054.0 |
| 2019-12-13 | FGBS | Futures | 112.654 | 112.679 | 112.639 | 112.664 | 240651.0 |
| 2019-12-13 | FGBX | Futures | 210.39 | 213.38 | 209.14 | 212.84 | 61600.0 |
| 2019-12-13 | FMWO | Futures | 7754.3 | 7772.5 | 7703.2 | 7706.6 | 9909.0 |
| 2019-12-13 | FOAT | Futures | 150.99 | 152.13 | 150.92 | 151.91 | 158108.0 |
| 2019-12-13 | FTDX | Futures | 3052.4 | 3057.9 | 3052.4 | 3056.9 | 6.0 |
| 2019-12-13 | FTI | Futures | 581.26 | 581.74 | 577.0 | 577.25 | 2614.0 |
| 2019-12-13 | FTUK | Futures | 6773.6 | 6912.4 | 6747.8 | 6836.4 | 105590.0 |
| 2019-12-13 | FVSA | Futures | 133.94 | 138.16 | 130.66 | 136.75 | 21564.0 |
| 2019-12-13 | FXXP | Futures | 375.7 | 376.5 | 373.4 | 374.0 | 59100.0 |
| 2019-12-13 | G | Futures | 119.16 | 120.24 | 118.99 | 119.97 | 247151.0 |
> showing 50 of 117 rows — these rows as CSV