PREVIEW / futures_1hour / 2025-04-22
file: by_date/futures_1hour/2025/2025-04-22.parquet size: 71 KB rows: 2,134
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-22 00:00:00 | ES | Futures | 5287.84 | 5290.13 | 5285.05 | 5288.1 | 3575.0 |
| 2025-04-22 01:00:00 | ES | Futures | 5288.1 | 5295.21 | 5285.3 | 5291.15 | 4497.0 |
| 2025-04-22 02:00:00 | ES | Futures | 5290.89 | 5336.11 | 5287.59 | 5332.81 | 16762.0 |
| 2025-04-22 03:00:00 | ES | Futures | 5333.06 | 5339.41 | 5312.99 | 5315.53 | 19691.0 |
| 2025-04-22 04:00:00 | ES | Futures | 5315.53 | 5324.68 | 5308.93 | 5321.38 | 15428.0 |
| 2025-04-22 05:00:00 | ES | Futures | 5321.38 | 5323.66 | 5312.49 | 5317.82 | 8765.0 |
| 2025-04-22 06:00:00 | ES | Futures | 5317.82 | 5322.39 | 5313.25 | 5316.8 | 12425.0 |
| 2025-04-22 07:00:00 | ES | Futures | 5316.8 | 5318.58 | 5300.8 | 5304.61 | 16208.0 |
| 2025-04-22 08:00:00 | ES | Futures | 5304.36 | 5323.41 | 5302.32 | 5322.9 | 23637.0 |
| 2025-04-22 09:00:00 | ES | Futures | 5322.9 | 5352.62 | 5320.61 | 5349.07 | 147437.0 |
| 2025-04-22 10:00:00 | ES | Futures | 5349.07 | 5380.06 | 5347.29 | 5377.52 | 181167.0 |
| 2025-04-22 11:00:00 | ES | Futures | 5377.52 | 5397.08 | 5368.37 | 5393.27 | 174286.0 |
| 2025-04-22 12:00:00 | ES | Futures | 5393.27 | 5425.53 | 5393.27 | 5406.99 | 192245.0 |
| 2025-04-22 13:00:00 | ES | Futures | 5407.24 | 5418.67 | 5347.29 | 5348.05 | 225550.0 |
| 2025-04-22 14:00:00 | ES | Futures | 5348.05 | 5405.72 | 5347.29 | 5398.86 | 125322.0 |
| 2025-04-22 15:00:00 | ES | Futures | 5398.86 | 5406.99 | 5372.95 | 5400.13 | 225114.0 |
| 2025-04-22 16:00:00 | ES | Futures | 5400.38 | 5418.42 | 5397.33 | 5400.38 | 54192.0 |
| 2025-04-22 18:00:00 | ES | Futures | 5466.69 | 5504.79 | 5464.66 | 5504.03 | 45243.0 |
| 2025-04-22 19:00:00 | ES | Futures | 5504.29 | 5511.65 | 5491.33 | 5499.97 | 24034.0 |
| 2025-04-22 20:00:00 | ES | Futures | 5500.22 | 5502.25 | 5475.58 | 5484.47 | 15782.0 |
| 2025-04-22 21:00:00 | ES | Futures | 5484.22 | 5490.31 | 5464.91 | 5469.23 | 11811.0 |
| 2025-04-22 22:00:00 | ES | Futures | 5469.23 | 5485.74 | 5465.67 | 5479.9 | 7072.0 |
| 2025-04-22 23:00:00 | ES | Futures | 5479.64 | 5482.69 | 5474.05 | 5481.93 | 5093.0 |
| 2025-04-22 00:00:00 | NQ | Futures | 18315.65 | 18330.16 | 18306.73 | 18320.99 | 2713.0 |
| 2025-04-22 01:00:00 | NQ | Futures | 18319.47 | 18348.24 | 18306.22 | 18332.96 | 3726.0 |
| 2025-04-22 02:00:00 | NQ | Futures | 18332.2 | 18501.03 | 18319.72 | 18484.23 | 9278.0 |
| 2025-04-22 03:00:00 | NQ | Futures | 18485.25 | 18509.69 | 18412.92 | 18422.6 | 11459.0 |
| 2025-04-22 04:00:00 | NQ | Futures | 18422.35 | 18460.8 | 18391.28 | 18450.61 | 9367.0 |
| 2025-04-22 05:00:00 | NQ | Futures | 18451.12 | 18458.76 | 18413.43 | 18429.73 | 4865.0 |
| 2025-04-22 06:00:00 | NQ | Futures | 18428.97 | 18442.46 | 18409.1 | 18431.51 | 6516.0 |
| 2025-04-22 07:00:00 | NQ | Futures | 18432.79 | 18437.12 | 18379.56 | 18391.02 | 8900.0 |
| 2025-04-22 08:00:00 | NQ | Futures | 18390.26 | 18478.12 | 18382.11 | 18475.82 | 10935.0 |
| 2025-04-22 09:00:00 | NQ | Futures | 18475.57 | 18595.0 | 18437.37 | 18593.47 | 65382.0 |
| 2025-04-22 10:00:00 | NQ | Futures | 18593.22 | 18696.35 | 18580.23 | 18681.84 | 78463.0 |
| 2025-04-22 11:00:00 | NQ | Futures | 18681.58 | 18738.88 | 18627.6 | 18720.54 | 58460.0 |
| 2025-04-22 12:00:00 | NQ | Futures | 18720.8 | 18858.57 | 18720.8 | 18793.88 | 68684.0 |
| 2025-04-22 13:00:00 | NQ | Futures | 18793.12 | 18837.18 | 18550.18 | 18562.41 | 93367.0 |
| 2025-04-22 14:00:00 | NQ | Futures | 18562.66 | 18742.19 | 18557.06 | 18724.87 | 47001.0 |
| 2025-04-22 15:00:00 | NQ | Futures | 18725.13 | 18748.81 | 18579.98 | 18722.07 | 73913.0 |
| 2025-04-22 16:00:00 | NQ | Futures | 18721.82 | 18780.64 | 18686.42 | 18700.68 | 16653.0 |
| 2025-04-22 18:00:00 | NQ | Futures | 18993.02 | 19121.11 | 18990.99 | 19114.75 | 19313.0 |
| 2025-04-22 19:00:00 | NQ | Futures | 19113.47 | 19152.69 | 19075.53 | 19109.91 | 11630.0 |
| 2025-04-22 20:00:00 | NQ | Futures | 19110.93 | 19120.6 | 19020.78 | 19049.81 | 8130.0 |
| 2025-04-22 21:00:00 | NQ | Futures | 19048.79 | 19073.49 | 18970.36 | 18987.17 | 7423.0 |
| 2025-04-22 22:00:00 | NQ | Futures | 18988.95 | 19060.76 | 18973.92 | 19031.48 | 5348.0 |
| 2025-04-22 23:00:00 | NQ | Futures | 19032.49 | 19054.65 | 19008.81 | 19050.83 | 4344.0 |
| 2025-04-22 00:00:00 | YM | Futures | 39563.2 | 39579.7 | 39548.8 | 39566.3 | 514.0 |
| 2025-04-22 01:00:00 | YM | Futures | 39562.2 | 39603.4 | 39549.9 | 39583.8 | 608.0 |
| 2025-04-22 02:00:00 | YM | Futures | 39578.7 | 39875.1 | 39560.2 | 39868.9 | 2256.0 |
| 2025-04-22 03:00:00 | YM | Futures | 39866.9 | 39902.9 | 39739.2 | 39744.4 | 2459.0 |
> showing 50 of 2,134 rows — these rows as CSV