PREVIEW / futures_1hour / 2025-04-09
file: by_date/futures_1hour/2025/2025-04-09.parquet size: 76 KB rows: 2,148
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-09 00:00:00 | ES | Futures | 5006.62 | 5027.2 | 4963.94 | 4981.73 | 33060.0 |
| 2025-04-09 01:00:00 | ES | Futures | 4982.23 | 4996.21 | 4950.48 | 4994.17 | 23658.0 |
| 2025-04-09 02:00:00 | ES | Futures | 4994.43 | 5049.05 | 4993.41 | 5031.01 | 42314.0 |
| 2025-04-09 03:00:00 | ES | Futures | 5030.76 | 5139.23 | 5027.45 | 5115.1 | 75066.0 |
| 2025-04-09 04:00:00 | ES | Futures | 5115.35 | 5131.61 | 5051.33 | 5110.78 | 42279.0 |
| 2025-04-09 05:00:00 | ES | Futures | 5110.27 | 5123.23 | 5075.72 | 5086.39 | 29127.0 |
| 2025-04-09 06:00:00 | ES | Futures | 5086.39 | 5114.08 | 5048.03 | 5076.48 | 33790.0 |
| 2025-04-09 07:00:00 | ES | Futures | 5076.99 | 5079.53 | 4980.96 | 5006.11 | 92677.0 |
| 2025-04-09 08:00:00 | ES | Futures | 5005.86 | 5070.64 | 4988.58 | 5042.95 | 75837.0 |
| 2025-04-09 09:00:00 | ES | Futures | 5042.69 | 5152.44 | 5042.69 | 5129.83 | 240987.0 |
| 2025-04-09 10:00:00 | ES | Futures | 5129.83 | 5169.46 | 5060.48 | 5062.0 | 217395.0 |
| 2025-04-09 11:00:00 | ES | Futures | 5062.0 | 5129.07 | 5060.48 | 5090.2 | 152861.0 |
| 2025-04-09 12:00:00 | ES | Futures | 5089.95 | 5158.79 | 5077.75 | 5144.57 | 118010.0 |
| 2025-04-09 13:00:00 | ES | Futures | 5144.57 | 5508.1 | 5106.2 | 5491.58 | 576706.0 |
| 2025-04-09 14:00:00 | ES | Futures | 5491.84 | 5542.39 | 5447.13 | 5450.94 | 356660.0 |
| 2025-04-09 15:00:00 | ES | Futures | 5450.94 | 5609.2 | 5438.49 | 5578.21 | 451355.0 |
| 2025-04-09 16:00:00 | ES | Futures | 5578.21 | 5606.92 | 5568.56 | 5602.6 | 137427.0 |
| 2025-04-09 18:00:00 | ES | Futures | 5591.42 | 5608.95 | 5578.72 | 5608.7 | 21844.0 |
| 2025-04-09 19:00:00 | ES | Futures | 5608.44 | 5618.1 | 5598.03 | 5603.87 | 16167.0 |
| 2025-04-09 20:00:00 | ES | Futures | 5603.36 | 5607.17 | 5563.99 | 5585.32 | 26871.0 |
| 2025-04-09 21:00:00 | ES | Futures | 5585.32 | 5595.74 | 5552.55 | 5564.24 | 23738.0 |
| 2025-04-09 22:00:00 | ES | Futures | 5564.24 | 5571.61 | 5553.32 | 5553.82 | 13830.0 |
| 2025-04-09 23:00:00 | ES | Futures | 5553.57 | 5558.4 | 5532.48 | 5543.66 | 15969.0 |
| 2025-04-09 00:00:00 | NQ | Futures | 17245.34 | 17333.96 | 17061.99 | 17138.13 | 17148.0 |
| 2025-04-09 01:00:00 | NQ | Futures | 17134.82 | 17210.2 | 17046.46 | 17210.2 | 13620.0 |
| 2025-04-09 02:00:00 | NQ | Futures | 17210.2 | 17440.15 | 17202.81 | 17337.27 | 13428.0 |
| 2025-04-09 03:00:00 | NQ | Futures | 17337.02 | 17749.3 | 17327.59 | 17665.52 | 33424.0 |
| 2025-04-09 04:00:00 | NQ | Futures | 17666.28 | 17743.19 | 17445.24 | 17672.9 | 19251.0 |
| 2025-04-09 05:00:00 | NQ | Futures | 17671.88 | 17723.58 | 17544.56 | 17589.89 | 11672.0 |
| 2025-04-09 06:00:00 | NQ | Futures | 17594.22 | 17696.84 | 17448.55 | 17569.0 | 17378.0 |
| 2025-04-09 07:00:00 | NQ | Futures | 17566.46 | 17571.81 | 17181.42 | 17271.06 | 42691.0 |
| 2025-04-09 08:00:00 | NQ | Futures | 17275.14 | 17538.96 | 17214.78 | 17449.57 | 31467.0 |
| 2025-04-09 09:00:00 | NQ | Futures | 17447.03 | 17880.7 | 17439.9 | 17771.2 | 94847.0 |
| 2025-04-09 10:00:00 | NQ | Futures | 17770.94 | 17925.01 | 17539.47 | 17546.09 | 102900.0 |
| 2025-04-09 11:00:00 | NQ | Futures | 17545.07 | 17786.99 | 17526.22 | 17642.34 | 75046.0 |
| 2025-04-09 12:00:00 | NQ | Futures | 17642.6 | 17907.18 | 17603.13 | 17856.51 | 52351.0 |
| 2025-04-09 13:00:00 | NQ | Futures | 17857.78 | 19250.99 | 17744.72 | 19229.6 | 165959.0 |
| 2025-04-09 14:00:00 | NQ | Futures | 19228.83 | 19467.95 | 19092.34 | 19124.68 | 118886.0 |
| 2025-04-09 15:00:00 | NQ | Futures | 19126.21 | 19747.56 | 19067.64 | 19627.87 | 131949.0 |
| 2025-04-09 16:00:00 | NQ | Futures | 19630.16 | 19725.91 | 19587.13 | 19713.69 | 43000.0 |
| 2025-04-09 18:00:00 | NQ | Futures | 19625.33 | 19719.29 | 19600.37 | 19703.76 | 7849.0 |
| 2025-04-09 19:00:00 | NQ | Futures | 19705.8 | 19744.25 | 19647.74 | 19672.95 | 5334.0 |
| 2025-04-09 20:00:00 | NQ | Futures | 19671.67 | 19695.86 | 19500.04 | 19585.35 | 14245.0 |
| 2025-04-09 21:00:00 | NQ | Futures | 19584.84 | 19637.8 | 19469.48 | 19504.37 | 10536.0 |
| 2025-04-09 22:00:00 | NQ | Futures | 19505.38 | 19544.86 | 19458.27 | 19460.06 | 7431.0 |
| 2025-04-09 23:00:00 | NQ | Futures | 19459.8 | 19470.5 | 19322.29 | 19368.89 | 9940.0 |
| 2025-04-09 00:00:00 | YM | Futures | 38302.5 | 38414.7 | 38046.3 | 38156.4 | 3414.0 |
| 2025-04-09 01:00:00 | YM | Futures | 38159.5 | 38255.2 | 37957.7 | 38216.1 | 2525.0 |
| 2025-04-09 02:00:00 | YM | Futures | 38217.1 | 38559.8 | 38209.9 | 38459.0 | 3211.0 |
| 2025-04-09 03:00:00 | YM | Futures | 38451.7 | 39244.2 | 38441.5 | 39028.1 | 9772.0 |
> showing 50 of 2,148 rows — these rows as CSV