PREVIEW / futures_daily / 2023-04-05
file: by_date/futures_daily/2023/2023-04-05.parquet size: 10 KB rows: 131
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-05 | ES | Futures | 4523.51 | 4525.15 | 4485.21 | 4505.18 | 1470176.0 |
| 2023-04-05 | NQ | Futures | 14666.13 | 14685.26 | 14417.82 | 14499.57 | 594608.0 |
| 2023-04-05 | YM | Futures | 36032.5 | 36133.2 | 35900.7 | 36064.6 | 138419.0 |
| 2023-04-05 | CL | Futures | 70.47 | 70.67 | 69.35 | 70.12 | 254974.0 |
| 2023-04-05 | GC | Futures | 2261.5 | 2273.7 | 2248.1 | 2258.6 | 197371.0 |
| 2023-04-05 | ZN | Futures | 118.86472 | 119.648092 | 118.592938 | 119.280387 | 1514272.0 |
| 2023-04-05 | A6 | Futures | 0.68824 | 0.69094 | 0.68042 | 0.68514 | 89443.0 |
| 2023-04-05 | AD | Futures | 0.75414 | 0.75546 | 0.75207 | 0.75359 | 63088.0 |
| 2023-04-05 | ALI | Futures | 2593.67 | 2593.67 | 2547.16 | 2555.37 | 1635.0 |
| 2023-04-05 | B | Futures | 74.96 | 75.25 | 73.9 | 74.76 | 246479.0 |
| 2023-04-05 | B6 | Futures | 1.2576 | 1.2586 | 1.2505 | 1.2537 | 89657.0 |
| 2023-04-05 | BFX | Futures | 4152.6 | 4152.6 | 4152.6 | 4152.6 | 0.0 |
| 2023-04-05 | BR | Futures | 0.17672 | 0.17785 | 0.17609 | 0.17672 | 217.0 |
| 2023-04-05 | BTC | Futures | 38661.5 | 39471.8 | 38041.9 | 38654.7 | 8243.0 |
| 2023-04-05 | BZ | Futures | 74.47 | 74.87 | 73.52 | 74.38 | 28362.0 |
| 2023-04-05 | C | Futures | 1655.0 | 1681.0 | 1653.0 | 1680.0 | 14137.0 |
| 2023-04-05 | CB | Futures | 235.158 | 235.892 | 233.445 | 233.445 | 19.0 |
| 2023-04-05 | CC | Futures | 1675.0 | 1678.0 | 1660.0 | 1670.0 | 33854.0 |
| 2023-04-05 | CNH | Futures | 6.5329 | 6.5435 | 6.5227 | 6.5392 | 330.0 |
| 2023-04-05 | CSC | Futures | 2.27 | 2.28 | 2.261 | 2.269 | 44.0 |
| 2023-04-05 | CT | Futures | 105.2 | 106.46 | 104.57 | 105.29 | 13538.0 |
| 2023-04-05 | DC | Futures | 21.43 | 21.58 | 21.38 | 21.41 | 73.0 |
| 2023-04-05 | DX | Futures | 98.959 | 99.384 | 98.807 | 99.252 | 16075.0 |
| 2023-04-05 | E1 | Futures | 1.19142 | 1.19972 | 1.18911 | 1.19147 | 20434.0 |
| 2023-04-05 | E6 | Futures | 1.13088 | 1.13237 | 1.12435 | 1.12625 | 172427.0 |
| 2023-04-05 | E7 | Futures | 1.1306 | 1.1318 | 1.1238 | 1.1257 | 4542.0 |
| 2023-04-05 | EBM | Futures | 373.67 | 378.48 | 371.82 | 375.89 | 26856.0 |
| 2023-04-05 | ED | Futures | 94.87 | 94.975 | 94.815 | 94.89 | 54086.0 |
| 2023-04-05 | ER | Futures | 98.056 | 98.127 | 98.0 | 98.086 | 184848.0 |
| 2023-04-05 | ESG | Futures | 390.23 | 390.23 | 387.29 | 389.01 | 1763.0 |
| 2023-04-05 | EW | Futures | 2657.4 | 2658.2 | 2615.6 | 2632.5 | 8593.0 |
| 2023-04-05 | FBON | Futures | 123.03 | 123.79 | 122.64 | 123.62 | 334.0 |
| 2023-04-05 | FBTP | Futures | 112.36 | 113.59 | 112.1 | 113.3 | 160444.0 |
| 2023-04-05 | FBTS | Futures | 106.572 | 106.916 | 106.502 | 106.866 | 112253.0 |
| 2023-04-05 | FCE | Futures | 7944.4 | 7970.4 | 7906.6 | 7923.3 | 47722.0 |
| 2023-04-05 | FDAX | Futures | 16820.9 | 16839.0 | 16669.4 | 16690.7 | 51973.0 |
| 2023-04-05 | FDIV | Futures | 183.51 | 183.51 | 183.25 | 183.25 | 40.0 |
| 2023-04-05 | FDXM | Futures | 16963.2 | 16983.6 | 16811.5 | 16833.0 | 36394.0 |
| 2023-04-05 | FDXS | Futures | 16854.6 | 16879.2 | 16697.5 | 16720.0 | 15292.0 |
| 2023-04-05 | FESX | Futures | 4353.7 | 4357.8 | 4321.0 | 4327.1 | 723726.0 |
| 2023-04-05 | FEU3 | Futures | 98.097 | 98.097 | 98.097 | 98.097 | 0.0 |
| 2023-04-05 | FGBL | Futures | 137.21 | 138.23 | 136.58 | 138.02 | 845041.0 |
| 2023-04-05 | FGBM | Futures | 120.32 | 120.91 | 119.88 | 120.72 | 504733.0 |
| 2023-04-05 | FGBS | Futures | 108.523 | 108.774 | 108.343 | 108.676 | 478492.0 |
| 2023-04-05 | FGBX | Futures | 144.61 | 147.04 | 143.33 | 146.55 | 65090.0 |
| 2023-04-05 | FMWO | Futures | 9818.2 | 9831.8 | 9749.3 | 9763.9 | 1668.0 |
| 2023-04-05 | FOAT | Futures | 127.85 | 128.82 | 127.27 | 128.63 | 164957.0 |
| 2023-04-05 | FSMX | Futures | 28984.3 | 29006.5 | 28607.4 | 28668.7 | 285.0 |
| 2023-04-05 | FTDX | Futures | 3559.4 | 3559.4 | 3542.2 | 3548.7 | 8.0 |
| 2023-04-05 | FTI | Futures | 800.96 | 802.76 | 797.36 | 800.1 | 14594.0 |
> showing 50 of 131 rows — these rows as CSV