PREVIEW / futures_daily / 2023-03-27
file: by_date/futures_daily/2023/2023-03-27.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-03-27 | ES | Futures | 4385.64 | 4414.36 | 4374.15 | 4384.82 | 1304572.0 |
| 2023-03-27 | NQ | Futures | 14318.05 | 14393.99 | 14151.21 | 14176.71 | 562634.0 |
| 2023-03-27 | YM | Futures | 34810.9 | 35115.2 | 34738.0 | 34966.3 | 136405.0 |
| 2023-03-27 | CL | Futures | 60.39 | 63.59 | 60.13 | 63.34 | 353598.0 |
| 2023-03-27 | GC | Futures | 2219.5 | 2220.8 | 2177.7 | 2187.5 | 107043.0 |
| 2023-03-27 | ZN | Futures | 118.86472 | 118.896695 | 117.537784 | 117.649694 | 1348508.0 |
| 2023-03-27 | A6 | Futures | 0.67712 | 0.67945 | 0.6763 | 0.67778 | 60246.0 |
| 2023-03-27 | AD | Futures | 0.73799 | 0.7431 | 0.73794 | 0.74295 | 62653.0 |
| 2023-03-27 | ALI | Futures | 2562.48 | 2594.22 | 2548.8 | 2589.57 | 2567.0 |
| 2023-03-27 | B | Futures | 65.64 | 68.61 | 65.44 | 68.4 | 335759.0 |
| 2023-03-27 | B6 | Futures | 1.2313 | 1.237 | 1.2294 | 1.2363 | 61451.0 |
| 2023-03-27 | BFX | Futures | 4038.2 | 4038.2 | 4038.2 | 4038.2 | 0.0 |
| 2023-03-27 | BR | Futures | 0.16896 | 0.17153 | 0.16896 | 0.17122 | 102.0 |
| 2023-03-27 | BTC | Futures | 38287.0 | 38627.5 | 36435.0 | 37068.2 | 3458.0 |
| 2023-03-27 | BZ | Futures | 65.43 | 68.28 | 65.14 | 68.05 | 25382.0 |
| 2023-03-27 | C | Futures | 1661.0 | 1670.0 | 1649.0 | 1659.0 | 7599.0 |
| 2023-03-27 | CB | Futures | 235.892 | 235.892 | 235.892 | 235.892 | 0.0 |
| 2023-03-27 | CC | Futures | 1654.0 | 1678.0 | 1646.0 | 1666.0 | 28448.0 |
| 2023-03-27 | CNH | Futures | 6.5185 | 6.5423 | 6.5185 | 6.5299 | 1825.0 |
| 2023-03-27 | CSC | Futures | 2.331 | 2.337 | 2.306 | 2.306 | 131.0 |
| 2023-03-27 | CT | Futures | 99.8 | 103.31 | 99.42 | 103.28 | 18669.0 |
| 2023-03-27 | DC | Futures | 22.04 | 22.24 | 21.76 | 21.77 | 123.0 |
| 2023-03-27 | DX | Futures | 100.449 | 100.572 | 100.166 | 100.203 | 7355.0 |
| 2023-03-27 | E1 | Futures | 1.17605 | 1.18071 | 1.17492 | 1.17985 | 10714.0 |
| 2023-03-27 | E6 | Futures | 1.11222 | 1.11597 | 1.11026 | 1.11551 | 125962.0 |
| 2023-03-27 | E7 | Futures | 1.1115 | 1.1154 | 1.1098 | 1.115 | 3621.0 |
| 2023-03-27 | EBM | Futures | 380.33 | 396.24 | 376.26 | 394.76 | 41291.0 |
| 2023-03-27 | ED | Futures | 94.935 | 94.95 | 94.785 | 94.8 | 49948.0 |
| 2023-03-27 | ER | Futures | 98.056 | 98.117 | 98.0 | 98.056 | 88768.0 |
| 2023-03-27 | ESG | Futures | 379.31 | 380.55 | 377.78 | 378.02 | 581.0 |
| 2023-03-27 | EW | Futures | 2588.6 | 2622.7 | 2579.8 | 2608.2 | 11539.0 |
| 2023-03-27 | FBON | Futures | 124.04 | 124.12 | 122.97 | 123.53 | 226.0 |
| 2023-03-27 | FBTP | Futures | 113.26 | 113.64 | 112.61 | 113.11 | 128115.0 |
| 2023-03-27 | FBTS | Futures | 106.936 | 107.037 | 106.775 | 106.896 | 142009.0 |
| 2023-03-27 | FCE | Futures | 7662.6 | 7721.6 | 7628.0 | 7672.9 | 43371.0 |
| 2023-03-27 | FDAX | Futures | 16212.9 | 16365.4 | 16179.8 | 16309.9 | 59803.0 |
| 2023-03-27 | FDIV | Futures | 178.3 | 178.46 | 176.63 | 178.46 | 49.0 |
| 2023-03-27 | FDXM | Futures | 16345.7 | 16503.8 | 16317.7 | 16449.0 | 37501.0 |
| 2023-03-27 | FDXS | Futures | 16228.5 | 16393.0 | 16209.2 | 16338.5 | 21841.0 |
| 2023-03-27 | FESX | Futures | 4191.2 | 4223.9 | 4171.8 | 4197.4 | 606967.0 |
| 2023-03-27 | FEU3 | Futures | 98.061 | 98.061 | 98.061 | 98.061 | 0.0 |
| 2023-03-27 | FGBL | Futures | 138.29 | 138.59 | 136.9 | 137.67 | 778699.0 |
| 2023-03-27 | FGBM | Futures | 121.05 | 121.1 | 120.23 | 120.63 | 555574.0 |
| 2023-03-27 | FGBS | Futures | 108.886 | 108.927 | 108.559 | 108.728 | 485738.0 |
| 2023-03-27 | FGBX | Futures | 147.92 | 148.55 | 144.12 | 145.94 | 66823.0 |
| 2023-03-27 | FMWO | Futures | 9511.9 | 9554.9 | 9475.7 | 9502.9 | 11960.0 |
| 2023-03-27 | FOAT | Futures | 128.72 | 129.07 | 127.55 | 128.22 | 131081.0 |
| 2023-03-27 | FSMX | Futures | 28267.5 | 28533.5 | 28167.2 | 28437.5 | 119.0 |
| 2023-03-27 | FTDX | Futures | 3473.7 | 3515.0 | 3473.7 | 3515.0 | 7.0 |
| 2023-03-27 | FTI | Futures | 781.21 | 784.18 | 776.92 | 779.58 | 15618.0 |
> showing 50 of 131 rows — these rows as CSV