PREVIEW / futures_30min / 2024-09-08
file: by_date/futures_30min/2024/2024-09-08.parquet size: 30 KB rows: 842
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-09-08 18:00:00 | ES | Futures | 5673.23 | 5678.73 | 5668.25 | 5674.8 | 9376.0 |
| 2024-09-08 18:30:00 | ES | Futures | 5674.8 | 5680.04 | 5674.8 | 5676.37 | 7634.0 |
| 2024-09-08 19:00:00 | ES | Futures | 5676.11 | 5684.24 | 5671.13 | 5681.62 | 5812.0 |
| 2024-09-08 19:30:00 | ES | Futures | 5681.88 | 5684.24 | 5678.73 | 5681.35 | 4212.0 |
| 2024-09-08 20:00:00 | ES | Futures | 5681.62 | 5691.58 | 5680.83 | 5690.79 | 9252.0 |
| 2024-09-08 20:30:00 | ES | Futures | 5690.79 | 5693.15 | 5687.12 | 5688.7 | 5097.0 |
| 2024-09-08 21:00:00 | ES | Futures | 5688.43 | 5696.04 | 5688.43 | 5694.2 | 6353.0 |
| 2024-09-08 21:30:00 | ES | Futures | 5694.46 | 5697.35 | 5693.68 | 5694.99 | 6354.0 |
| 2024-09-08 22:00:00 | ES | Futures | 5694.73 | 5697.87 | 5692.89 | 5693.68 | 4654.0 |
| 2024-09-08 22:30:00 | ES | Futures | 5693.41 | 5696.56 | 5693.15 | 5696.04 | 2192.0 |
| 2024-09-08 23:00:00 | ES | Futures | 5696.04 | 5699.44 | 5696.04 | 5697.35 | 4211.0 |
| 2024-09-08 23:30:00 | ES | Futures | 5697.61 | 5700.76 | 5697.61 | 5699.71 | 3167.0 |
| 2024-09-08 18:00:00 | NQ | Futures | 19429.11 | 19475.84 | 19419.87 | 19455.77 | 4497.0 |
| 2024-09-08 18:30:00 | NQ | Futures | 19456.57 | 19472.93 | 19443.63 | 19447.06 | 2551.0 |
| 2024-09-08 19:00:00 | NQ | Futures | 19446.53 | 19494.32 | 19414.33 | 19478.21 | 3990.0 |
| 2024-09-08 19:30:00 | NQ | Futures | 19477.68 | 19492.73 | 19466.07 | 19476.1 | 2168.0 |
| 2024-09-08 20:00:00 | NQ | Futures | 19479.8 | 19527.58 | 19473.99 | 19524.67 | 3737.0 |
| 2024-09-08 20:30:00 | NQ | Futures | 19524.67 | 19539.46 | 19504.61 | 19513.85 | 2925.0 |
| 2024-09-08 21:00:00 | NQ | Futures | 19513.85 | 19556.88 | 19513.85 | 19551.07 | 3304.0 |
| 2024-09-08 21:30:00 | NQ | Futures | 19552.39 | 19561.9 | 19538.66 | 19548.43 | 2972.0 |
| 2024-09-08 22:00:00 | NQ | Futures | 19548.43 | 19562.95 | 19532.33 | 19541.57 | 3365.0 |
| 2024-09-08 22:30:00 | NQ | Futures | 19541.3 | 19559.52 | 19538.93 | 19553.98 | 1569.0 |
| 2024-09-08 23:00:00 | NQ | Futures | 19555.03 | 19569.29 | 19552.39 | 19559.52 | 1497.0 |
| 2024-09-08 23:30:00 | NQ | Futures | 19561.1 | 19579.05 | 19561.1 | 19575.89 | 1577.0 |
| 2024-09-08 18:00:00 | YM | Futures | 42385.3 | 42433.6 | 42376.9 | 42413.7 | 1027.0 |
| 2024-09-08 18:30:00 | YM | Futures | 42417.9 | 42448.4 | 42417.9 | 42432.6 | 537.0 |
| 2024-09-08 19:00:00 | YM | Futures | 42431.5 | 42459.9 | 42407.4 | 42447.3 | 572.0 |
| 2024-09-08 19:30:00 | YM | Futures | 42447.3 | 42464.1 | 42434.7 | 42446.3 | 399.0 |
| 2024-09-08 20:00:00 | YM | Futures | 42450.5 | 42505.1 | 42448.4 | 42500.9 | 744.0 |
| 2024-09-08 20:30:00 | YM | Futures | 42500.9 | 42510.3 | 42483.0 | 42491.4 | 401.0 |
| 2024-09-08 21:00:00 | YM | Futures | 42489.3 | 42529.3 | 42489.3 | 42515.6 | 671.0 |
| 2024-09-08 21:30:00 | YM | Futures | 42515.6 | 42545.0 | 42511.4 | 42527.2 | 752.0 |
| 2024-09-08 22:00:00 | YM | Futures | 42526.1 | 42544.0 | 42512.4 | 42516.7 | 434.0 |
| 2024-09-08 22:30:00 | YM | Futures | 42515.6 | 42535.6 | 42514.5 | 42533.5 | 202.0 |
| 2024-09-08 23:00:00 | YM | Futures | 42531.4 | 42554.5 | 42531.4 | 42537.7 | 350.0 |
| 2024-09-08 23:30:00 | YM | Futures | 42538.7 | 42552.4 | 42538.7 | 42549.2 | 294.0 |
| 2024-09-08 18:00:00 | CL | Futures | 60.34 | 60.46 | 60.24 | 60.45 | 1964.0 |
| 2024-09-08 18:30:00 | CL | Futures | 60.45 | 60.46 | 60.37 | 60.45 | 796.0 |
| 2024-09-08 19:00:00 | CL | Futures | 60.45 | 60.52 | 60.38 | 60.48 | 489.0 |
| 2024-09-08 19:30:00 | CL | Futures | 60.48 | 60.54 | 60.44 | 60.51 | 521.0 |
| 2024-09-08 20:00:00 | CL | Futures | 60.51 | 60.7 | 60.5 | 60.68 | 1628.0 |
| 2024-09-08 20:30:00 | CL | Futures | 60.68 | 60.69 | 60.52 | 60.53 | 1252.0 |
| 2024-09-08 21:00:00 | CL | Futures | 60.52 | 60.86 | 60.36 | 60.83 | 4132.0 |
| 2024-09-08 21:30:00 | CL | Futures | 60.83 | 60.85 | 60.68 | 60.69 | 1289.0 |
| 2024-09-08 22:00:00 | CL | Futures | 60.69 | 60.86 | 60.68 | 60.74 | 931.0 |
| 2024-09-08 22:30:00 | CL | Futures | 60.74 | 60.8 | 60.64 | 60.69 | 878.0 |
| 2024-09-08 23:00:00 | CL | Futures | 60.68 | 60.91 | 60.68 | 60.68 | 1527.0 |
| 2024-09-08 23:30:00 | CL | Futures | 60.68 | 60.72 | 60.67 | 60.72 | 830.0 |
| 2024-09-08 18:00:00 | GC | Futures | 2660.3 | 2661.2 | 2659.1 | 2659.4 | 724.0 |
| 2024-09-08 18:30:00 | GC | Futures | 2659.3 | 2661.1 | 2659.2 | 2660.8 | 1687.0 |
> showing 50 of 842 rows — these rows as CSV