PREVIEW / futures_1hour / 2025-06-25
file: by_date/futures_1hour/2025/2025-06-25.parquet size: 66 KB rows: 2,041
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-06-25 00:00:00 | ES | Futures | 6189.57 | 6194.1 | 6189.32 | 6194.1 | 1288.0 |
| 2025-06-25 01:00:00 | ES | Futures | 6193.85 | 6195.87 | 6192.59 | 6194.35 | 3048.0 |
| 2025-06-25 02:00:00 | ES | Futures | 6194.35 | 6195.87 | 6191.58 | 6191.58 | 4415.0 |
| 2025-06-25 03:00:00 | ES | Futures | 6191.58 | 6195.11 | 6189.06 | 6192.59 | 8954.0 |
| 2025-06-25 04:00:00 | ES | Futures | 6192.59 | 6194.61 | 6187.3 | 6194.1 | 8613.0 |
| 2025-06-25 05:00:00 | ES | Futures | 6194.35 | 6197.88 | 6190.32 | 6190.58 | 7743.0 |
| 2025-06-25 06:00:00 | ES | Futures | 6190.83 | 6195.61 | 6187.81 | 6193.6 | 9445.0 |
| 2025-06-25 07:00:00 | ES | Futures | 6193.6 | 6202.92 | 6191.58 | 6202.16 | 13546.0 |
| 2025-06-25 08:00:00 | ES | Futures | 6201.91 | 6203.42 | 6198.64 | 6203.17 | 15815.0 |
| 2025-06-25 09:00:00 | ES | Futures | 6202.92 | 6206.44 | 6195.87 | 6203.17 | 109303.0 |
| 2025-06-25 10:00:00 | ES | Futures | 6203.17 | 6205.69 | 6194.35 | 6199.14 | 129905.0 |
| 2025-06-25 11:00:00 | ES | Futures | 6199.14 | 6199.64 | 6186.04 | 6190.83 | 101977.0 |
| 2025-06-25 12:00:00 | ES | Futures | 6190.58 | 6194.61 | 6186.04 | 6189.06 | 61708.0 |
| 2025-06-25 13:00:00 | ES | Futures | 6189.06 | 6193.35 | 6176.72 | 6184.53 | 92549.0 |
| 2025-06-25 14:00:00 | ES | Futures | 6184.53 | 6187.55 | 6182.26 | 6186.04 | 58007.0 |
| 2025-06-25 15:00:00 | ES | Futures | 6186.29 | 6195.87 | 6185.54 | 6193.6 | 171434.0 |
| 2025-06-25 16:00:00 | ES | Futures | 6193.6 | 6194.1 | 6189.57 | 6192.09 | 36895.0 |
| 2025-06-25 18:00:00 | ES | Futures | 6190.83 | 6196.62 | 6188.81 | 6192.59 | 4614.0 |
| 2025-06-25 19:00:00 | ES | Futures | 6192.84 | 6193.85 | 6187.3 | 6192.59 | 5465.0 |
| 2025-06-25 20:00:00 | ES | Futures | 6192.84 | 6195.87 | 6190.58 | 6194.86 | 3698.0 |
| 2025-06-25 21:00:00 | ES | Futures | 6194.86 | 6195.11 | 6190.83 | 6192.34 | 3013.0 |
| 2025-06-25 22:00:00 | ES | Futures | 6192.59 | 6196.87 | 6192.09 | 6195.11 | 2575.0 |
| 2025-06-25 23:00:00 | ES | Futures | 6195.36 | 6201.15 | 6195.36 | 6198.89 | 3328.0 |
| 2025-06-25 00:00:00 | NQ | Futures | 22601.4 | 22622.33 | 22601.4 | 22620.31 | 1037.0 |
| 2025-06-25 01:00:00 | NQ | Futures | 22621.07 | 22632.17 | 22615.27 | 22621.83 | 2179.0 |
| 2025-06-25 02:00:00 | NQ | Futures | 22622.08 | 22629.39 | 22614.77 | 22615.27 | 2655.0 |
| 2025-06-25 03:00:00 | NQ | Futures | 22615.02 | 22628.38 | 22601.15 | 22619.05 | 5153.0 |
| 2025-06-25 04:00:00 | NQ | Futures | 22618.8 | 22630.4 | 22602.16 | 22629.64 | 4817.0 |
| 2025-06-25 05:00:00 | NQ | Futures | 22630.15 | 22649.82 | 22617.29 | 22620.31 | 4947.0 |
| 2025-06-25 06:00:00 | NQ | Futures | 22621.07 | 22653.6 | 22608.71 | 22644.02 | 5533.0 |
| 2025-06-25 07:00:00 | NQ | Futures | 22644.27 | 22688.4 | 22639.23 | 22686.89 | 7683.0 |
| 2025-06-25 08:00:00 | NQ | Futures | 22686.13 | 22705.55 | 22676.3 | 22704.04 | 9251.0 |
| 2025-06-25 09:00:00 | NQ | Futures | 22704.04 | 22744.64 | 22681.59 | 22718.41 | 60615.0 |
| 2025-06-25 10:00:00 | NQ | Futures | 22718.92 | 22726.23 | 22659.4 | 22687.65 | 61648.0 |
| 2025-06-25 11:00:00 | NQ | Futures | 22687.9 | 22690.17 | 22624.35 | 22639.48 | 46714.0 |
| 2025-06-25 12:00:00 | NQ | Futures | 22639.48 | 22653.6 | 22605.18 | 22638.22 | 33613.0 |
| 2025-06-25 13:00:00 | NQ | Futures | 22638.22 | 22658.39 | 22583.5 | 22607.45 | 40064.0 |
| 2025-06-25 14:00:00 | NQ | Futures | 22608.21 | 22630.15 | 22597.11 | 22615.27 | 23392.0 |
| 2025-06-25 15:00:00 | NQ | Futures | 22615.77 | 22661.42 | 22614.01 | 22658.9 | 47527.0 |
| 2025-06-25 16:00:00 | NQ | Futures | 22658.9 | 22680.84 | 22646.54 | 22668.23 | 14771.0 |
| 2025-06-25 18:00:00 | NQ | Futures | 22656.88 | 22684.11 | 22645.78 | 22659.65 | 4049.0 |
| 2025-06-25 19:00:00 | NQ | Futures | 22659.65 | 22665.2 | 22633.17 | 22660.41 | 4274.0 |
| 2025-06-25 20:00:00 | NQ | Futures | 22660.41 | 22677.81 | 22652.34 | 22671.25 | 2956.0 |
| 2025-06-25 21:00:00 | NQ | Futures | 22672.26 | 22675.79 | 22656.63 | 22663.69 | 2661.0 |
| 2025-06-25 22:00:00 | NQ | Futures | 22663.94 | 22681.34 | 22662.68 | 22673.02 | 2140.0 |
| 2025-06-25 23:00:00 | NQ | Futures | 22674.03 | 22700.0 | 22674.03 | 22690.67 | 3196.0 |
| 2025-06-25 00:00:00 | YM | Futures | 44359.7 | 44386.3 | 44359.7 | 44386.3 | 182.0 |
| 2025-06-25 01:00:00 | YM | Futures | 44384.2 | 44395.5 | 44378.1 | 44391.4 | 341.0 |
| 2025-06-25 02:00:00 | YM | Futures | 44391.4 | 44405.7 | 44356.7 | 44358.7 | 793.0 |
| 2025-06-25 03:00:00 | YM | Futures | 44358.7 | 44394.5 | 44355.6 | 44369.9 | 975.0 |
> showing 50 of 2,041 rows — these rows as CSV