PREVIEW / futures_daily / 2020-08-07
file: by_date/futures_daily/2020/2020-08-07.parquet size: 10 KB rows: 120
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-07 | ES | Futures | 3763.68 | 3768.18 | 3739.48 | 3764.81 | 1615367.0 |
| 2020-08-07 | NQ | Futures | 13069.38 | 13095.79 | 12807.95 | 12909.5 | 532554.0 |
| 2020-08-07 | YM | Futures | 29248.6 | 29333.3 | 29048.2 | 29292.5 | 188769.0 |
| 2020-08-07 | CL | Futures | 30.62 | 30.81 | 29.96 | 30.08 | 398997.0 |
| 2020-08-07 | GC | Futures | 2452.3 | 2467.4 | 2391.3 | 2395.1 | 398127.0 |
| 2020-08-07 | ZN | Futures | 138.883858 | 139.023222 | 138.651585 | 138.698039 | 889708.0 |
| 2020-08-07 | A6 | Futures | 0.74446 | 0.74518 | 0.73499 | 0.73551 | 104935.0 |
| 2020-08-07 | AD | Futures | 0.76291 | 0.76302 | 0.75758 | 0.7584 | 62310.0 |
| 2020-08-07 | ALI | Futures | 2180.25 | 2180.25 | 2152.03 | 2174.18 | 157.0 |
| 2020-08-07 | B | Futures | 29.11 | 29.2 | 28.54 | 28.62 | 171719.0 |
| 2020-08-07 | B6 | Futures | 1.3353 | 1.3353 | 1.3212 | 1.3256 | 93194.0 |
| 2020-08-07 | BR | Futures | 0.14877 | 0.14896 | 0.14556 | 0.14591 | 5392.0 |
| 2020-08-07 | BTC | Futures | 16403.2 | 16533.1 | 15589.2 | 15835.4 | 10007.0 |
| 2020-08-07 | BZ | Futures | 28.4 | 28.49 | 27.86 | 27.95 | 20363.0 |
| 2020-08-07 | C | Futures | 1534.0 | 1553.0 | 1533.0 | 1549.0 | 6501.0 |
| 2020-08-07 | CB | Futures | 174.097 | 174.124 | 172.252 | 172.252 | 49.0 |
| 2020-08-07 | CC | Futures | 1651.0 | 1659.0 | 1635.0 | 1657.0 | 31848.0 |
| 2020-08-07 | CNH | Futures | 6.8569 | 6.8883 | 6.8569 | 6.8817 | 908.0 |
| 2020-08-07 | CSC | Futures | 3.531 | 3.531 | 3.391 | 3.41 | 149.0 |
| 2020-08-07 | CT | Futures | 65.48 | 65.48 | 62.48 | 62.58 | 27.0 |
| 2020-08-07 | DC | Futures | 28.79 | 28.99 | 27.56 | 27.68 | 581.0 |
| 2020-08-07 | DX | Futures | 89.624 | 90.435 | 89.581 | 90.23 | 25839.0 |
| 2020-08-07 | E1 | Futures | 1.25056 | 1.25056 | 1.24148 | 1.24477 | 28010.0 |
| 2020-08-07 | E6 | Futures | 1.2756 | 1.27603 | 1.2623 | 1.2652 | 237046.0 |
| 2020-08-07 | E7 | Futures | 1.2692 | 1.2695 | 1.256 | 1.2589 | 8802.0 |
| 2020-08-07 | EBM | Futures | 214.66 | 214.96 | 213.17 | 213.17 | 13402.0 |
| 2020-08-07 | ED | Futures | 96.4523 | 96.4572 | 96.4475 | 96.4523 | 75863.0 |
| 2020-08-07 | ER | Futures | 98.386 | 98.391 | 98.382 | 98.386 | 42121.0 |
| 2020-08-07 | ESG | Futures | 302.56 | 304.23 | 302.56 | 304.23 | 9.0 |
| 2020-08-07 | EW | Futures | 2031.4 | 2061.3 | 2020.0 | 2058.8 | 11595.0 |
| 2020-08-07 | FBON | Futures | 147.33 | 147.36 | 147.09 | 147.2 | 68.0 |
| 2020-08-07 | FBTP | Futures | 133.71 | 134.02 | 133.49 | 133.89 | 49007.0 |
| 2020-08-07 | FBTS | Futures | 108.89 | 108.948 | 108.851 | 108.929 | 24194.0 |
| 2020-08-07 | FCE | Futures | 4718.4 | 4737.3 | 4676.4 | 4722.8 | 47485.0 |
| 2020-08-07 | FDAX | Futures | 13425.4 | 13493.4 | 13288.8 | 13438.6 | 63932.0 |
| 2020-08-07 | FDIV | Futures | 144.31 | 144.36 | 144.31 | 144.36 | 100.0 |
| 2020-08-07 | FDXM | Futures | 13392.8 | 13444.7 | 13241.4 | 13390.2 | 37407.0 |
| 2020-08-07 | FESX | Futures | 2996.4 | 3008.4 | 2967.8 | 2993.6 | 587134.0 |
| 2020-08-07 | FGBL | Futures | 169.48 | 169.76 | 169.18 | 169.28 | 394367.0 |
| 2020-08-07 | FGBM | Futures | 135.04 | 135.13 | 134.92 | 134.96 | 236667.0 |
| 2020-08-07 | FGBS | Futures | 112.769 | 112.795 | 112.749 | 112.764 | 311154.0 |
| 2020-08-07 | FGBX | Futures | 231.65 | 232.64 | 230.25 | 230.73 | 30387.0 |
| 2020-08-07 | FMWO | Futures | 8240.0 | 8286.2 | 8230.5 | 8260.1 | 1823.0 |
| 2020-08-07 | FOAT | Futures | 156.98 | 157.15 | 156.73 | 156.82 | 108131.0 |
| 2020-08-07 | FTDX | Futures | 3069.5 | 3120.1 | 3069.5 | 3113.9 | 15.0 |
| 2020-08-07 | FTI | Futures | 520.49 | 524.13 | 517.22 | 521.71 | 19364.0 |
| 2020-08-07 | FTUK | Futures | 5688.3 | 5696.8 | 5637.3 | 5663.3 | 65963.0 |
| 2020-08-07 | FVSA | Futures | 222.16 | 228.04 | 218.08 | 221.7 | 10920.0 |
| 2020-08-07 | FXXP | Futures | 333.6 | 336.1 | 331.9 | 334.5 | 33467.0 |
| 2020-08-07 | G | Futures | 127.88 | 128.01 | 127.37 | 127.55 | 169570.0 |
> showing 50 of 120 rows — these rows as CSV