PREVIEW / futures_daily / 2021-07-22
file: by_date/futures_daily/2021/2021-07-22.parquet size: 10 KB rows: 123
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-07-22 | ES | Futures | 4895.34 | 4913.89 | 4880.17 | 4900.4 | 981969.0 |
| 2021-07-22 | NQ | Futures | 17116.97 | 17285.4 | 17105.43 | 17222.82 | 425426.0 |
| 2021-07-22 | YM | Futures | 37661.7 | 37722.4 | 37470.8 | 37635.6 | 117275.0 |
| 2021-07-22 | CL | Futures | 50.82 | 52.13 | 50.56 | 52.05 | 435181.0 |
| 2021-07-22 | GC | Futures | 2109.9 | 2115.2 | 2095.9 | 2111.7 | 193318.0 |
| 2021-07-22 | ZN | Futures | 135.670324 | 136.097308 | 135.480553 | 135.875909 | 1449036.0 |
| 2021-07-22 | A6 | Futures | 0.75485 | 0.75875 | 0.75311 | 0.75782 | 72882.0 |
| 2021-07-22 | AD | Futures | 0.80708 | 0.80916 | 0.8049 | 0.80739 | 70982.0 |
| 2021-07-22 | ALI | Futures | 2846.48 | 2878.47 | 2842.77 | 2871.61 | 196.0 |
| 2021-07-22 | B | Futures | 47.7 | 48.79 | 47.37 | 48.72 | 251602.0 |
| 2021-07-22 | B6 | Futures | 1.3928 | 1.4001 | 1.3902 | 1.3988 | 104672.0 |
| 2021-07-22 | BFX | Futures | 4334.6 | 4334.6 | 4299.9 | 4306.6 | 13.0 |
| 2021-07-22 | BR | Futures | 0.15354 | 0.15366 | 0.15242 | 0.15298 | 360.0 |
| 2021-07-22 | BTC | Futures | 45473.6 | 46428.0 | 45131.7 | 46178.7 | 3232.0 |
| 2021-07-22 | BZ | Futures | 46.53 | 47.69 | 46.31 | 47.62 | 34425.0 |
| 2021-07-22 | C | Futures | 1383.0 | 1392.0 | 1377.0 | 1391.0 | 5252.0 |
| 2021-07-22 | CB | Futures | 138.8 | 138.8 | 137.998 | 138.399 | 15.0 |
| 2021-07-22 | CC | Futures | 1485.0 | 1525.0 | 1480.0 | 1520.0 | 19284.0 |
| 2021-07-22 | CNH | Futures | 6.2597 | 6.2704 | 6.2576 | 6.266 | 450.0 |
| 2021-07-22 | CSC | Futures | 2.409 | 2.451 | 2.392 | 2.438 | 222.0 |
| 2021-07-22 | CT | Futures | 82.6 | 83.82 | 82.6 | 83.48 | 20.0 |
| 2021-07-22 | DC | Futures | 21.6 | 22.02 | 21.42 | 21.94 | 359.0 |
| 2021-07-22 | DX | Futures | 89.709 | 89.825 | 89.414 | 89.728 | 23391.0 |
| 2021-07-22 | E1 | Futures | 1.22549 | 1.22819 | 1.22201 | 1.22347 | 20248.0 |
| 2021-07-22 | E6 | Futures | 1.2561 | 1.25967 | 1.25185 | 1.25334 | 207055.0 |
| 2021-07-22 | E7 | Futures | 1.2498 | 1.2534 | 1.2457 | 1.2471 | 5042.0 |
| 2021-07-22 | EBM | Futures | 311.14 | 312.61 | 307.46 | 308.93 | 15751.0 |
| 2021-07-22 | ED | Futures | 96.5248 | 96.5345 | 96.5248 | 96.5345 | 119675.0 |
| 2021-07-22 | ER | Futures | 98.455 | 98.465 | 98.455 | 98.465 | 48199.0 |
| 2021-07-22 | ESG | Futures | 405.6 | 405.9 | 404.51 | 405.75 | 308.0 |
| 2021-07-22 | EW | Futures | 2872.2 | 2877.1 | 2826.3 | 2840.3 | 8734.0 |
| 2021-07-22 | FBON | Futures | 150.15 | 150.83 | 149.89 | 150.58 | 692.0 |
| 2021-07-22 | FBTP | Futures | 140.31 | 140.82 | 139.98 | 140.61 | 108387.0 |
| 2021-07-22 | FBTS | Futures | 110.292 | 110.351 | 110.234 | 110.331 | 79640.0 |
| 2021-07-22 | FCE | Futures | 6479.9 | 6508.8 | 6457.4 | 6465.4 | 43998.0 |
| 2021-07-22 | FDAX | Futures | 16549.5 | 16674.8 | 16523.8 | 16603.1 | 62001.0 |
| 2021-07-22 | FDXM | Futures | 16454.6 | 16593.2 | 16441.8 | 16520.7 | 41429.0 |
| 2021-07-22 | FDXS | Futures | 16336.3 | 16485.6 | 16336.3 | 16415.7 | 9222.0 |
| 2021-07-22 | FESX | Futures | 3829.9 | 3859.8 | 3820.0 | 3839.4 | 584810.0 |
| 2021-07-22 | FGBL | Futures | 170.04 | 170.63 | 169.75 | 170.43 | 701534.0 |
| 2021-07-22 | FGBM | Futures | 135.42 | 135.6 | 135.37 | 135.56 | 389258.0 |
| 2021-07-22 | FGBS | Futures | 112.679 | 112.704 | 112.674 | 112.699 | 265260.0 |
| 2021-07-22 | FGBX | Futures | 226.55 | 228.56 | 225.97 | 227.85 | 77725.0 |
| 2021-07-22 | FMWO | Futures | 10746.9 | 10764.5 | 10714.0 | 10737.5 | 2570.0 |
| 2021-07-22 | FOAT | Futures | 157.22 | 157.87 | 157.12 | 157.72 | 159114.0 |
| 2021-07-22 | FTDX | Futures | 3696.3 | 3742.0 | 3696.3 | 3731.7 | 145.0 |
| 2021-07-22 | FTI | Futures | 702.86 | 706.45 | 700.42 | 704.37 | 17894.0 |
| 2021-07-22 | FTUK | Futures | 6833.7 | 6843.5 | 6779.0 | 6787.4 | 84296.0 |
| 2021-07-22 | FVSA | Futures | 87.05 | 89.16 | 85.14 | 87.68 | 34218.0 |
| 2021-07-22 | FXXP | Futures | 432.2 | 435.1 | 432.0 | 433.1 | 53030.0 |
> showing 50 of 123 rows — these rows as CSV