PREVIEW / futures_daily / 2023-07-12
file: by_date/futures_daily/2023/2023-07-12.parquet size: 10 KB rows: 130
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-07-12 | ES | Futures | 4841.87 | 4899.0 | 4840.79 | 4881.4 | 1784296.0 |
| 2023-07-12 | NQ | Futures | 16694.88 | 16968.15 | 16691.05 | 16899.21 | 649433.0 |
| 2023-07-12 | YM | Futures | 36600.4 | 36975.5 | 36569.5 | 36718.3 | 151138.0 |
| 2023-07-12 | CL | Futures | 64.94 | 66.09 | 64.8 | 65.74 | 352887.0 |
| 2023-07-12 | GC | Futures | 2130.5 | 2160.3 | 2130.0 | 2156.6 | 270869.0 |
| 2023-07-12 | ZN | Futures | 113.31083 | 114.376349 | 113.279023 | 114.265026 | 2044759.0 |
| 2023-07-12 | A6 | Futures | 0.67876 | 0.68996 | 0.67841 | 0.6896 | 127044.0 |
| 2023-07-12 | AD | Futures | 0.76441 | 0.76941 | 0.76426 | 0.76694 | 88055.0 |
| 2023-07-12 | ALI | Futures | 2388.86 | 2470.1 | 2388.86 | 2465.94 | 2459.0 |
| 2023-07-12 | B | Futures | 69.49 | 70.57 | 69.4 | 70.18 | 362333.0 |
| 2023-07-12 | B6 | Futures | 1.2954 | 1.3028 | 1.2931 | 1.302 | 124974.0 |
| 2023-07-12 | BFX | Futures | 3947.9 | 3947.9 | 3947.9 | 3947.9 | 0.0 |
| 2023-07-12 | BR | Futures | 0.19007 | 0.1925 | 0.19007 | 0.19189 | 199.0 |
| 2023-07-12 | BTC | Futures | 41183.3 | 41833.8 | 40673.6 | 40767.5 | 10377.0 |
| 2023-07-12 | BZ | Futures | 69.33 | 70.46 | 69.28 | 70.06 | 25367.0 |
| 2023-07-12 | C | Futures | 2185.0 | 2190.0 | 2148.0 | 2151.0 | 8123.0 |
| 2023-07-12 | CB | Futures | 232.402 | 232.402 | 231.926 | 232.164 | 17.0 |
| 2023-07-12 | CC | Futures | 1940.0 | 1949.0 | 1919.0 | 1936.0 | 19996.0 |
| 2023-07-12 | CNH | Futures | 6.8954 | 6.8954 | 6.8569 | 6.8603 | 410.0 |
| 2023-07-12 | CSC | Futures | 1.865 | 1.871 | 1.796 | 1.796 | 79.0 |
| 2023-07-12 | CT | Futures | 104.11 | 104.66 | 102.53 | 102.84 | 21.0 |
| 2023-07-12 | DC | Futures | 17.1 | 17.1 | 16.36 | 16.41 | 329.0 |
| 2023-07-12 | DX | Futures | 99.375 | 99.375 | 98.281 | 98.294 | 21382.0 |
| 2023-07-12 | E1 | Futures | 1.21482 | 1.23391 | 1.21455 | 1.23258 | 35600.0 |
| 2023-07-12 | E6 | Futures | 1.1304 | 1.14396 | 1.1302 | 1.14371 | 238543.0 |
| 2023-07-12 | E7 | Futures | 1.1303 | 1.144 | 1.1303 | 1.1438 | 6583.0 |
| 2023-07-12 | EBM | Futures | 338.29 | 339.39 | 332.43 | 333.53 | 22901.0 |
| 2023-07-12 | ER | Futures | 97.777 | 97.792 | 97.772 | 97.787 | 108299.0 |
| 2023-07-12 | ESG | Futures | 419.53 | 424.01 | 419.19 | 422.23 | 1443.0 |
| 2023-07-12 | EW | Futures | 2836.5 | 2880.1 | 2836.0 | 2858.7 | 11628.0 |
| 2023-07-12 | FBON | Futures | 119.95 | 120.95 | 119.94 | 120.9 | 72.0 |
| 2023-07-12 | FBTP | Futures | 111.32 | 112.58 | 111.32 | 112.42 | 144087.0 |
| 2023-07-12 | FBTS | Futures | 105.401 | 105.775 | 105.401 | 105.755 | 104842.0 |
| 2023-07-12 | FCE | Futures | 7867.8 | 7978.7 | 7857.5 | 7964.1 | 3177.0 |
| 2023-07-12 | FDAX | Futures | 16867.8 | 17095.4 | 16840.3 | 17075.3 | 69004.0 |
| 2023-07-12 | FDIV | Futures | 185.26 | 186.33 | 185.26 | 186.33 | 3.0 |
| 2023-07-12 | FDXM | Futures | 16944.3 | 17166.5 | 16909.2 | 17145.2 | 41787.0 |
| 2023-07-12 | FDXS | Futures | 16815.7 | 17055.4 | 16800.9 | 17035.4 | 20796.0 |
| 2023-07-12 | FESX | Futures | 4380.3 | 4450.2 | 4377.3 | 4444.1 | 915815.0 |
| 2023-07-12 | FEU3 | Futures | 97.782 | 97.782 | 97.782 | 97.782 | 0.0 |
| 2023-07-12 | FGBL | Futures | 132.79 | 133.79 | 132.63 | 133.6 | 754135.0 |
| 2023-07-12 | FGBM | Futures | 117.42 | 117.93 | 117.37 | 117.87 | 620786.0 |
| 2023-07-12 | FGBS | Futures | 107.069 | 107.223 | 107.059 | 107.202 | 379574.0 |
| 2023-07-12 | FGBX | Futures | 135.8 | 137.44 | 135.27 | 136.91 | 75470.0 |
| 2023-07-12 | FMWO | Futures | 10353.3 | 10487.4 | 10353.3 | 10476.3 | 3048.0 |
| 2023-07-12 | FOAT | Futures | 124.08 | 125.03 | 123.88 | 124.86 | 157816.0 |
| 2023-07-12 | FSMX | Futures | 28797.5 | 29276.0 | 28796.5 | 29276.0 | 280.0 |
| 2023-07-12 | FTDX | Futures | 3322.9 | 3375.5 | 3322.9 | 3375.0 | 57.0 |
| 2023-07-12 | FTI | Futures | 796.69 | 808.16 | 796.69 | 806.22 | 17.0 |
| 2023-07-12 | FTUK | Futures | 7405.0 | 7541.7 | 7403.0 | 7536.6 | 105109.0 |
> showing 50 of 130 rows — these rows as CSV