PREVIEW / futures_1hour / 2025-04-07
file: by_date/futures_1hour/2025/2025-04-07.parquet size: 76 KB rows: 2,166
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-07 00:00:00 | ES | Futures | 5015.26 | 5031.26 | 4982.49 | 5006.37 | 27843.0 |
| 2025-04-07 01:00:00 | ES | Futures | 5007.13 | 5049.05 | 4991.63 | 5006.37 | 33414.0 |
| 2025-04-07 02:00:00 | ES | Futures | 5006.37 | 5027.2 | 4933.46 | 4941.59 | 56122.0 |
| 2025-04-07 03:00:00 | ES | Futures | 4941.59 | 4970.8 | 4920.76 | 4958.86 | 80849.0 |
| 2025-04-07 04:00:00 | ES | Futures | 4959.37 | 5036.6 | 4955.81 | 5006.11 | 86020.0 |
| 2025-04-07 05:00:00 | ES | Futures | 5005.86 | 5038.12 | 4974.1 | 5016.02 | 55973.0 |
| 2025-04-07 06:00:00 | ES | Futures | 5016.27 | 5121.45 | 5005.86 | 5078.51 | 112058.0 |
| 2025-04-07 07:00:00 | ES | Futures | 5078.01 | 5118.91 | 5051.33 | 5066.32 | 81224.0 |
| 2025-04-07 08:00:00 | ES | Futures | 5066.32 | 5109.25 | 5035.07 | 5092.74 | 131129.0 |
| 2025-04-07 09:00:00 | ES | Futures | 5093.5 | 5096.3 | 4945.65 | 5088.42 | 384302.0 |
| 2025-04-07 10:00:00 | ES | Futures | 5088.68 | 5371.93 | 5064.29 | 5193.34 | 748137.0 |
| 2025-04-07 11:00:00 | ES | Futures | 5193.34 | 5233.23 | 5055.4 | 5127.04 | 312413.0 |
| 2025-04-07 12:00:00 | ES | Futures | 5126.78 | 5150.66 | 5077.5 | 5088.17 | 176846.0 |
| 2025-04-07 13:00:00 | ES | Futures | 5087.91 | 5228.91 | 5087.15 | 5226.11 | 245997.0 |
| 2025-04-07 14:00:00 | ES | Futures | 5226.37 | 5241.35 | 5157.52 | 5166.41 | 187766.0 |
| 2025-04-07 15:00:00 | ES | Futures | 5166.41 | 5202.49 | 5134.4 | 5181.15 | 352000.0 |
| 2025-04-07 16:00:00 | ES | Futures | 5181.4 | 5228.91 | 5173.27 | 5200.71 | 92157.0 |
| 2025-04-07 18:00:00 | ES | Futures | 5209.35 | 5227.13 | 5197.66 | 5226.87 | 13551.0 |
| 2025-04-07 19:00:00 | ES | Futures | 5226.87 | 5240.08 | 5222.05 | 5231.45 | 17070.0 |
| 2025-04-07 20:00:00 | ES | Futures | 5231.19 | 5257.61 | 5219.76 | 5223.57 | 26180.0 |
| 2025-04-07 21:00:00 | ES | Futures | 5223.57 | 5270.82 | 5208.84 | 5269.04 | 34564.0 |
| 2025-04-07 22:00:00 | ES | Futures | 5268.28 | 5270.82 | 5255.83 | 5262.19 | 15871.0 |
| 2025-04-07 23:00:00 | ES | Futures | 5262.19 | 5266.5 | 5244.91 | 5254.31 | 12793.0 |
| 2025-04-07 00:00:00 | NQ | Futures | 17122.09 | 17174.8 | 16978.72 | 17046.46 | 11692.0 |
| 2025-04-07 01:00:00 | NQ | Futures | 17050.79 | 17228.53 | 17014.63 | 17073.45 | 14752.0 |
| 2025-04-07 02:00:00 | NQ | Futures | 17063.26 | 17130.49 | 16814.47 | 16848.85 | 16893.0 |
| 2025-04-07 03:00:00 | NQ | Futures | 16848.34 | 17007.5 | 16786.71 | 16993.49 | 25222.0 |
| 2025-04-07 04:00:00 | NQ | Futures | 16993.49 | 17274.12 | 16978.72 | 17156.21 | 26713.0 |
| 2025-04-07 05:00:00 | NQ | Futures | 17158.0 | 17275.64 | 17053.84 | 17202.56 | 16793.0 |
| 2025-04-07 06:00:00 | NQ | Futures | 17204.09 | 17599.56 | 17168.95 | 17439.9 | 34359.0 |
| 2025-04-07 07:00:00 | NQ | Futures | 17441.68 | 17552.96 | 17318.17 | 17380.56 | 24148.0 |
| 2025-04-07 08:00:00 | NQ | Futures | 17379.29 | 17551.69 | 17276.41 | 17487.52 | 47929.0 |
| 2025-04-07 09:00:00 | NQ | Futures | 17487.52 | 17618.15 | 16983.81 | 17594.98 | 146736.0 |
| 2025-04-07 10:00:00 | NQ | Futures | 17594.47 | 18703.23 | 17482.42 | 17987.14 | 247710.0 |
| 2025-04-07 11:00:00 | NQ | Futures | 17988.16 | 18130.26 | 17468.93 | 17712.88 | 109798.0 |
| 2025-04-07 12:00:00 | NQ | Futures | 17712.12 | 17823.15 | 17533.1 | 17574.35 | 49145.0 |
| 2025-04-07 13:00:00 | NQ | Futures | 17573.84 | 18123.13 | 17569.0 | 18112.43 | 64695.0 |
| 2025-04-07 14:00:00 | NQ | Futures | 18115.74 | 18155.72 | 17823.66 | 17857.53 | 53841.0 |
| 2025-04-07 15:00:00 | NQ | Futures | 17858.55 | 17989.69 | 17728.93 | 17885.54 | 77834.0 |
| 2025-04-07 16:00:00 | NQ | Futures | 17887.83 | 18087.99 | 17868.73 | 17956.84 | 26806.0 |
| 2025-04-07 18:00:00 | NQ | Futures | 17993.77 | 18084.17 | 17972.88 | 18078.57 | 5614.0 |
| 2025-04-07 19:00:00 | NQ | Futures | 18080.6 | 18114.98 | 18055.65 | 18094.35 | 6364.0 |
| 2025-04-07 20:00:00 | NQ | Futures | 18094.35 | 18187.81 | 18033.24 | 18043.42 | 9895.0 |
| 2025-04-07 21:00:00 | NQ | Futures | 18044.44 | 18218.37 | 17991.22 | 18200.03 | 12325.0 |
| 2025-04-07 22:00:00 | NQ | Futures | 18200.29 | 18208.69 | 18139.43 | 18149.1 | 5676.0 |
| 2025-04-07 23:00:00 | NQ | Futures | 18149.61 | 18167.69 | 18070.93 | 18101.99 | 5088.0 |
| 2025-04-07 00:00:00 | YM | Futures | 38581.4 | 38686.4 | 38362.2 | 38528.9 | 3131.0 |
| 2025-04-07 01:00:00 | YM | Futures | 38536.1 | 38802.7 | 38428.1 | 38521.7 | 3030.0 |
| 2025-04-07 02:00:00 | YM | Futures | 38511.4 | 38686.4 | 38003.0 | 38033.9 | 5190.0 |
| 2025-04-07 03:00:00 | YM | Futures | 38034.9 | 38243.9 | 37897.0 | 38064.8 | 7767.0 |
> showing 50 of 2,166 rows — these rows as CSV