PREVIEW / futures_1hour / 2024-04-24
file: by_date/futures_1hour/2024/2024-04-24.parquet size: 67 KB rows: 2,095
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 | 5436.97 | 5438.03 | 2642.0 |
| 2024-04-24 01:00:00 | ES | Futures | 5438.03 | 5442.54 | 5437.5 | 5441.21 | 4337.0 |
| 2024-04-24 02:00:00 | ES | Futures | 5441.21 | 5441.21 | 5432.73 | 5434.85 | 9620.0 |
| 2024-04-24 03:00:00 | ES | Futures | 5434.85 | 5435.91 | 5428.75 | 5431.93 | 18420.0 |
| 2024-04-24 04:00:00 | ES | Futures | 5431.93 | 5432.99 | 5426.09 | 5426.36 | 16874.0 |
| 2024-04-24 05:00:00 | ES | Futures | 5426.62 | 5428.48 | 5418.93 | 5421.32 | 17189.0 |
| 2024-04-24 06:00:00 | ES | Futures | 5421.32 | 5427.68 | 5421.05 | 5423.17 | 15174.0 |
| 2024-04-24 07:00:00 | ES | Futures | 5423.17 | 5433.79 | 5422.38 | 5432.46 | 20664.0 |
| 2024-04-24 08:00:00 | ES | Futures | 5432.73 | 5438.3 | 5422.38 | 5423.97 | 45827.0 |
| 2024-04-24 09:00:00 | ES | Futures | 5423.97 | 5438.3 | 5421.05 | 5426.36 | 174323.0 |
| 2024-04-24 10:00:00 | ES | Futures | 5426.62 | 5435.91 | 5412.83 | 5415.48 | 196820.0 |
| 2024-04-24 11:00:00 | ES | Futures | 5415.22 | 5417.34 | 5397.97 | 5399.3 | 189309.0 |
| 2024-04-24 12:00:00 | ES | Futures | 5399.3 | 5406.99 | 5392.93 | 5405.67 | 134631.0 |
| 2024-04-24 13:00:00 | ES | Futures | 5405.4 | 5429.54 | 5402.75 | 5428.48 | 127210.0 |
| 2024-04-24 14:00:00 | ES | Futures | 5428.48 | 5429.01 | 5406.73 | 5406.73 | 150821.0 |
| 2024-04-24 15:00:00 | ES | Futures | 5406.73 | 5425.83 | 5404.6 | 5417.6 | 191455.0 |
| 2024-04-24 16:00:00 | ES | Futures | 5417.87 | 5421.58 | 5382.58 | 5390.54 | 95445.0 |
| 2024-04-24 18:00:00 | ES | Futures | 5380.2 | 5388.42 | 5380.2 | 5384.71 | 11749.0 |
| 2024-04-24 19:00:00 | ES | Futures | 5384.71 | 5388.69 | 5381.79 | 5385.5 | 7362.0 |
| 2024-04-24 20:00:00 | ES | Futures | 5385.5 | 5392.93 | 5384.71 | 5391.87 | 9044.0 |
| 2024-04-24 21:00:00 | ES | Futures | 5392.14 | 5392.4 | 5384.97 | 5385.24 | 6641.0 |
| 2024-04-24 22:00:00 | ES | Futures | 5385.24 | 5388.42 | 5383.65 | 5385.24 | 4257.0 |
| 2024-04-24 23:00:00 | ES | Futures | 5385.24 | 5385.77 | 5383.65 | 5384.97 | 2752.0 |
| 2024-04-24 00:00:00 | NQ | Futures | 18974.33 | 18975.13 | 18965.77 | 18969.25 | 2108.0 |
| 2024-04-24 01:00:00 | NQ | Futures | 18969.51 | 18990.11 | 18967.37 | 18982.89 | 3310.0 |
| 2024-04-24 02:00:00 | NQ | Futures | 18983.42 | 18986.9 | 18959.88 | 18972.46 | 6455.0 |
| 2024-04-24 03:00:00 | NQ | Futures | 18972.99 | 18981.55 | 18949.99 | 18968.71 | 9088.0 |
| 2024-04-24 04:00:00 | NQ | Futures | 18968.98 | 18969.51 | 18929.39 | 18935.01 | 9043.0 |
| 2024-04-24 05:00:00 | NQ | Futures | 18936.08 | 18949.18 | 18903.97 | 18919.49 | 8461.0 |
| 2024-04-24 06:00:00 | NQ | Futures | 18918.95 | 18951.59 | 18912.53 | 18934.47 | 9301.0 |
| 2024-04-24 07:00:00 | NQ | Futures | 18934.47 | 18972.46 | 18931.26 | 18965.23 | 11745.0 |
| 2024-04-24 08:00:00 | NQ | Futures | 18966.04 | 18997.87 | 18935.81 | 18944.9 | 20287.0 |
| 2024-04-24 09:00:00 | NQ | Futures | 18944.9 | 19041.47 | 18926.71 | 18977.81 | 102208.0 |
| 2024-04-24 10:00:00 | NQ | Futures | 18978.61 | 19020.87 | 18915.48 | 18933.13 | 90780.0 |
| 2024-04-24 11:00:00 | NQ | Futures | 18932.6 | 18940.36 | 18835.23 | 18840.31 | 77203.0 |
| 2024-04-24 12:00:00 | NQ | Futures | 18840.31 | 18865.72 | 18797.24 | 18856.63 | 61732.0 |
| 2024-04-24 13:00:00 | NQ | Futures | 18856.63 | 18944.9 | 18840.04 | 18937.68 | 52140.0 |
| 2024-04-24 14:00:00 | NQ | Futures | 18937.95 | 18942.5 | 18842.72 | 18845.66 | 61199.0 |
| 2024-04-24 15:00:00 | NQ | Futures | 18845.93 | 18925.11 | 18838.97 | 18894.61 | 63422.0 |
| 2024-04-24 16:00:00 | NQ | Futures | 18894.61 | 18914.94 | 18705.75 | 18733.04 | 41652.0 |
| 2024-04-24 18:00:00 | NQ | Futures | 18671.78 | 18711.37 | 18658.41 | 18689.97 | 9380.0 |
| 2024-04-24 19:00:00 | NQ | Futures | 18690.51 | 18707.09 | 18668.84 | 18686.49 | 4454.0 |
| 2024-04-24 20:00:00 | NQ | Futures | 18686.76 | 18719.4 | 18680.34 | 18712.98 | 5990.0 |
| 2024-04-24 21:00:00 | NQ | Futures | 18713.51 | 18716.45 | 18682.48 | 18684.35 | 4030.0 |
| 2024-04-24 22:00:00 | NQ | Futures | 18684.62 | 18697.46 | 18678.47 | 18687.83 | 3170.0 |
| 2024-04-24 23:00:00 | NQ | Futures | 18688.1 | 18689.44 | 18679.0 | 18682.75 | 1511.0 |
| 2024-04-24 00:00:00 | YM | Futures | 41171.8 | 41172.8 | 41162.2 | 41166.4 | 486.0 |
| 2024-04-24 01:00:00 | YM | Futures | 41168.6 | 41195.1 | 41165.4 | 41185.6 | 676.0 |
| 2024-04-24 02:00:00 | YM | Futures | 41186.6 | 41187.7 | 41133.5 | 41149.5 | 1664.0 |
| 2024-04-24 03:00:00 | YM | Futures | 41147.3 | 41147.3 | 41098.5 | 41126.1 | 2426.0 |
> showing 50 of 2,095 rows — these rows as CSV