PREVIEW / futures_daily / 2021-08-02
file: by_date/futures_daily/2021/2021-08-02.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 |
|---|---|---|---|---|---|---|---|
| 2021-08-02 | ES | Futures | 4941.99 | 4968.12 | 4920.35 | 4923.16 | 1193301.0 |
| 2021-08-02 | NQ | Futures | 17273.87 | 17370.2 | 17227.14 | 17250.79 | 446142.0 |
| 2021-08-02 | YM | Futures | 37812.4 | 38040.1 | 37619.4 | 37648.7 | 145770.0 |
| 2021-08-02 | CL | Futures | 53.49 | 53.52 | 51.06 | 51.58 | 448200.0 |
| 2021-08-02 | GC | Futures | 2119.8 | 2127.0 | 2109.5 | 2125.9 | 159755.0 |
| 2021-08-02 | ZN | Futures | 136.160565 | 136.793134 | 136.081494 | 136.634992 | 1379439.0 |
| 2021-08-02 | A6 | Futures | 0.75285 | 0.75721 | 0.75177 | 0.75541 | 68563.0 |
| 2021-08-02 | AD | Futures | 0.81261 | 0.81413 | 0.81008 | 0.81048 | 51081.0 |
| 2021-08-02 | ALI | Futures | 3024.71 | 3044.41 | 3018.99 | 3026.42 | 1886.0 |
| 2021-08-02 | B | Futures | 50.21 | 50.21 | 48.16 | 48.54 | 304873.0 |
| 2021-08-02 | B6 | Futures | 1.411 | 1.4147 | 1.409 | 1.4106 | 68467.0 |
| 2021-08-02 | BR | Futures | 0.15302 | 0.15591 | 0.15226 | 0.15459 | 11774.0 |
| 2021-08-02 | BTC | Futures | 55224.3 | 55646.6 | 51912.3 | 52535.8 | 4781.0 |
| 2021-08-02 | BZ | Futures | 48.87 | 48.97 | 47.0 | 47.38 | 38106.0 |
| 2021-08-02 | C | Futures | 1436.0 | 1436.0 | 1408.0 | 1423.0 | 5551.0 |
| 2021-08-02 | CB | Futures | 131.138 | 134.728 | 131.138 | 133.585 | 22.0 |
| 2021-08-02 | CC | Futures | 1547.0 | 1553.0 | 1530.0 | 1550.0 | 21280.0 |
| 2021-08-02 | CNH | Futures | 6.2571 | 6.2626 | 6.25 | 6.2555 | 438.0 |
| 2021-08-02 | CSC | Futures | 2.389 | 2.401 | 2.363 | 2.367 | 228.0 |
| 2021-08-02 | CT | Futures | 83.32 | 83.87 | 83.0 | 83.3 | 12.0 |
| 2021-08-02 | DC | Futures | 21.38 | 21.47 | 20.97 | 21.06 | 625.0 |
| 2021-08-02 | DX | Futures | 89.071 | 89.1 | 88.849 | 88.989 | 14275.0 |
| 2021-08-02 | E1 | Futures | 1.2402 | 1.24391 | 1.23987 | 1.24211 | 18111.0 |
| 2021-08-02 | E6 | Futures | 1.26318 | 1.26648 | 1.26243 | 1.26392 | 108058.0 |
| 2021-08-02 | E7 | Futures | 1.2568 | 1.2601 | 1.2562 | 1.2576 | 2731.0 |
| 2021-08-02 | EBM | Futures | 331.0 | 336.88 | 329.52 | 336.14 | 20866.0 |
| 2021-08-02 | ED | Futures | 96.549 | 96.549 | 96.5442 | 96.5442 | 72234.0 |
| 2021-08-02 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.465 | 47318.0 |
| 2021-08-02 | ESG | Futures | 410.49 | 410.55 | 407.1 | 407.14 | 576.0 |
| 2021-08-02 | EW | Futures | 2906.1 | 2943.3 | 2884.2 | 2886.5 | 8251.0 |
| 2021-08-02 | FBON | Futures | 151.01 | 151.52 | 150.93 | 151.4 | 61.0 |
| 2021-08-02 | FBTP | Futures | 141.28 | 141.66 | 140.95 | 141.54 | 77551.0 |
| 2021-08-02 | FBTS | Futures | 110.39 | 110.477 | 110.37 | 110.468 | 30012.0 |
| 2021-08-02 | FCE | Futures | 6626.6 | 6676.5 | 6623.1 | 6660.0 | 50772.0 |
| 2021-08-02 | FDAX | Futures | 16702.7 | 16813.0 | 16603.1 | 16687.7 | 73591.0 |
| 2021-08-02 | FDIV | Futures | 186.62 | 186.62 | 185.34 | 185.34 | 20.0 |
| 2021-08-02 | FDXM | Futures | 16616.6 | 16729.6 | 16520.7 | 16604.9 | 48932.0 |
| 2021-08-02 | FDXS | Futures | 16468.7 | 16623.3 | 16416.8 | 16499.4 | 8606.0 |
| 2021-08-02 | FESX | Futures | 3890.1 | 3915.7 | 3877.3 | 3900.1 | 514928.0 |
| 2021-08-02 | FGBL | Futures | 171.02 | 171.53 | 170.83 | 171.28 | 504745.0 |
| 2021-08-02 | FGBM | Futures | 135.83 | 135.95 | 135.76 | 135.88 | 282403.0 |
| 2021-08-02 | FGBS | Futures | 112.785 | 112.815 | 112.769 | 112.8 | 213692.0 |
| 2021-08-02 | FGBX | Futures | 229.84 | 231.47 | 229.03 | 230.61 | 61130.0 |
| 2021-08-02 | FMWO | Futures | 10897.3 | 10936.1 | 10836.2 | 10897.3 | 3886.0 |
| 2021-08-02 | FOAT | Futures | 158.03 | 158.51 | 157.91 | 158.36 | 123522.0 |
| 2021-08-02 | FTDX | Futures | 3766.1 | 3810.7 | 3763.5 | 3810.2 | 37.0 |
| 2021-08-02 | FTI | Futures | 723.58 | 726.79 | 719.61 | 722.85 | 15345.0 |
| 2021-08-02 | FTUK | Futures | 6861.2 | 6933.6 | 6861.2 | 6907.0 | 89180.0 |
| 2021-08-02 | FVSA | Futures | 88.74 | 93.38 | 86.83 | 88.52 | 23711.0 |
| 2021-08-02 | FXXP | Futures | 440.0 | 442.2 | 439.1 | 441.0 | 40364.0 |
> showing 50 of 121 rows — these rows as CSV