PREVIEW / futures_1hour / 2025-06-24
file: by_date/futures_1hour/2025/2025-06-24.parquet size: 66 KB rows: 2,059
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-24 00:00:00 | ES | Futures | 6157.58 | 6158.59 | 6151.79 | 6157.33 | 4482.0 |
| 2025-06-24 01:00:00 | ES | Futures | 6157.33 | 6170.43 | 6157.08 | 6168.41 | 7462.0 |
| 2025-06-24 02:00:00 | ES | Futures | 6168.41 | 6185.54 | 6168.41 | 6183.52 | 18215.0 |
| 2025-06-24 03:00:00 | ES | Futures | 6183.52 | 6189.82 | 6160.35 | 6171.69 | 34965.0 |
| 2025-06-24 04:00:00 | ES | Futures | 6171.94 | 6177.48 | 6165.64 | 6171.43 | 16632.0 |
| 2025-06-24 05:00:00 | ES | Futures | 6171.43 | 6182.01 | 6170.93 | 6173.45 | 9531.0 |
| 2025-06-24 06:00:00 | ES | Futures | 6173.45 | 6175.97 | 6166.65 | 6169.17 | 11070.0 |
| 2025-06-24 07:00:00 | ES | Futures | 6168.91 | 6174.2 | 6161.36 | 6170.68 | 18874.0 |
| 2025-06-24 08:00:00 | ES | Futures | 6170.68 | 6172.94 | 6159.09 | 6165.14 | 22371.0 |
| 2025-06-24 09:00:00 | ES | Futures | 6165.14 | 6176.22 | 6159.34 | 6162.37 | 120137.0 |
| 2025-06-24 10:00:00 | ES | Futures | 6162.37 | 6175.72 | 6154.81 | 6171.69 | 131135.0 |
| 2025-06-24 11:00:00 | ES | Futures | 6171.43 | 6184.28 | 6171.43 | 6180.25 | 101232.0 |
| 2025-06-24 12:00:00 | ES | Futures | 6180.25 | 6194.86 | 6178.99 | 6189.32 | 75745.0 |
| 2025-06-24 13:00:00 | ES | Futures | 6189.32 | 6196.62 | 6185.79 | 6194.61 | 75920.0 |
| 2025-06-24 14:00:00 | ES | Futures | 6194.86 | 6197.63 | 6191.33 | 6195.87 | 55241.0 |
| 2025-06-24 15:00:00 | ES | Futures | 6195.87 | 6201.41 | 6189.82 | 6189.82 | 186006.0 |
| 2025-06-24 16:00:00 | ES | Futures | 6189.82 | 6192.34 | 6188.31 | 6189.57 | 42685.0 |
| 2025-06-24 18:00:00 | ES | Futures | 6190.83 | 6190.83 | 6184.28 | 6187.05 | 5126.0 |
| 2025-06-24 19:00:00 | ES | Futures | 6187.05 | 6193.6 | 6184.28 | 6192.09 | 3904.0 |
| 2025-06-24 20:00:00 | ES | Futures | 6192.34 | 6194.86 | 6190.07 | 6193.85 | 4576.0 |
| 2025-06-24 21:00:00 | ES | Futures | 6193.6 | 6193.6 | 6186.55 | 6187.81 | 4122.0 |
| 2025-06-24 22:00:00 | ES | Futures | 6188.06 | 6189.32 | 6186.55 | 6188.56 | 2511.0 |
| 2025-06-24 23:00:00 | ES | Futures | 6188.56 | 6192.59 | 6188.56 | 6189.32 | 2583.0 |
| 2025-06-24 00:00:00 | NQ | Futures | 22439.25 | 22443.03 | 22413.78 | 22436.73 | 2758.0 |
| 2025-06-24 01:00:00 | NQ | Futures | 22437.23 | 22497.25 | 22435.47 | 22488.68 | 5660.0 |
| 2025-06-24 02:00:00 | NQ | Futures | 22488.68 | 22565.84 | 22488.68 | 22553.23 | 10801.0 |
| 2025-06-24 03:00:00 | NQ | Futures | 22553.23 | 22579.46 | 22455.89 | 22500.28 | 15224.0 |
| 2025-06-24 04:00:00 | NQ | Futures | 22501.03 | 22528.02 | 22483.63 | 22498.01 | 8762.0 |
| 2025-06-24 05:00:00 | NQ | Futures | 22497.76 | 22546.93 | 22497.76 | 22508.85 | 6042.0 |
| 2025-06-24 06:00:00 | NQ | Futures | 22508.6 | 22516.67 | 22474.05 | 22479.09 | 7235.0 |
| 2025-06-24 07:00:00 | NQ | Futures | 22479.09 | 22505.32 | 22445.55 | 22500.78 | 11207.0 |
| 2025-06-24 08:00:00 | NQ | Futures | 22500.03 | 22508.6 | 22452.36 | 22479.85 | 10800.0 |
| 2025-06-24 09:00:00 | NQ | Futures | 22480.36 | 22528.02 | 22453.88 | 22485.15 | 55952.0 |
| 2025-06-24 10:00:00 | NQ | Futures | 22486.16 | 22534.83 | 22459.93 | 22509.1 | 57082.0 |
| 2025-06-24 11:00:00 | NQ | Futures | 22509.86 | 22582.99 | 22508.09 | 22557.02 | 46932.0 |
| 2025-06-24 12:00:00 | NQ | Futures | 22557.27 | 22613.0 | 22551.97 | 22595.1 | 36655.0 |
| 2025-06-24 13:00:00 | NQ | Futures | 22595.1 | 22621.32 | 22574.67 | 22612.75 | 31159.0 |
| 2025-06-24 14:00:00 | NQ | Futures | 22612.75 | 22627.37 | 22603.17 | 22621.32 | 24648.0 |
| 2025-06-24 15:00:00 | NQ | Futures | 22620.82 | 22643.77 | 22600.39 | 22600.9 | 53029.0 |
| 2025-06-24 16:00:00 | NQ | Futures | 22600.39 | 22614.26 | 22590.3 | 22602.91 | 14301.0 |
| 2025-06-24 18:00:00 | NQ | Futures | 22607.2 | 22607.2 | 22579.46 | 22591.31 | 3650.0 |
| 2025-06-24 19:00:00 | NQ | Futures | 22592.57 | 22625.61 | 22582.49 | 22619.81 | 3504.0 |
| 2025-06-24 20:00:00 | NQ | Futures | 22620.57 | 22630.15 | 22605.18 | 22620.06 | 4253.0 |
| 2025-06-24 21:00:00 | NQ | Futures | 22620.31 | 22620.31 | 22588.04 | 22594.84 | 3310.0 |
| 2025-06-24 22:00:00 | NQ | Futures | 22595.35 | 22602.16 | 22589.04 | 22600.14 | 1803.0 |
| 2025-06-24 23:00:00 | NQ | Futures | 22600.64 | 22618.04 | 22600.64 | 22601.9 | 1992.0 |
| 2025-06-24 00:00:00 | YM | Futures | 44049.2 | 44055.3 | 44012.4 | 44047.1 | 474.0 |
| 2025-06-24 01:00:00 | YM | Futures | 44045.1 | 44143.1 | 44042.0 | 44126.8 | 1170.0 |
| 2025-06-24 02:00:00 | YM | Futures | 44128.8 | 44243.3 | 44126.8 | 44229.0 | 2303.0 |
| 2025-06-24 03:00:00 | YM | Futures | 44226.9 | 44271.9 | 44068.6 | 44163.6 | 3700.0 |
> showing 50 of 2,059 rows — these rows as CSV