PREVIEW / futures_1hour / 2025-04-23
file: by_date/futures_1hour/2025/2025-04-23.parquet size: 70 KB rows: 2,120
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-04-23 00:00:00 | ES | Futures | 5481.68 | 5489.04 | 5481.42 | 5485.74 | 4806.0 |
| 2025-04-23 01:00:00 | ES | Futures | 5485.74 | 5493.62 | 5475.07 | 5489.04 | 7529.0 |
| 2025-04-23 02:00:00 | ES | Futures | 5489.3 | 5496.66 | 5485.99 | 5487.27 | 11482.0 |
| 2025-04-23 03:00:00 | ES | Futures | 5487.01 | 5502.51 | 5479.9 | 5501.49 | 18999.0 |
| 2025-04-23 04:00:00 | ES | Futures | 5501.49 | 5522.07 | 5499.71 | 5512.67 | 22520.0 |
| 2025-04-23 05:00:00 | ES | Futures | 5512.92 | 5519.02 | 5505.81 | 5515.21 | 15273.0 |
| 2025-04-23 06:00:00 | ES | Futures | 5515.21 | 5539.34 | 5512.92 | 5535.53 | 19511.0 |
| 2025-04-23 07:00:00 | ES | Futures | 5535.28 | 5541.88 | 5519.27 | 5519.78 | 26905.0 |
| 2025-04-23 08:00:00 | ES | Futures | 5520.04 | 5544.93 | 5518.26 | 5543.41 | 37419.0 |
| 2025-04-23 09:00:00 | ES | Futures | 5543.66 | 5585.58 | 5523.85 | 5570.59 | 265809.0 |
| 2025-04-23 10:00:00 | ES | Futures | 5570.84 | 5588.63 | 5541.63 | 5561.19 | 255056.0 |
| 2025-04-23 11:00:00 | ES | Futures | 5560.94 | 5571.61 | 5488.79 | 5508.1 | 249920.0 |
| 2025-04-23 12:00:00 | ES | Futures | 5508.1 | 5520.04 | 5472.02 | 5515.72 | 159965.0 |
| 2025-04-23 13:00:00 | ES | Futures | 5515.46 | 5529.69 | 5494.89 | 5517.5 | 123390.0 |
| 2025-04-23 14:00:00 | ES | Futures | 5517.5 | 5522.83 | 5490.82 | 5496.66 | 108462.0 |
| 2025-04-23 15:00:00 | ES | Futures | 5496.66 | 5504.79 | 5470.75 | 5485.49 | 240119.0 |
| 2025-04-23 16:00:00 | ES | Futures | 5485.74 | 5522.83 | 5483.71 | 5500.48 | 72642.0 |
| 2025-04-23 18:00:00 | ES | Futures | 5496.41 | 5500.98 | 5475.83 | 5493.62 | 9983.0 |
| 2025-04-23 19:00:00 | ES | Futures | 5493.62 | 5503.78 | 5491.33 | 5499.46 | 5818.0 |
| 2025-04-23 20:00:00 | ES | Futures | 5499.2 | 5508.6 | 5495.65 | 5498.95 | 6679.0 |
| 2025-04-23 21:00:00 | ES | Futures | 5498.95 | 5501.24 | 5484.98 | 5485.23 | 7415.0 |
| 2025-04-23 22:00:00 | ES | Futures | 5484.72 | 5491.58 | 5478.12 | 5479.14 | 6080.0 |
| 2025-04-23 23:00:00 | ES | Futures | 5478.88 | 5481.93 | 5475.07 | 5479.9 | 3722.0 |
| 2025-04-23 00:00:00 | NQ | Futures | 19050.83 | 19084.95 | 19048.03 | 19072.73 | 4021.0 |
| 2025-04-23 01:00:00 | NQ | Futures | 19072.73 | 19100.49 | 19029.44 | 19088.77 | 5850.0 |
| 2025-04-23 02:00:00 | NQ | Futures | 19088.52 | 19119.84 | 19079.1 | 19083.93 | 7460.0 |
| 2025-04-23 03:00:00 | NQ | Futures | 19083.68 | 19140.21 | 19061.78 | 19132.32 | 10966.0 |
| 2025-04-23 04:00:00 | NQ | Futures | 19132.32 | 19209.99 | 19124.42 | 19181.21 | 12335.0 |
| 2025-04-23 05:00:00 | NQ | Futures | 19182.48 | 19202.35 | 19164.15 | 19195.47 | 7776.0 |
| 2025-04-23 06:00:00 | NQ | Futures | 19196.24 | 19281.04 | 19189.62 | 19271.87 | 10144.0 |
| 2025-04-23 07:00:00 | NQ | Futures | 19271.1 | 19297.59 | 19210.75 | 19210.75 | 14297.0 |
| 2025-04-23 08:00:00 | NQ | Futures | 19211.26 | 19325.09 | 19208.71 | 19319.23 | 15481.0 |
| 2025-04-23 09:00:00 | NQ | Futures | 19319.74 | 19478.14 | 19240.04 | 19429.75 | 103533.0 |
| 2025-04-23 10:00:00 | NQ | Futures | 19429.24 | 19522.19 | 19327.13 | 19416.51 | 99167.0 |
| 2025-04-23 11:00:00 | NQ | Futures | 19417.02 | 19460.31 | 19147.09 | 19228.07 | 98142.0 |
| 2025-04-23 12:00:00 | NQ | Futures | 19227.81 | 19286.38 | 19095.9 | 19268.81 | 69062.0 |
| 2025-04-23 13:00:00 | NQ | Futures | 19267.79 | 19319.23 | 19182.48 | 19277.98 | 52280.0 |
| 2025-04-23 14:00:00 | NQ | Futures | 19279.76 | 19311.85 | 19197.51 | 19220.68 | 48528.0 |
| 2025-04-23 15:00:00 | NQ | Futures | 19220.43 | 19245.89 | 19078.33 | 19137.92 | 81813.0 |
| 2025-04-23 16:00:00 | NQ | Futures | 19137.67 | 19279.25 | 19120.35 | 19200.82 | 26871.0 |
| 2025-04-23 18:00:00 | NQ | Futures | 19176.88 | 19192.93 | 19089.28 | 19169.5 | 6122.0 |
| 2025-04-23 19:00:00 | NQ | Futures | 19165.42 | 19208.46 | 19156.26 | 19190.12 | 4271.0 |
| 2025-04-23 20:00:00 | NQ | Futures | 19190.63 | 19227.05 | 19176.63 | 19191.91 | 5914.0 |
| 2025-04-23 21:00:00 | NQ | Futures | 19192.42 | 19200.82 | 19119.84 | 19120.6 | 6600.0 |
| 2025-04-23 22:00:00 | NQ | Futures | 19120.35 | 19157.02 | 19095.9 | 19096.92 | 5600.0 |
| 2025-04-23 23:00:00 | NQ | Futures | 19095.9 | 19112.71 | 19083.93 | 19106.6 | 3508.0 |
| 2025-04-23 00:00:00 | YM | Futures | 40960.9 | 41005.1 | 40957.8 | 40977.3 | 599.0 |
| 2025-04-23 01:00:00 | YM | Futures | 40976.3 | 41018.5 | 40906.3 | 40997.9 | 1046.0 |
| 2025-04-23 02:00:00 | YM | Futures | 41001.0 | 41043.2 | 40975.3 | 40987.6 | 1239.0 |
| 2025-04-23 03:00:00 | YM | Futures | 40985.6 | 41080.2 | 40930.0 | 41075.1 | 2050.0 |
> showing 50 of 2,120 rows — these rows as CSV