PREVIEW / futures_30min / 2024-07-01
file: by_date/futures_30min/2024/2024-07-01.parquet size: 111 KB rows: 3,959
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-07-01 00:00:00 | ES | Futures | 5805.62 | 5805.88 | 5804.31 | 5804.57 | 1597.0 |
| 2024-07-01 00:30:00 | ES | Futures | 5804.57 | 5805.1 | 5802.21 | 5803.26 | 2256.0 |
| 2024-07-01 01:00:00 | ES | Futures | 5803.26 | 5806.67 | 5802.47 | 5806.41 | 2116.0 |
| 2024-07-01 01:30:00 | ES | Futures | 5806.67 | 5808.5 | 5806.41 | 5807.98 | 2643.0 |
| 2024-07-01 02:00:00 | ES | Futures | 5807.98 | 5810.34 | 5807.98 | 5809.55 | 5727.0 |
| 2024-07-01 02:30:00 | ES | Futures | 5809.55 | 5810.6 | 5807.19 | 5808.24 | 4271.0 |
| 2024-07-01 03:00:00 | ES | Futures | 5808.5 | 5810.6 | 5805.1 | 5805.1 | 10971.0 |
| 2024-07-01 03:30:00 | ES | Futures | 5804.83 | 5805.88 | 5794.35 | 5797.49 | 13474.0 |
| 2024-07-01 04:00:00 | ES | Futures | 5797.49 | 5803.52 | 5796.97 | 5802.74 | 8996.0 |
| 2024-07-01 04:30:00 | ES | Futures | 5803.0 | 5805.1 | 5792.77 | 5794.35 | 11434.0 |
| 2024-07-01 05:00:00 | ES | Futures | 5794.35 | 5794.87 | 5789.63 | 5791.46 | 9441.0 |
| 2024-07-01 05:30:00 | ES | Futures | 5791.46 | 5797.49 | 5790.94 | 5796.97 | 7193.0 |
| 2024-07-01 06:00:00 | ES | Futures | 5796.71 | 5799.33 | 5796.18 | 5797.23 | 4999.0 |
| 2024-07-01 06:30:00 | ES | Futures | 5797.23 | 5801.43 | 5795.4 | 5800.64 | 5410.0 |
| 2024-07-01 07:00:00 | ES | Futures | 5800.38 | 5803.79 | 5799.59 | 5802.21 | 6804.0 |
| 2024-07-01 07:30:00 | ES | Futures | 5802.21 | 5805.62 | 5801.95 | 5804.83 | 6307.0 |
| 2024-07-01 08:00:00 | ES | Futures | 5804.57 | 5807.19 | 5802.74 | 5804.57 | 11305.0 |
| 2024-07-01 08:30:00 | ES | Futures | 5804.31 | 5805.36 | 5799.33 | 5803.52 | 13996.0 |
| 2024-07-01 09:00:00 | ES | Futures | 5803.52 | 5806.93 | 5797.23 | 5806.41 | 24245.0 |
| 2024-07-01 09:30:00 | ES | Futures | 5806.41 | 5808.77 | 5789.63 | 5797.23 | 147603.0 |
| 2024-07-01 10:00:00 | ES | Futures | 5797.23 | 5804.05 | 5773.37 | 5791.99 | 175804.0 |
| 2024-07-01 10:30:00 | ES | Futures | 5791.73 | 5792.77 | 5772.33 | 5781.24 | 125716.0 |
| 2024-07-01 11:00:00 | ES | Futures | 5781.5 | 5790.94 | 5776.0 | 5790.68 | 93068.0 |
| 2024-07-01 11:30:00 | ES | Futures | 5790.94 | 5793.82 | 5784.65 | 5793.56 | 62077.0 |
| 2024-07-01 12:00:00 | ES | Futures | 5793.56 | 5802.21 | 5788.06 | 5801.95 | 78578.0 |
| 2024-07-01 12:30:00 | ES | Futures | 5801.95 | 5803.52 | 5797.76 | 5800.12 | 47645.0 |
| 2024-07-01 13:00:00 | ES | Futures | 5800.12 | 5802.21 | 5795.66 | 5800.38 | 43979.0 |
| 2024-07-01 13:30:00 | ES | Futures | 5800.38 | 5802.47 | 5797.49 | 5798.8 | 35090.0 |
| 2024-07-01 14:00:00 | ES | Futures | 5799.07 | 5806.93 | 5794.61 | 5797.76 | 52672.0 |
| 2024-07-01 14:30:00 | ES | Futures | 5797.76 | 5799.59 | 5794.09 | 5796.97 | 41949.0 |
| 2024-07-01 15:00:00 | ES | Futures | 5796.97 | 5801.16 | 5787.01 | 5792.77 | 60193.0 |
| 2024-07-01 15:30:00 | ES | Futures | 5792.51 | 5809.03 | 5791.73 | 5803.0 | 145972.0 |
| 2024-07-01 16:00:00 | ES | Futures | 5803.26 | 5804.31 | 5800.38 | 5801.69 | 38646.0 |
| 2024-07-01 16:30:00 | ES | Futures | 5801.69 | 5802.21 | 5800.64 | 5801.16 | 4793.0 |
| 2024-07-01 18:00:00 | ES | Futures | 5802.74 | 5804.31 | 5800.9 | 5801.43 | 2127.0 |
| 2024-07-01 18:30:00 | ES | Futures | 5801.43 | 5801.69 | 5799.07 | 5799.33 | 1863.0 |
| 2024-07-01 19:00:00 | ES | Futures | 5799.07 | 5799.59 | 5796.71 | 5798.54 | 2097.0 |
| 2024-07-01 19:30:00 | ES | Futures | 5798.28 | 5798.28 | 5795.92 | 5797.76 | 1687.0 |
| 2024-07-01 20:00:00 | ES | Futures | 5798.02 | 5799.07 | 5791.2 | 5792.51 | 4792.0 |
| 2024-07-01 20:30:00 | ES | Futures | 5792.77 | 5793.82 | 5789.63 | 5793.04 | 3274.0 |
| 2024-07-01 21:00:00 | ES | Futures | 5793.3 | 5793.82 | 5791.99 | 5793.56 | 2727.0 |
| 2024-07-01 21:30:00 | ES | Futures | 5793.56 | 5795.4 | 5792.51 | 5793.56 | 3234.0 |
| 2024-07-01 22:00:00 | ES | Futures | 5793.56 | 5795.13 | 5791.46 | 5791.46 | 1898.0 |
| 2024-07-01 22:30:00 | ES | Futures | 5791.46 | 5791.73 | 5787.79 | 5790.15 | 3293.0 |
| 2024-07-01 23:00:00 | ES | Futures | 5790.15 | 5790.94 | 5787.53 | 5788.84 | 2129.0 |
| 2024-07-01 23:30:00 | ES | Futures | 5788.84 | 5790.42 | 5788.32 | 5790.15 | 1703.0 |
| 2024-07-01 00:00:00 | NQ | Futures | 21114.11 | 21115.96 | 21106.19 | 21108.3 | 816.0 |
| 2024-07-01 00:30:00 | NQ | Futures | 21108.3 | 21110.68 | 21091.94 | 21098.01 | 2039.0 |
| 2024-07-01 01:00:00 | NQ | Futures | 21098.01 | 21117.28 | 21095.11 | 21115.96 | 1547.0 |
| 2024-07-01 01:30:00 | NQ | Futures | 21116.49 | 21127.58 | 21115.96 | 21126.26 | 1761.0 |
> showing 50 of 3,959 rows — these rows as CSV