PREVIEW / futures_30min / 2024-04-24
file: by_date/futures_30min/2024/2024-04-24.parquet size: 109 KB rows: 3,984
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-04-24 00:00:00 | ES | Futures | 5438.83 | 5439.09 | 5437.24 | 5438.03 | 1397.0 |
| 2024-04-24 00:30:00 | ES | Futures | 5437.77 | 5438.56 | 5436.97 | 5438.03 | 1245.0 |
| 2024-04-24 01:00:00 | ES | Futures | 5438.03 | 5441.21 | 5437.5 | 5439.36 | 1808.0 |
| 2024-04-24 01:30:00 | ES | Futures | 5439.36 | 5442.54 | 5438.83 | 5441.21 | 2529.0 |
| 2024-04-24 02:00:00 | ES | Futures | 5441.21 | 5441.21 | 5436.44 | 5436.97 | 4580.0 |
| 2024-04-24 02:30:00 | ES | Futures | 5436.97 | 5437.5 | 5432.73 | 5434.85 | 5040.0 |
| 2024-04-24 03:00:00 | ES | Futures | 5434.85 | 5435.91 | 5428.75 | 5430.87 | 11229.0 |
| 2024-04-24 03:30:00 | ES | Futures | 5430.6 | 5434.05 | 5429.01 | 5431.93 | 7191.0 |
| 2024-04-24 04:00:00 | ES | Futures | 5431.93 | 5432.99 | 5429.28 | 5429.81 | 8444.0 |
| 2024-04-24 04:30:00 | ES | Futures | 5430.07 | 5432.19 | 5426.09 | 5426.36 | 8430.0 |
| 2024-04-24 05:00:00 | ES | Futures | 5426.62 | 5428.48 | 5423.97 | 5425.03 | 8963.0 |
| 2024-04-24 05:30:00 | ES | Futures | 5425.03 | 5426.09 | 5418.93 | 5421.32 | 8226.0 |
| 2024-04-24 06:00:00 | ES | Futures | 5421.32 | 5427.42 | 5421.05 | 5427.15 | 9773.0 |
| 2024-04-24 06:30:00 | ES | Futures | 5426.89 | 5427.68 | 5421.58 | 5423.17 | 5401.0 |
| 2024-04-24 07:00:00 | ES | Futures | 5423.17 | 5430.07 | 5422.38 | 5429.54 | 10106.0 |
| 2024-04-24 07:30:00 | ES | Futures | 5429.54 | 5433.79 | 5427.95 | 5432.46 | 10558.0 |
| 2024-04-24 08:00:00 | ES | Futures | 5432.73 | 5435.38 | 5430.07 | 5433.79 | 12413.0 |
| 2024-04-24 08:30:00 | ES | Futures | 5433.79 | 5438.3 | 5422.38 | 5423.97 | 33414.0 |
| 2024-04-24 09:00:00 | ES | Futures | 5423.97 | 5430.34 | 5421.05 | 5429.81 | 27456.0 |
| 2024-04-24 09:30:00 | ES | Futures | 5429.81 | 5438.3 | 5422.64 | 5426.36 | 146867.0 |
| 2024-04-24 10:00:00 | ES | Futures | 5426.62 | 5435.91 | 5422.91 | 5426.09 | 101263.0 |
| 2024-04-24 10:30:00 | ES | Futures | 5426.36 | 5428.48 | 5412.83 | 5415.48 | 95557.0 |
| 2024-04-24 11:00:00 | ES | Futures | 5415.22 | 5417.34 | 5402.75 | 5408.85 | 99588.0 |
| 2024-04-24 11:30:00 | ES | Futures | 5409.11 | 5414.42 | 5397.97 | 5399.3 | 89721.0 |
| 2024-04-24 12:00:00 | ES | Futures | 5399.3 | 5406.99 | 5396.11 | 5403.28 | 69730.0 |
| 2024-04-24 12:30:00 | ES | Futures | 5403.01 | 5406.46 | 5392.93 | 5405.67 | 64901.0 |
| 2024-04-24 13:00:00 | ES | Futures | 5405.4 | 5415.48 | 5402.75 | 5414.95 | 53373.0 |
| 2024-04-24 13:30:00 | ES | Futures | 5415.22 | 5429.54 | 5414.95 | 5428.48 | 73837.0 |
| 2024-04-24 14:00:00 | ES | Futures | 5428.48 | 5429.01 | 5411.5 | 5413.36 | 83841.0 |
| 2024-04-24 14:30:00 | ES | Futures | 5413.36 | 5415.75 | 5406.73 | 5406.73 | 66980.0 |
| 2024-04-24 15:00:00 | ES | Futures | 5406.73 | 5425.56 | 5404.6 | 5421.85 | 80987.0 |
| 2024-04-24 15:30:00 | ES | Futures | 5422.11 | 5425.83 | 5417.6 | 5417.6 | 110468.0 |
| 2024-04-24 16:00:00 | ES | Futures | 5417.87 | 5421.58 | 5382.58 | 5392.93 | 82264.0 |
| 2024-04-24 16:30:00 | ES | Futures | 5392.93 | 5393.2 | 5386.56 | 5390.54 | 13181.0 |
| 2024-04-24 18:00:00 | ES | Futures | 5380.2 | 5388.16 | 5380.2 | 5387.89 | 8053.0 |
| 2024-04-24 18:30:00 | ES | Futures | 5387.89 | 5388.42 | 5382.85 | 5384.71 | 3696.0 |
| 2024-04-24 19:00:00 | ES | Futures | 5384.71 | 5388.69 | 5384.44 | 5387.63 | 4048.0 |
| 2024-04-24 19:30:00 | ES | Futures | 5387.63 | 5388.69 | 5381.79 | 5385.5 | 3314.0 |
| 2024-04-24 20:00:00 | ES | Futures | 5385.5 | 5390.28 | 5384.71 | 5388.16 | 4880.0 |
| 2024-04-24 20:30:00 | ES | Futures | 5388.42 | 5392.93 | 5387.89 | 5391.87 | 4164.0 |
| 2024-04-24 21:00:00 | ES | Futures | 5392.14 | 5392.4 | 5388.42 | 5390.81 | 2196.0 |
| 2024-04-24 21:30:00 | ES | Futures | 5390.81 | 5391.34 | 5384.97 | 5385.24 | 4445.0 |
| 2024-04-24 22:00:00 | ES | Futures | 5385.24 | 5388.42 | 5384.97 | 5386.83 | 2134.0 |
| 2024-04-24 22:30:00 | ES | Futures | 5386.83 | 5387.09 | 5383.65 | 5385.24 | 2123.0 |
| 2024-04-24 23:00:00 | ES | Futures | 5385.24 | 5385.77 | 5384.44 | 5384.97 | 1501.0 |
| 2024-04-24 23:30:00 | ES | Futures | 5385.24 | 5385.24 | 5383.65 | 5384.97 | 1251.0 |
| 2024-04-24 00:00:00 | NQ | Futures | 18974.33 | 18975.13 | 18965.77 | 18970.05 | 1168.0 |
| 2024-04-24 00:30:00 | NQ | Futures | 18969.51 | 18972.72 | 18966.04 | 18969.25 | 940.0 |
| 2024-04-24 01:00:00 | NQ | Futures | 18969.51 | 18981.82 | 18967.37 | 18973.79 | 1412.0 |
| 2024-04-24 01:30:00 | NQ | Futures | 18973.79 | 18990.11 | 18970.58 | 18982.89 | 1898.0 |
> showing 50 of 3,984 rows — these rows as CSV