PREVIEW / futures_daily / 2020-05-29
file: by_date/futures_daily/2020/2020-05-29.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 |
|---|---|---|---|---|---|---|---|
| 2020-05-29 | ES | Futures | 3359.29 | 3383.91 | 3310.61 | 3365.93 | 2258009.0 |
| 2020-05-29 | NQ | Futures | 10837.87 | 10994.93 | 10744.43 | 10960.25 | 529700.0 |
| 2020-05-29 | YM | Futures | 27154.4 | 27209.9 | 26666.7 | 27079.7 | 268921.0 |
| 2020-05-29 | CL | Futures | 24.42 | 25.93 | 23.46 | 25.73 | 443647.0 |
| 2020-05-29 | GC | Futures | 2080.3 | 2106.5 | 2071.4 | 2103.1 | 150112.0 |
| 2020-05-29 | ZN | Futures | 137.377047 | 137.716631 | 137.361612 | 137.68576 | 134842.0 |
| 2020-05-29 | A6 | Futures | 0.68031 | 0.68668 | 0.68001 | 0.68422 | 116170.0 |
| 2020-05-29 | AD | Futures | 0.7359 | 0.73889 | 0.73255 | 0.73529 | 85023.0 |
| 2020-05-29 | ALI | Futures | 1836.15 | 1836.15 | 1836.15 | 1836.15 | 0.0 |
| 2020-05-29 | B | Futures | 23.58 | 24.98 | 22.81 | 24.77 | 252890.0 |
| 2020-05-29 | B6 | Futures | 1.2512 | 1.2581 | 1.2475 | 1.2512 | 119242.0 |
| 2020-05-29 | BFX | Futures | 3276.4 | 3276.4 | 3226.3 | 3241.5 | 2.0 |
| 2020-05-29 | BR | Futures | 0.1473 | 0.14754 | 0.14579 | 0.14754 | 97.0 |
| 2020-05-29 | BTC | Futures | 13261.6 | 13518.9 | 13073.8 | 13171.2 | 3864.0 |
| 2020-05-29 | BZ | Futures | 23.03 | 24.4 | 22.28 | 24.19 | 32101.0 |
| 2020-05-29 | C | Futures | 1878.0 | 1884.0 | 1841.0 | 1875.0 | 8659.0 |
| 2020-05-29 | CB | Futures | 194.184 | 199.293 | 194.184 | 199.293 | 12.0 |
| 2020-05-29 | CC | Futures | 1585.0 | 1609.0 | 1563.0 | 1603.0 | 20256.0 |
| 2020-05-29 | CNH | Futures | 7.1062 | 7.1137 | 7.0751 | 7.0916 | 907.0 |
| 2020-05-29 | CSC | Futures | 3.391 | 3.441 | 3.391 | 3.43 | 66.0 |
| 2020-05-29 | CT | Futures | 56.05 | 56.27 | 55.13 | 56.14 | 16745.0 |
| 2020-05-29 | DC | Futures | 27.78 | 28.48 | 27.78 | 28.4 | 146.0 |
| 2020-05-29 | DX | Futures | 95.218 | 95.295 | 94.701 | 95.093 | 21708.0 |
| 2020-05-29 | E1 | Futures | 1.18203 | 1.18647 | 1.18055 | 1.18442 | 26718.0 |
| 2020-05-29 | E6 | Futures | 1.19127 | 1.1982 | 1.19009 | 1.1931 | 225494.0 |
| 2020-05-29 | E7 | Futures | 1.1849 | 1.192 | 1.1839 | 1.1869 | 9648.0 |
| 2020-05-29 | EBM | Futures | 224.84 | 226.34 | 223.35 | 225.44 | 12651.0 |
| 2020-05-29 | ED | Futures | 96.3871 | 96.3968 | 96.3823 | 96.3895 | 128437.0 |
| 2020-05-29 | ER | Futures | 98.284 | 98.308 | 98.284 | 98.303 | 49738.0 |
| 2020-05-29 | ESG | Futures | 271.54 | 274.81 | 270.71 | 274.72 | 65.0 |
| 2020-05-29 | EW | Futures | 1882.9 | 1890.6 | 1842.2 | 1867.6 | 14585.0 |
| 2020-05-29 | FBON | Futures | 143.45 | 143.81 | 143.15 | 143.45 | 641.0 |
| 2020-05-29 | FBTP | Futures | 127.44 | 127.77 | 126.67 | 127.02 | 147697.0 |
| 2020-05-29 | FBTS | Futures | 107.836 | 107.893 | 107.624 | 107.701 | 82969.0 |
| 2020-05-29 | FCE | Futures | 4586.4 | 4622.3 | 4526.7 | 4550.5 | 78939.0 |
| 2020-05-29 | FDAX | Futures | 12347.5 | 12406.2 | 12174.0 | 12271.3 | 95953.0 |
| 2020-05-29 | FDIV | Futures | 131.01 | 131.01 | 130.55 | 130.55 | 215.0 |
| 2020-05-29 | FDXM | Futures | 12399.5 | 12465.4 | 12236.9 | 12329.9 | 64020.0 |
| 2020-05-29 | FESX | Futures | 2810.4 | 2835.2 | 2775.5 | 2795.7 | 1522146.0 |
| 2020-05-29 | FGBL | Futures | 167.34 | 167.75 | 167.19 | 167.64 | 810639.0 |
| 2020-05-29 | FGBM | Futures | 134.36 | 134.53 | 134.32 | 134.5 | 473023.0 |
| 2020-05-29 | FGBS | Futures | 112.699 | 112.759 | 112.689 | 112.749 | 500409.0 |
| 2020-05-29 | FGBX | Futures | 223.77 | 225.12 | 223.64 | 224.85 | 68235.0 |
| 2020-05-29 | FMWO | Futures | 7446.8 | 7479.8 | 7363.3 | 7405.6 | 5986.0 |
| 2020-05-29 | FOAT | Futures | 153.37 | 153.77 | 153.23 | 153.62 | 296960.0 |
| 2020-05-29 | FTDX | Futures | 3188.2 | 3229.2 | 3178.1 | 3210.5 | 200.0 |
| 2020-05-29 | FTI | Futures | 496.15 | 499.79 | 492.1 | 495.63 | 32459.0 |
| 2020-05-29 | FTUK | Futures | 5817.7 | 5837.5 | 5694.6 | 5715.3 | 136642.0 |
| 2020-05-29 | FVSA | Futures | 263.75 | 275.97 | 263.3 | 270.99 | 13851.0 |
| 2020-05-29 | FXXP | Futures | 325.8 | 327.4 | 322.2 | 323.3 | 91476.0 |
> showing 50 of 121 rows — these rows as CSV