PREVIEW / futures_1hour / 2025-03-27
file: by_date/futures_1hour/2025/2025-03-27.parquet size: 67 KB rows: 2,109
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 |
|---|---|---|---|---|---|---|---|
| 2025-03-27 00:00:00 | ES | Futures | 5859.43 | 5862.74 | 5858.67 | 5861.21 | 5011.0 |
| 2025-03-27 01:00:00 | ES | Futures | 5860.96 | 5865.02 | 5857.15 | 5857.4 | 7093.0 |
| 2025-03-27 02:00:00 | ES | Futures | 5857.66 | 5866.04 | 5856.39 | 5857.66 | 10064.0 |
| 2025-03-27 03:00:00 | ES | Futures | 5857.66 | 5859.94 | 5847.24 | 5848.26 | 13034.0 |
| 2025-03-27 04:00:00 | ES | Futures | 5848.51 | 5857.91 | 5835.81 | 5857.15 | 24729.0 |
| 2025-03-27 05:00:00 | ES | Futures | 5857.4 | 5860.96 | 5852.07 | 5858.42 | 13557.0 |
| 2025-03-27 06:00:00 | ES | Futures | 5858.67 | 5863.24 | 5846.48 | 5846.73 | 11854.0 |
| 2025-03-27 07:00:00 | ES | Futures | 5846.99 | 5853.34 | 5837.59 | 5850.8 | 19993.0 |
| 2025-03-27 08:00:00 | ES | Futures | 5850.54 | 5854.1 | 5842.16 | 5844.95 | 31757.0 |
| 2025-03-27 09:00:00 | ES | Futures | 5844.95 | 5848.26 | 5812.44 | 5846.99 | 199601.0 |
| 2025-03-27 10:00:00 | ES | Futures | 5846.73 | 5872.14 | 5838.6 | 5872.14 | 207094.0 |
| 2025-03-27 11:00:00 | ES | Futures | 5872.14 | 5873.15 | 5841.9 | 5843.18 | 160796.0 |
| 2025-03-27 12:00:00 | ES | Futures | 5843.18 | 5863.24 | 5828.95 | 5829.46 | 156405.0 |
| 2025-03-27 13:00:00 | ES | Futures | 5829.46 | 5845.46 | 5826.41 | 5829.71 | 133916.0 |
| 2025-03-27 14:00:00 | ES | Futures | 5829.71 | 5855.88 | 5828.69 | 5839.11 | 140149.0 |
| 2025-03-27 15:00:00 | ES | Futures | 5839.11 | 5864.51 | 5830.22 | 5833.27 | 260807.0 |
| 2025-03-27 16:00:00 | ES | Futures | 5833.52 | 5838.6 | 5832.25 | 5834.03 | 51645.0 |
| 2025-03-27 18:00:00 | ES | Futures | 5834.54 | 5837.59 | 5831.49 | 5832.51 | 3885.0 |
| 2025-03-27 19:00:00 | ES | Futures | 5832.51 | 5833.52 | 5824.38 | 5828.69 | 4970.0 |
| 2025-03-27 20:00:00 | ES | Futures | 5828.69 | 5834.54 | 5820.31 | 5833.78 | 8337.0 |
| 2025-03-27 21:00:00 | ES | Futures | 5833.78 | 5836.32 | 5829.97 | 5830.98 | 6790.0 |
| 2025-03-27 22:00:00 | ES | Futures | 5830.98 | 5838.09 | 5830.22 | 5835.05 | 5000.0 |
| 2025-03-27 23:00:00 | ES | Futures | 5835.3 | 5838.35 | 5832.51 | 5837.84 | 4359.0 |
| 2025-03-27 00:00:00 | NQ | Futures | 20509.23 | 20522.47 | 20500.06 | 20508.97 | 2522.0 |
| 2025-03-27 01:00:00 | NQ | Futures | 20508.72 | 20518.9 | 20486.56 | 20488.85 | 3328.0 |
| 2025-03-27 02:00:00 | NQ | Futures | 20488.85 | 20514.83 | 20477.14 | 20486.31 | 5497.0 |
| 2025-03-27 03:00:00 | NQ | Futures | 20485.54 | 20494.71 | 20441.74 | 20446.84 | 8569.0 |
| 2025-03-27 04:00:00 | NQ | Futures | 20448.62 | 20489.36 | 20392.59 | 20486.31 | 13791.0 |
| 2025-03-27 05:00:00 | NQ | Futures | 20486.56 | 20503.88 | 20467.97 | 20490.64 | 6481.0 |
| 2025-03-27 06:00:00 | NQ | Futures | 20491.65 | 20513.3 | 20446.58 | 20449.13 | 7065.0 |
| 2025-03-27 07:00:00 | NQ | Futures | 20448.36 | 20471.03 | 20403.8 | 20464.15 | 10985.0 |
| 2025-03-27 08:00:00 | NQ | Futures | 20462.62 | 20479.43 | 20422.64 | 20437.92 | 17908.0 |
| 2025-03-27 09:00:00 | NQ | Futures | 20438.94 | 20464.92 | 20308.3 | 20450.15 | 99668.0 |
| 2025-03-27 10:00:00 | NQ | Futures | 20450.15 | 20575.44 | 20400.49 | 20564.99 | 93056.0 |
| 2025-03-27 11:00:00 | NQ | Futures | 20565.5 | 20569.58 | 20413.48 | 20421.12 | 65363.0 |
| 2025-03-27 12:00:00 | NQ | Futures | 20421.12 | 20530.87 | 20378.33 | 20380.88 | 62158.0 |
| 2025-03-27 13:00:00 | NQ | Futures | 20380.88 | 20444.29 | 20373.24 | 20387.5 | 47282.0 |
| 2025-03-27 14:00:00 | NQ | Futures | 20387.25 | 20483.51 | 20383.43 | 20418.31 | 50380.0 |
| 2025-03-27 15:00:00 | NQ | Futures | 20418.06 | 20504.39 | 20346.76 | 20366.62 | 75416.0 |
| 2025-03-27 16:00:00 | NQ | Futures | 20366.62 | 20391.58 | 20360.0 | 20369.42 | 15144.0 |
| 2025-03-27 18:00:00 | NQ | Futures | 20367.38 | 20384.19 | 20355.16 | 20363.06 | 3278.0 |
| 2025-03-27 19:00:00 | NQ | Futures | 20364.07 | 20368.15 | 20324.86 | 20336.32 | 4383.0 |
| 2025-03-27 20:00:00 | NQ | Futures | 20336.57 | 20358.73 | 20302.19 | 20355.92 | 4839.0 |
| 2025-03-27 21:00:00 | NQ | Futures | 20355.92 | 20363.82 | 20332.24 | 20336.32 | 3241.0 |
| 2025-03-27 22:00:00 | NQ | Futures | 20336.83 | 20370.19 | 20334.79 | 20355.16 | 2497.0 |
| 2025-03-27 23:00:00 | NQ | Futures | 20356.18 | 20365.35 | 20339.88 | 20361.27 | 2211.0 |
| 2025-03-27 00:00:00 | YM | Futures | 44051.4 | 44073.1 | 44046.3 | 44068.9 | 670.0 |
| 2025-03-27 01:00:00 | YM | Futures | 44067.9 | 44105.0 | 44055.6 | 44060.7 | 1028.0 |
| 2025-03-27 02:00:00 | YM | Futures | 44061.7 | 44121.4 | 44055.6 | 44070.0 | 983.0 |
| 2025-03-27 03:00:00 | YM | Futures | 44071.0 | 44085.4 | 44009.3 | 44015.4 | 1895.0 |
> showing 50 of 2,109 rows — these rows as CSV