PREVIEW / futures_daily / 2021-07-30
file: by_date/futures_daily/2021/2021-07-30.parquet size: 10 KB rows: 124
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-30 | ES | Futures | 4939.46 | 4951.54 | 4913.05 | 4934.12 | 1376982.0 |
| 2021-07-30 | NQ | Futures | 17195.99 | 17282.23 | 17087.55 | 17254.25 | 505630.0 |
| 2021-07-30 | YM | Futures | 37927.3 | 37947.9 | 37686.6 | 37769.0 | 151872.0 |
| 2021-07-30 | CL | Futures | 53.13 | 53.73 | 52.79 | 53.52 | 303700.0 |
| 2021-07-30 | GC | Futures | 2137.9 | 2141.4 | 2115.3 | 2120.0 | 157136.0 |
| 2021-07-30 | ZN | Futures | 135.812652 | 136.223822 | 135.812652 | 136.081494 | 1753454.0 |
| 2021-07-30 | A6 | Futures | 0.75864 | 0.75957 | 0.75198 | 0.75234 | 81822.0 |
| 2021-07-30 | AD | Futures | 0.81449 | 0.81611 | 0.8116 | 0.81241 | 79726.0 |
| 2021-07-30 | ALI | Futures | 3004.14 | 3042.7 | 2992.15 | 3000.43 | 92.0 |
| 2021-07-30 | B | Futures | 49.82 | 50.38 | 49.54 | 50.22 | 277427.0 |
| 2021-07-30 | B6 | Futures | 1.4177 | 1.42 | 1.4102 | 1.4106 | 98268.0 |
| 2021-07-30 | BFX | Futures | 4298.9 | 4298.9 | 4287.1 | 4287.1 | 1.0 |
| 2021-07-30 | BR | Futures | 0.15707 | 0.15771 | 0.1525 | 0.15354 | 14827.0 |
| 2021-07-30 | BTC | Futures | 53226.4 | 56250.0 | 51496.6 | 53575.0 | 4892.0 |
| 2021-07-30 | BZ | Futures | 48.6 | 49.18 | 48.36 | 49.02 | 27919.0 |
| 2021-07-30 | C | Futures | 1439.0 | 1445.0 | 1420.0 | 1424.0 | 5663.0 |
| 2021-07-30 | CB | Futures | 129.975 | 130.777 | 129.614 | 130.717 | 41.0 |
| 2021-07-30 | CC | Futures | 1581.0 | 1584.0 | 1545.0 | 1552.0 | 27086.0 |
| 2021-07-30 | CNH | Futures | 6.2492 | 6.2635 | 6.2434 | 6.2571 | 911.0 |
| 2021-07-30 | CSC | Futures | 2.388 | 2.401 | 2.379 | 2.385 | 53.0 |
| 2021-07-30 | CT | Futures | 83.63 | 83.63 | 82.55 | 83.08 | 50.0 |
| 2021-07-30 | DC | Futures | 21.21 | 21.34 | 21.04 | 21.34 | 295.0 |
| 2021-07-30 | DX | Futures | 88.824 | 89.134 | 88.713 | 89.108 | 22389.0 |
| 2021-07-30 | E1 | Futures | 1.24099 | 1.24357 | 1.23874 | 1.24043 | 27294.0 |
| 2021-07-30 | E6 | Futures | 1.26541 | 1.26781 | 1.26169 | 1.26217 | 163907.0 |
| 2021-07-30 | E7 | Futures | 1.2589 | 1.2613 | 1.2554 | 1.2558 | 4757.0 |
| 2021-07-30 | EBM | Futures | 325.85 | 329.52 | 318.86 | 328.42 | 28890.0 |
| 2021-07-30 | ED | Futures | 96.5442 | 96.549 | 96.5393 | 96.5442 | 105480.0 |
| 2021-07-30 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.465 | 15353.0 |
| 2021-07-30 | ESG | Futures | 407.27 | 408.73 | 407.27 | 407.49 | 217.0 |
| 2021-07-30 | EW | Futures | 2902.8 | 2924.4 | 2877.1 | 2898.5 | 8316.0 |
| 2021-07-30 | FBON | Futures | 150.87 | 151.18 | 150.67 | 151.02 | 47.0 |
| 2021-07-30 | FBTP | Futures | 141.13 | 141.13 | 140.87 | 141.03 | 80037.0 |
| 2021-07-30 | FBTS | Futures | 110.38 | 110.399 | 110.37 | 110.38 | 15687.0 |
| 2021-07-30 | FCE | Futures | 6574.2 | 6632.1 | 6571.7 | 6596.1 | 55903.0 |
| 2021-07-30 | FDAX | Futures | 16670.5 | 16712.3 | 16524.9 | 16656.6 | 69700.0 |
| 2021-07-30 | FDIV | Futures | 185.29 | 185.29 | 185.15 | 185.25 | 34.0 |
| 2021-07-30 | FDXM | Futures | 16594.2 | 16628.3 | 16441.8 | 16574.0 | 48596.0 |
| 2021-07-30 | FDXS | Futures | 16510.0 | 16522.7 | 16339.5 | 16468.7 | 11054.0 |
| 2021-07-30 | FESX | Futures | 3882.6 | 3894.4 | 3860.3 | 3875.4 | 728185.0 |
| 2021-07-30 | FGBL | Futures | 171.01 | 171.2 | 170.77 | 171.04 | 584895.0 |
| 2021-07-30 | FGBM | Futures | 135.84 | 135.86 | 135.73 | 135.83 | 331699.0 |
| 2021-07-30 | FGBS | Futures | 112.785 | 112.795 | 112.764 | 112.78 | 182955.0 |
| 2021-07-30 | FGBX | Futures | 229.31 | 230.03 | 228.75 | 229.8 | 65855.0 |
| 2021-07-30 | FMWO | Futures | 10818.6 | 10882.0 | 10799.8 | 10843.2 | 3888.0 |
| 2021-07-30 | FOAT | Futures | 158.14 | 158.15 | 157.84 | 158.04 | 185211.0 |
| 2021-07-30 | FTDX | Futures | 3740.9 | 3796.4 | 3727.6 | 3775.8 | 88.0 |
| 2021-07-30 | FTI | Futures | 717.55 | 723.96 | 715.83 | 719.07 | 18231.0 |
| 2021-07-30 | FTUK | Futures | 6870.1 | 6878.0 | 6816.4 | 6859.7 | 97522.0 |
| 2021-07-30 | FVSA | Futures | 85.99 | 91.9 | 85.99 | 90.43 | 34237.0 |
> showing 50 of 124 rows — these rows as CSV