PREVIEW / futures_daily / 2023-09-19
file: by_date/futures_daily/2023/2023-09-19.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-09-19 | ES | Futures | 4820.17 | 4826.86 | 4776.28 | 4805.99 | 1422950.0 |
| 2023-09-19 | NQ | Futures | 16646.16 | 16665.59 | 16456.49 | 16593.28 | 552065.0 |
| 2023-09-19 | YM | Futures | 36771.5 | 36823.1 | 36418.0 | 36640.0 | 161163.0 |
| 2023-09-19 | CL | Futures | 80.21 | 81.49 | 79.63 | 79.78 | 537522.0 |
| 2023-09-19 | GC | Futures | 2105.2 | 2109.1 | 2100.5 | 2103.5 | 131097.0 |
| 2023-09-19 | ZN | Futures | 111.102043 | 111.14957 | 110.610932 | 110.642616 | 1270702.0 |
| 2023-09-19 | A6 | Futures | 0.65093 | 0.65466 | 0.64997 | 0.65284 | 97368.0 |
| 2023-09-19 | AD | Futures | 0.74848 | 0.75458 | 0.74828 | 0.7508 | 114472.0 |
| 2023-09-19 | ALI | Futures | 2446.38 | 2453.81 | 2434.82 | 2442.8 | 1616.0 |
| 2023-09-19 | B | Futures | 84.37 | 85.53 | 83.92 | 84.08 | 403396.0 |
| 2023-09-19 | B6 | Futures | 1.239 | 1.243 | 1.2374 | 1.2395 | 64387.0 |
| 2023-09-19 | BFX | Futures | 3994.6 | 3994.6 | 3994.6 | 3994.6 | 0.0 |
| 2023-09-19 | BR | Futures | 0.19223 | 0.19223 | 0.19129 | 0.19143 | 8.0 |
| 2023-09-19 | BTC | Futures | 35841.5 | 36821.4 | 35614.9 | 36354.8 | 8349.0 |
| 2023-09-19 | BZ | Futures | 84.14 | 85.32 | 83.73 | 83.89 | 43614.0 |
| 2023-09-19 | C | Futures | 2520.0 | 2570.0 | 2517.0 | 2535.0 | 9059.0 |
| 2023-09-19 | CB | Futures | 265.447 | 265.447 | 262.5 | 262.5 | 17.0 |
| 2023-09-19 | CC | Futures | 2124.0 | 2152.0 | 2120.0 | 2125.0 | 22497.0 |
| 2023-09-19 | CNH | Futures | 7.0447 | 7.0588 | 7.0424 | 7.0524 | 133.0 |
| 2023-09-19 | CSC | Futures | 2.077 | 2.077 | 2.061 | 2.066 | 86.0 |
| 2023-09-19 | CT | Futures | 107.85 | 107.85 | 107.26 | 107.26 | 7.0 |
| 2023-09-19 | DC | Futures | 19.35 | 19.36 | 19.21 | 19.26 | 139.0 |
| 2023-09-19 | DX | Futures | 103.341 | 103.469 | 103.05 | 103.412 | 10307.0 |
| 2023-09-19 | E1 | Futures | 1.18027 | 1.18357 | 1.1787 | 1.17896 | 18213.0 |
| 2023-09-19 | E6 | Futures | 1.09199 | 1.09469 | 1.09026 | 1.09052 | 145568.0 |
| 2023-09-19 | E7 | Futures | 1.0921 | 1.0948 | 1.0906 | 1.0908 | 3166.0 |
| 2023-09-19 | EBM | Futures | 325.22 | 329.34 | 323.16 | 325.57 | 47822.0 |
| 2023-09-19 | ER | Futures | 97.741 | 97.751 | 97.736 | 97.741 | 115491.0 |
| 2023-09-19 | ESG | Futures | 416.72 | 417.45 | 413.09 | 415.7 | 394.0 |
| 2023-09-19 | EW | Futures | 2713.1 | 2721.3 | 2694.5 | 2704.6 | 8308.0 |
| 2023-09-19 | FBON | Futures | 119.11 | 119.5 | 119.03 | 119.08 | 66.0 |
| 2023-09-19 | FBTP | Futures | 110.68 | 111.1 | 110.44 | 110.66 | 141416.0 |
| 2023-09-19 | FBTS | Futures | 105.542 | 105.612 | 105.501 | 105.542 | 112406.0 |
| 2023-09-19 | FCE | Futures | 7840.6 | 7888.0 | 7809.4 | 7860.6 | 48573.0 |
| 2023-09-19 | FDAX | Futures | 16737.4 | 16753.2 | 16627.8 | 16657.3 | 51067.0 |
| 2023-09-19 | FDIV | Futures | 181.43 | 181.43 | 181.43 | 181.43 | 0.0 |
| 2023-09-19 | FDXM | Futures | 16713.9 | 16743.4 | 16622.3 | 16650.8 | 42233.0 |
| 2023-09-19 | FDXS | Futures | 16614.2 | 16635.1 | 16513.8 | 16542.0 | 20429.0 |
| 2023-09-19 | FESX | Futures | 4313.4 | 4324.4 | 4287.2 | 4299.3 | 542057.0 |
| 2023-09-19 | FEU3 | Futures | 97.741 | 97.741 | 97.741 | 97.741 | 0.0 |
| 2023-09-19 | FGBL | Futures | 132.15 | 132.26 | 131.54 | 131.71 | 670789.0 |
| 2023-09-19 | FGBM | Futures | 117.32 | 117.38 | 117.03 | 117.11 | 548824.0 |
| 2023-09-19 | FGBS | Futures | 106.933 | 106.958 | 106.867 | 106.887 | 443349.0 |
| 2023-09-19 | FGBX | Futures | 130.28 | 130.57 | 129.07 | 129.52 | 72749.0 |
| 2023-09-19 | FMWO | Futures | 10273.2 | 10303.0 | 10203.7 | 10224.6 | 2353.0 |
| 2023-09-19 | FOAT | Futures | 123.33 | 123.48 | 122.81 | 122.97 | 177129.0 |
| 2023-09-19 | FSMX | Futures | 27932.9 | 28023.3 | 27844.6 | 27894.9 | 68.0 |
| 2023-09-19 | FTDX | Futures | 3183.8 | 3189.0 | 3160.4 | 3163.5 | 40.0 |
| 2023-09-19 | FTI | Futures | 765.64 | 770.1 | 763.25 | 765.31 | 11149.0 |
| 2023-09-19 | FTUK | Futures | 7781.0 | 7800.2 | 7757.4 | 7775.5 | 73799.0 |
> showing 50 of 130 rows — these rows as CSV