PREVIEW / futures_daily / 2021-09-17
file: by_date/futures_daily/2021/2021-09-17.parquet size: 10 KB rows: 126
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-09-17 | ES | Futures | 5016.17 | 5031.08 | 4956.84 | 4973.99 | 1968041.0 |
| 2021-09-17 | NQ | Futures | 17871.16 | 17906.33 | 17615.74 | 17673.11 | 641864.0 |
| 2021-09-17 | YM | Futures | 37656.8 | 37765.6 | 37378.3 | 37495.8 | 186984.0 |
| 2021-09-17 | CL | Futures | 53.26 | 53.39 | 52.3 | 52.89 | 288461.0 |
| 2021-09-17 | GC | Futures | 2047.0 | 2062.4 | 2038.3 | 2043.3 | 183254.0 |
| 2021-09-17 | ZN | Futures | 135.306901 | 135.402243 | 134.89375 | 135.036764 | 1443850.0 |
| 2021-09-17 | A6 | Futures | 0.74808 | 0.7508 | 0.74465 | 0.74573 | 83943.0 |
| 2021-09-17 | AD | Futures | 0.80029 | 0.80328 | 0.79466 | 0.79638 | 79389.0 |
| 2021-09-17 | ALI | Futures | 3280.16 | 3335.08 | 3268.9 | 3282.7 | 323.0 |
| 2021-09-17 | B | Futures | 50.95 | 51.02 | 50.21 | 50.73 | 254860.0 |
| 2021-09-17 | B6 | Futures | 1.4003 | 1.4022 | 1.3926 | 1.3946 | 73448.0 |
| 2021-09-17 | BFX | Futures | 4245.3 | 4245.3 | 4217.7 | 4217.7 | 1.0 |
| 2021-09-17 | BR | Futures | 0.15239 | 0.15239 | 0.15023 | 0.15178 | 10.0 |
| 2021-09-17 | BTC | Futures | 63382.3 | 64214.5 | 62144.0 | 63235.8 | 3893.0 |
| 2021-09-17 | BZ | Futures | 49.21 | 49.71 | 48.93 | 49.43 | 26771.0 |
| 2021-09-17 | C | Futures | 1572.0 | 1579.0 | 1566.0 | 1578.0 | 6149.0 |
| 2021-09-17 | CB | Futures | 143.021 | 143.021 | 142.647 | 142.647 | 11.0 |
| 2021-09-17 | CC | Futures | 1710.0 | 1716.0 | 1692.0 | 1711.0 | 11863.0 |
| 2021-09-17 | CNH | Futures | 6.2246 | 6.2412 | 6.2148 | 6.2382 | 334.0 |
| 2021-09-17 | CSC | Futures | 2.456 | 2.459 | 2.452 | 2.452 | 67.0 |
| 2021-09-17 | CT | Futures | 86.12 | 86.3 | 86.11 | 86.3 | 15.0 |
| 2021-09-17 | DC | Futures | 22.28 | 22.35 | 22.24 | 22.33 | 31.0 |
| 2021-09-17 | DX | Futures | 89.733 | 90.086 | 89.612 | 90.029 | 19160.0 |
| 2021-09-17 | E1 | Futures | 1.20981 | 1.21205 | 1.20365 | 1.20388 | 22746.0 |
| 2021-09-17 | E6 | Futures | 1.25223 | 1.25467 | 1.24766 | 1.2483 | 166182.0 |
| 2021-09-17 | E7 | Futures | 1.2456 | 1.2478 | 1.2409 | 1.2415 | 3172.0 |
| 2021-09-17 | EBM | Futures | 365.93 | 366.29 | 362.99 | 364.09 | 15528.0 |
| 2021-09-17 | ED | Futures | 96.5489 | 96.5489 | 96.5441 | 96.5441 | 53074.0 |
| 2021-09-17 | ER | Futures | 98.48 | 98.48 | 98.475 | 98.475 | 30198.0 |
| 2021-09-17 | ESG | Futures | 413.64 | 413.64 | 410.43 | 410.72 | 247.0 |
| 2021-09-17 | EW | Futures | 2894.7 | 2903.3 | 2865.2 | 2872.8 | 21031.0 |
| 2021-09-17 | FBON | Futures | 150.09 | 150.2 | 149.85 | 150.1 | 658.0 |
| 2021-09-17 | FBTP | Futures | 140.19 | 140.28 | 139.69 | 139.97 | 160642.0 |
| 2021-09-17 | FBTS | Futures | 110.448 | 110.448 | 110.371 | 110.4 | 109211.0 |
| 2021-09-17 | FCE | Futures | 6669.8 | 6697.8 | 6541.0 | 6569.5 | 92406.0 |
| 2021-09-17 | FDAX | Futures | 16775.5 | 16857.8 | 16468.8 | 16500.8 | 112604.0 |
| 2021-09-17 | FDIV | Futures | 184.51 | 184.51 | 182.89 | 182.89 | 45.0 |
| 2021-09-17 | FDXM | Futures | 16810.4 | 16905.8 | 16516.7 | 16547.8 | 97895.0 |
| 2021-09-17 | FDXS | Futures | 16640.5 | 16747.8 | 16361.2 | 16394.1 | 20463.0 |
| 2021-09-17 | FESX | Futures | 3989.5 | 4006.7 | 3909.1 | 3915.3 | 1282881.0 |
| 2021-09-17 | FEU3 | Futures | 99.203 | 99.208 | 99.203 | 99.208 | 5.0 |
| 2021-09-17 | FGBL | Futures | 168.67 | 168.79 | 168.29 | 168.47 | 675355.0 |
| 2021-09-17 | FGBM | Futures | 134.98 | 135.04 | 134.91 | 134.97 | 458474.0 |
| 2021-09-17 | FGBS | Futures | 112.649 | 112.679 | 112.649 | 112.664 | 314823.0 |
| 2021-09-17 | FGBX | Futures | 223.0 | 223.39 | 221.56 | 222.16 | 66138.0 |
| 2021-09-17 | FMWO | Futures | 10967.8 | 11125.2 | 10964.3 | 10964.3 | 62.0 |
| 2021-09-17 | FOAT | Futures | 156.45 | 156.51 | 156.04 | 156.23 | 158245.0 |
| 2021-09-17 | FTDX | Futures | 4041.7 | 4041.7 | 3984.7 | 3993.9 | 66.0 |
| 2021-09-17 | FTI | Futures | 765.08 | 766.37 | 749.71 | 751.78 | 29500.0 |
| 2021-09-17 | FTUK | Futures | 6938.6 | 6974.1 | 6813.2 | 6822.0 | 163945.0 |
> showing 50 of 126 rows — these rows as CSV