PREVIEW / futures_daily / 2019-12-04
file: by_date/futures_daily/2019/2019-12-04.parquet size: 10 KB rows: 121
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-04 | ES | Futures | 3347.03 | 3377.07 | 3336.2 | 3367.87 | 1485940.0 |
| 2019-12-04 | NQ | Futures | 9517.55 | 9587.28 | 9473.47 | 9559.62 | 413647.0 |
| 2019-12-04 | YM | Futures | 28846.2 | 29107.6 | 28761.1 | 29019.4 | 182074.0 |
| 2019-12-04 | CL | Futures | 57.62 | 59.9 | 57.47 | 59.66 | 760541.0 |
| 2019-12-04 | GC | Futures | 1824.7 | 1833.0 | 1816.7 | 1821.0 | 319730.0 |
| 2019-12-04 | ZN | Futures | 128.737402 | 128.876761 | 128.210932 | 128.2419 | 40727.0 |
| 2019-12-04 | A6 | Futures | 0.70286 | 0.70348 | 0.69917 | 0.70317 | 121443.0 |
| 2019-12-04 | AD | Futures | 0.75763 | 0.76363 | 0.75748 | 0.76353 | 128514.0 |
| 2019-12-04 | ALI | Futures | 2167.58 | 2170.92 | 2143.89 | 2149.66 | 125.0 |
| 2019-12-04 | B | Futures | 49.26 | 51.22 | 49.2 | 50.81 | 319042.0 |
| 2019-12-04 | B6 | Futures | 1.322 | 1.3346 | 1.3205 | 1.3323 | 161578.0 |
| 2019-12-04 | BR | Futures | 0.19311 | 0.19324 | 0.19271 | 0.19271 | 15.0 |
| 2019-12-04 | BTC | Futures | 11036.4 | 11984.3 | 10660.2 | 10863.3 | 8673.0 |
| 2019-12-04 | BZ | Futures | 48.67 | 50.55 | 48.53 | 50.13 | 41730.0 |
| 2019-12-04 | C | Futures | 1750.0 | 1751.0 | 1735.0 | 1736.0 | 3317.0 |
| 2019-12-04 | CB | Futures | 245.832 | 245.832 | 244.535 | 245.655 | 50.0 |
| 2019-12-04 | CC | Futures | 1679.0 | 1684.0 | 1663.0 | 1666.0 | 14276.0 |
| 2019-12-04 | CNH | Futures | 7.0577 | 7.0688 | 7.0367 | 7.0397 | 1016.0 |
| 2019-12-04 | CSC | Futures | 3.428 | 3.443 | 3.426 | 3.431 | 38.0 |
| 2019-12-04 | CT | Futures | 60.92 | 61.68 | 60.92 | 61.54 | 16596.0 |
| 2019-12-04 | DC | Futures | 28.77 | 28.8 | 28.62 | 28.75 | 58.0 |
| 2019-12-04 | DX | Futures | 94.401 | 94.468 | 94.096 | 94.335 | 17807.0 |
| 2019-12-04 | E1 | Futures | 1.16657 | 1.16818 | 1.16289 | 1.1637 | 43450.0 |
| 2019-12-04 | E6 | Futures | 1.20195 | 1.20569 | 1.20033 | 1.2012 | 266105.0 |
| 2019-12-04 | E7 | Futures | 1.1958 | 1.1993 | 1.1942 | 1.195 | 3392.0 |
| 2019-12-04 | EBM | Futures | 203.03 | 203.72 | 202.61 | 202.75 | 1445.0 |
| 2019-12-04 | ED | Futures | 95.352 | 95.3569 | 95.3423 | 95.352 | 268084.0 |
| 2019-12-04 | ER | Futures | 98.401 | 98.401 | 98.391 | 98.396 | 44576.0 |
| 2019-12-04 | ESG | Futures | 275.21 | 277.18 | 275.21 | 277.18 | 10.0 |
| 2019-12-04 | EW | Futures | 2084.6 | 2112.0 | 2078.3 | 2101.0 | 16760.0 |
| 2019-12-04 | FBON | Futures | 143.31 | 143.42 | 142.94 | 143.06 | 1477.0 |
| 2019-12-04 | FBTP | Futures | 127.97 | 128.22 | 127.64 | 127.99 | 178810.0 |
| 2019-12-04 | FBTS | Futures | 108.038 | 108.153 | 107.96 | 108.066 | 108134.0 |
| 2019-12-04 | FCE | Futures | 5212.2 | 5258.4 | 5178.3 | 5245.7 | 86775.0 |
| 2019-12-04 | FDAX | Futures | 13761.3 | 13899.6 | 13709.1 | 13859.5 | 112678.0 |
| 2019-12-04 | FDIV | Futures | 159.31 | 159.78 | 159.22 | 159.68 | 155.0 |
| 2019-12-04 | FDXM | Futures | 13585.8 | 13717.0 | 13529.6 | 13678.5 | 48113.0 |
| 2019-12-04 | FESX | Futures | 3178.1 | 3215.0 | 3164.1 | 3206.2 | 1115317.0 |
| 2019-12-04 | FGBL | Futures | 165.25 | 165.49 | 164.76 | 164.9 | 967423.0 |
| 2019-12-04 | FGBM | Futures | 133.93 | 134.05 | 133.84 | 133.89 | 760195.0 |
| 2019-12-04 | FGBS | Futures | 112.714 | 112.734 | 112.689 | 112.709 | 504320.0 |
| 2019-12-04 | FGBX | Futures | 215.75 | 216.48 | 213.84 | 214.22 | 129412.0 |
| 2019-12-04 | FMWO | Futures | 7541.7 | 7603.1 | 7513.2 | 7590.6 | 5701.0 |
| 2019-12-04 | FOAT | Futures | 152.52 | 152.82 | 152.13 | 152.26 | 207091.0 |
| 2019-12-04 | FTDX | Futures | 2976.6 | 3000.8 | 2976.6 | 2997.9 | 60.0 |
| 2019-12-04 | FTI | Futures | 560.85 | 567.22 | 558.41 | 565.7 | 30688.0 |
| 2019-12-04 | FTUK | Futures | 6647.1 | 6674.9 | 6610.5 | 6654.0 | 127047.0 |
| 2019-12-04 | FVSA | Futures | 152.04 | 155.08 | 140.38 | 143.42 | 45135.0 |
| 2019-12-04 | FXXP | Futures | 361.9 | 365.5 | 360.2 | 364.4 | 57030.0 |
| 2019-12-04 | G | Futures | 121.43 | 121.63 | 120.58 | 120.7 | 208750.0 |
> showing 50 of 121 rows — these rows as CSV