PREVIEW / futures_1hour / 2025-07-24
file: by_date/futures_1hour/2025/2025-07-24.parquet size: 65 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-07-24 00:00:00 | ES | Futures | 6448.5 | 6450.26 | 6446.98 | 6449.0 | 2638.0 |
| 2025-07-24 01:00:00 | ES | Futures | 6449.0 | 6450.01 | 6446.98 | 6447.24 | 2821.0 |
| 2025-07-24 02:00:00 | ES | Futures | 6447.24 | 6451.52 | 6443.96 | 6444.47 | 6366.0 |
| 2025-07-24 03:00:00 | ES | Futures | 6444.21 | 6445.72 | 6441.44 | 6443.71 | 9528.0 |
| 2025-07-24 04:00:00 | ES | Futures | 6443.71 | 6450.01 | 6441.95 | 6448.75 | 9183.0 |
| 2025-07-24 05:00:00 | ES | Futures | 6449.0 | 6452.02 | 6447.49 | 6451.01 | 7260.0 |
| 2025-07-24 06:00:00 | ES | Futures | 6451.27 | 6452.53 | 6443.71 | 6446.48 | 9693.0 |
| 2025-07-24 07:00:00 | ES | Futures | 6446.48 | 6454.79 | 6445.72 | 6451.77 | 11150.0 |
| 2025-07-24 08:00:00 | ES | Futures | 6451.77 | 6452.53 | 6439.43 | 6445.98 | 27703.0 |
| 2025-07-24 09:00:00 | ES | Futures | 6446.23 | 6458.32 | 6442.45 | 6454.79 | 127778.0 |
| 2025-07-24 10:00:00 | ES | Futures | 6455.04 | 6460.59 | 6444.47 | 6459.58 | 140222.0 |
| 2025-07-24 11:00:00 | ES | Futures | 6459.83 | 6463.61 | 6457.31 | 6459.83 | 99991.0 |
| 2025-07-24 12:00:00 | ES | Futures | 6459.83 | 6460.33 | 6446.98 | 6453.53 | 108732.0 |
| 2025-07-24 13:00:00 | ES | Futures | 6453.28 | 6464.87 | 6452.02 | 6457.06 | 79786.0 |
| 2025-07-24 14:00:00 | ES | Futures | 6457.31 | 6466.38 | 6451.52 | 6457.06 | 94136.0 |
| 2025-07-24 15:00:00 | ES | Futures | 6456.81 | 6462.6 | 6447.74 | 6450.01 | 206596.0 |
| 2025-07-24 16:00:00 | ES | Futures | 6450.01 | 6455.55 | 6447.24 | 6454.54 | 53024.0 |
| 2025-07-24 18:00:00 | ES | Futures | 6454.79 | 6461.34 | 6452.78 | 6458.07 | 5427.0 |
| 2025-07-24 19:00:00 | ES | Futures | 6457.81 | 6460.08 | 6455.55 | 6459.33 | 3200.0 |
| 2025-07-24 20:00:00 | ES | Futures | 6459.33 | 6462.85 | 6458.32 | 6462.1 | 5168.0 |
| 2025-07-24 21:00:00 | ES | Futures | 6462.1 | 6466.13 | 6461.09 | 6464.87 | 5052.0 |
| 2025-07-24 22:00:00 | ES | Futures | 6464.87 | 6466.88 | 6464.11 | 6464.62 | 3732.0 |
| 2025-07-24 23:00:00 | ES | Futures | 6464.87 | 6469.4 | 6464.62 | 6466.63 | 4016.0 |
| 2025-07-24 00:00:00 | NQ | Futures | 23582.62 | 23588.42 | 23575.81 | 23583.63 | 2002.0 |
| 2025-07-24 01:00:00 | NQ | Futures | 23583.63 | 23588.42 | 23576.07 | 23577.33 | 1901.0 |
| 2025-07-24 02:00:00 | NQ | Futures | 23577.07 | 23595.23 | 23557.15 | 23563.46 | 4590.0 |
| 2025-07-24 03:00:00 | NQ | Futures | 23562.45 | 23573.8 | 23555.89 | 23573.04 | 4268.0 |
| 2025-07-24 04:00:00 | NQ | Futures | 23572.79 | 23594.98 | 23550.09 | 23594.48 | 5924.0 |
| 2025-07-24 05:00:00 | NQ | Futures | 23594.73 | 23600.78 | 23585.65 | 23593.72 | 3304.0 |
| 2025-07-24 06:00:00 | NQ | Futures | 23594.22 | 23598.51 | 23566.99 | 23576.82 | 4734.0 |
| 2025-07-24 07:00:00 | NQ | Futures | 23577.07 | 23606.58 | 23570.01 | 23590.44 | 5307.0 |
| 2025-07-24 08:00:00 | NQ | Futures | 23589.68 | 23595.99 | 23530.42 | 23563.21 | 13818.0 |
| 2025-07-24 09:00:00 | NQ | Futures | 23563.96 | 23604.81 | 23537.48 | 23566.23 | 67346.0 |
| 2025-07-24 10:00:00 | NQ | Futures | 23566.99 | 23584.64 | 23501.17 | 23576.07 | 68986.0 |
| 2025-07-24 11:00:00 | NQ | Futures | 23576.07 | 23604.31 | 23572.28 | 23591.7 | 46101.0 |
| 2025-07-24 12:00:00 | NQ | Futures | 23591.7 | 23592.46 | 23543.28 | 23574.05 | 42198.0 |
| 2025-07-24 13:00:00 | NQ | Futures | 23573.8 | 23627.01 | 23569.26 | 23587.92 | 36837.0 |
| 2025-07-24 14:00:00 | NQ | Futures | 23587.41 | 23626.0 | 23580.1 | 23604.56 | 38377.0 |
| 2025-07-24 15:00:00 | NQ | Futures | 23603.81 | 23628.52 | 23575.81 | 23580.35 | 52009.0 |
| 2025-07-24 16:00:00 | NQ | Futures | 23580.35 | 23604.81 | 23569.76 | 23598.76 | 14836.0 |
| 2025-07-24 18:00:00 | NQ | Futures | 23595.23 | 23624.48 | 23588.67 | 23605.07 | 3190.0 |
| 2025-07-24 19:00:00 | NQ | Futures | 23604.56 | 23613.64 | 23593.72 | 23610.11 | 2496.0 |
| 2025-07-24 20:00:00 | NQ | Futures | 23610.36 | 23627.26 | 23604.31 | 23618.18 | 4037.0 |
| 2025-07-24 21:00:00 | NQ | Futures | 23618.68 | 23638.86 | 23612.88 | 23630.79 | 3302.0 |
| 2025-07-24 22:00:00 | NQ | Futures | 23631.55 | 23640.62 | 23623.98 | 23625.49 | 2403.0 |
| 2025-07-24 23:00:00 | NQ | Futures | 23626.0 | 23645.92 | 23624.74 | 23632.3 | 2450.0 |
| 2025-07-24 00:00:00 | YM | Futures | 46054.5 | 46067.8 | 46043.3 | 46065.7 | 473.0 |
| 2025-07-24 01:00:00 | YM | Futures | 46065.7 | 46074.9 | 46050.4 | 46059.6 | 344.0 |
| 2025-07-24 02:00:00 | YM | Futures | 46058.6 | 46078.0 | 46027.9 | 46031.0 | 944.0 |
| 2025-07-24 03:00:00 | YM | Futures | 46031.0 | 46046.3 | 46008.5 | 46020.8 | 1162.0 |
> showing 50 of 2,059 rows — these rows as CSV