PREVIEW / futures_daily / 2023-08-16
file: by_date/futures_daily/2023/2023-08-16.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-08-16 | ES | Futures | 4822.65 | 4837.81 | 4783.39 | 4786.64 | 1499218.0 |
| 2023-08-16 | NQ | Futures | 16533.76 | 16594.21 | 16326.69 | 16349.39 | 641607.0 |
| 2023-08-16 | YM | Futures | 37202.9 | 37398.5 | 36987.2 | 37006.3 | 166423.0 |
| 2023-08-16 | CL | Futures | 70.57 | 70.77 | 68.77 | 69.07 | 237705.0 |
| 2023-08-16 | GC | Futures | 2081.3 | 2086.8 | 2069.4 | 2076.2 | 128612.0 |
| 2023-08-16 | ZN | Futures | 111.784115 | 112.133987 | 111.37063 | 111.51376 | 1768369.0 |
| 2023-08-16 | A6 | Futures | 0.6546 | 0.65713 | 0.65055 | 0.65161 | 77283.0 |
| 2023-08-16 | AD | Futures | 0.74895 | 0.75011 | 0.74627 | 0.74683 | 68065.0 |
| 2023-08-16 | ALI | Futures | 2350.16 | 2356.51 | 2336.66 | 2350.99 | 1483.0 |
| 2023-08-16 | B | Futures | 75.4 | 75.54 | 73.57 | 73.85 | 334451.0 |
| 2023-08-16 | B6 | Futures | 1.2729 | 1.2792 | 1.2712 | 1.2749 | 79697.0 |
| 2023-08-16 | BFX | Futures | 4002.7 | 4002.7 | 4002.7 | 4002.7 | 0.0 |
| 2023-08-16 | BR | Futures | 0.18592 | 0.1877 | 0.18588 | 0.18648 | 13737.0 |
| 2023-08-16 | BTC | Futures | 38752.2 | 38818.4 | 38222.3 | 38586.6 | 5150.0 |
| 2023-08-16 | BZ | Futures | 75.1 | 75.31 | 73.33 | 73.62 | 31925.0 |
| 2023-08-16 | C | Futures | 2267.0 | 2267.0 | 2231.0 | 2258.0 | 2332.0 |
| 2023-08-16 | CB | Futures | 255.737 | 261.214 | 255.023 | 261.214 | 14.0 |
| 2023-08-16 | CC | Futures | 2001.0 | 2019.0 | 1994.0 | 2014.0 | 25904.0 |
| 2023-08-16 | CNH | Futures | 7.0396 | 7.0579 | 7.0197 | 7.0535 | 691.0 |
| 2023-08-16 | CSC | Futures | 2.041 | 2.041 | 2.002 | 2.028 | 160.0 |
| 2023-08-16 | CT | Futures | 107.27 | 107.27 | 106.28 | 106.34 | 17.0 |
| 2023-08-16 | DC | Futures | 18.72 | 18.76 | 18.35 | 18.64 | 545.0 |
| 2023-08-16 | DX | Futures | 101.141 | 101.45 | 100.876 | 101.361 | 14041.0 |
| 2023-08-16 | E1 | Futures | 1.21185 | 1.21317 | 1.20766 | 1.21015 | 12146.0 |
| 2023-08-16 | E6 | Futures | 1.11766 | 1.12068 | 1.11428 | 1.11521 | 135438.0 |
| 2023-08-16 | E7 | Futures | 1.1179 | 1.1207 | 1.1143 | 1.1153 | 3507.0 |
| 2023-08-16 | EBM | Futures | 337.19 | 339.75 | 332.8 | 336.46 | 17906.0 |
| 2023-08-16 | ER | Futures | 97.828 | 97.833 | 97.812 | 97.822 | 75044.0 |
| 2023-08-16 | ESG | Futures | 418.03 | 419.32 | 413.41 | 414.96 | 480.0 |
| 2023-08-16 | EW | Futures | 2790.8 | 2798.8 | 2760.9 | 2762.2 | 11200.0 |
| 2023-08-16 | FBON | Futures | 119.93 | 120.16 | 119.89 | 120.16 | 57.0 |
| 2023-08-16 | FBTP | Futures | 111.72 | 112.17 | 111.71 | 111.93 | 127849.0 |
| 2023-08-16 | FBTS | Futures | 105.856 | 105.977 | 105.856 | 105.946 | 97699.0 |
| 2023-08-16 | FCE | Futures | 7846.2 | 7924.1 | 7835.4 | 7879.7 | 51797.0 |
| 2023-08-16 | FDAX | Futures | 16716.4 | 16796.9 | 16641.3 | 16758.8 | 48206.0 |
| 2023-08-16 | FDIV | Futures | 183.52 | 183.52 | 183.52 | 183.52 | 0.0 |
| 2023-08-16 | FDXM | Futures | 16794.4 | 16865.7 | 16708.4 | 16827.4 | 36886.0 |
| 2023-08-16 | FDXS | Futures | 16676.3 | 16757.6 | 16603.4 | 16719.6 | 17800.0 |
| 2023-08-16 | FESX | Futures | 4347.9 | 4375.2 | 4326.6 | 4353.0 | 624793.0 |
| 2023-08-16 | FEU3 | Futures | 97.812 | 97.812 | 97.812 | 97.812 | 0.0 |
| 2023-08-16 | FGBL | Futures | 132.29 | 132.94 | 132.29 | 132.8 | 531418.0 |
| 2023-08-16 | FGBM | Futures | 117.64 | 117.94 | 117.61 | 117.9 | 433681.0 |
| 2023-08-16 | FGBS | Futures | 107.279 | 107.381 | 107.264 | 107.366 | 315873.0 |
| 2023-08-16 | FGBX | Futures | 132.27 | 133.5 | 132.19 | 133.15 | 71587.0 |
| 2023-08-16 | FMWO | Futures | 10251.5 | 10292.9 | 10178.8 | 10263.8 | 2082.0 |
| 2023-08-16 | FOAT | Futures | 123.48 | 124.14 | 123.48 | 123.98 | 131344.0 |
| 2023-08-16 | FSMX | Futures | 29021.1 | 29038.8 | 29008.7 | 29038.8 | 35.0 |
| 2023-08-16 | FTDX | Futures | 3296.0 | 3296.0 | 3286.0 | 3292.3 | 29.0 |
| 2023-08-16 | FTI | Futures | 790.98 | 793.97 | 786.57 | 791.24 | 13556.0 |
| 2023-08-16 | FTUK | Futures | 7512.2 | 7525.9 | 7461.4 | 7480.2 | 95360.0 |
> showing 50 of 130 rows — these rows as CSV