PREVIEW / futures_daily / 2021-06-24
file: by_date/futures_daily/2021/2021-06-24.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-06-24 | ES | Futures | 4759.05 | 4792.77 | 4756.8 | 4784.06 | 878788.0 |
| 2021-06-24 | NQ | Futures | 16469.17 | 16638.47 | 16463.11 | 16560.31 | 409864.0 |
| 2021-06-24 | YM | Futures | 36641.3 | 37058.8 | 36620.7 | 36955.8 | 122505.0 |
| 2021-06-24 | CL | Futures | 52.57 | 52.8 | 51.88 | 52.58 | 334833.0 |
| 2021-06-24 | GC | Futures | 2079.8 | 2092.0 | 2073.4 | 2078.1 | 152232.0 |
| 2021-06-24 | ZN | Futures | 133.756801 | 133.883315 | 133.630287 | 133.772615 | 1224046.0 |
| 2021-06-24 | A6 | Futures | 0.77715 | 0.7788 | 0.77608 | 0.77787 | 55221.0 |
| 2021-06-24 | AD | Futures | 0.82381 | 0.82538 | 0.82153 | 0.8228 | 49573.0 |
| 2021-06-24 | ALI | Futures | 2800.58 | 2827.84 | 2797.42 | 2820.95 | 126.0 |
| 2021-06-24 | B | Futures | 49.24 | 49.55 | 48.72 | 49.41 | 165052.0 |
| 2021-06-24 | B6 | Futures | 1.418 | 1.4203 | 1.4104 | 1.4144 | 92005.0 |
| 2021-06-24 | BR | Futures | 0.16143 | 0.16219 | 0.16115 | 0.16171 | 178.0 |
| 2021-06-24 | BTC | Futures | 47667.5 | 50438.3 | 46285.6 | 49811.5 | 4402.0 |
| 2021-06-24 | BZ | Futures | 48.11 | 48.37 | 47.57 | 48.24 | 26664.0 |
| 2021-06-24 | C | Futures | 1445.0 | 1445.0 | 1433.0 | 1439.0 | 1701.0 |
| 2021-06-24 | CB | Futures | 141.207 | 141.207 | 140.003 | 140.003 | 33.0 |
| 2021-06-24 | CC | Futures | 1552.0 | 1552.0 | 1531.0 | 1537.0 | 14915.0 |
| 2021-06-24 | CNH | Futures | 6.2823 | 6.2871 | 6.2722 | 6.2733 | 277.0 |
| 2021-06-24 | CSC | Futures | 2.5 | 2.511 | 2.486 | 2.486 | 89.0 |
| 2021-06-24 | CT | Futures | 80.62 | 81.01 | 80.62 | 80.95 | 3.0 |
| 2021-06-24 | DC | Futures | 22.89 | 22.89 | 22.54 | 22.54 | 232.0 |
| 2021-06-24 | DX | Futures | 88.737 | 88.844 | 88.583 | 88.728 | 11981.0 |
| 2021-06-24 | E1 | Futures | 1.22594 | 1.22662 | 1.22313 | 1.22538 | 15050.0 |
| 2021-06-24 | E6 | Futures | 1.27073 | 1.27381 | 1.26961 | 1.2711 | 115989.0 |
| 2021-06-24 | E7 | Futures | 1.2648 | 1.2675 | 1.2632 | 1.2647 | 3754.0 |
| 2021-06-24 | EBM | Futures | 303.41 | 305.62 | 299.37 | 300.84 | 20403.0 |
| 2021-06-24 | ED | Futures | 96.5248 | 96.5297 | 96.5248 | 96.5248 | 98255.0 |
| 2021-06-24 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.455 | 57757.0 |
| 2021-06-24 | ESG | Futures | 394.91 | 395.56 | 394.67 | 394.76 | 195.0 |
| 2021-06-24 | EW | Futures | 2874.1 | 2903.4 | 2872.0 | 2897.3 | 7989.0 |
| 2021-06-24 | FBON | Futures | 147.5 | 147.86 | 147.44 | 147.86 | 108.0 |
| 2021-06-24 | FBTP | Futures | 137.59 | 137.98 | 137.37 | 137.88 | 101657.0 |
| 2021-06-24 | FBTS | Futures | 110.059 | 110.107 | 110.049 | 110.088 | 65842.0 |
| 2021-06-24 | FCE | Futures | 6537.9 | 6614.1 | 6537.9 | 6603.2 | 47513.0 |
| 2021-06-24 | FDAX | Futures | 16581.6 | 16699.5 | 16557.0 | 16678.0 | 48070.0 |
| 2021-06-24 | FDXM | Futures | 16507.9 | 16616.6 | 16477.0 | 16595.3 | 35629.0 |
| 2021-06-24 | FDXS | Futures | 16406.2 | 16512.1 | 16373.4 | 16489.9 | 3631.0 |
| 2021-06-24 | FESX | Futures | 3857.4 | 3902.0 | 3857.4 | 3894.9 | 581473.0 |
| 2021-06-24 | FGBL | Futures | 166.82 | 166.99 | 166.5 | 166.93 | 573156.0 |
| 2021-06-24 | FGBM | Futures | 134.51 | 134.57 | 134.41 | 134.51 | 335020.0 |
| 2021-06-24 | FGBS | Futures | 112.549 | 112.564 | 112.539 | 112.549 | 206238.0 |
| 2021-06-24 | FGBX | Futures | 216.57 | 216.85 | 215.74 | 216.72 | 61859.0 |
| 2021-06-24 | FMWO | Futures | 10549.5 | 10638.8 | 10549.5 | 10622.4 | 2646.0 |
| 2021-06-24 | FOAT | Futures | 154.67 | 154.83 | 154.42 | 154.77 | 123336.0 |
| 2021-06-24 | FTDX | Futures | 3578.8 | 3635.7 | 3578.8 | 3623.9 | 54.0 |
| 2021-06-24 | FTI | Futures | 692.57 | 698.62 | 691.81 | 697.36 | 17362.0 |
| 2021-06-24 | FTUK | Futures | 6901.6 | 6945.4 | 6893.7 | 6939.5 | 78122.0 |
| 2021-06-24 | FVSA | Futures | 83.89 | 84.12 | 81.37 | 82.29 | 15655.0 |
| 2021-06-24 | FXXP | Futures | 430.3 | 434.1 | 430.3 | 433.3 | 58553.0 |
| 2021-06-24 | G | Futures | 121.68 | 122.14 | 121.59 | 122.07 | 224820.0 |
> showing 50 of 121 rows — these rows as CSV