PREVIEW / futures_1hour / 2025-06-05
file: by_date/futures_1hour/2025/2025-06-05.parquet size: 65 KB rows: 2,021
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-06-05 00:00:00 | ES | Futures | 6073.34 | 6075.37 | 6072.57 | 6074.35 | 2546.0 |
| 2025-06-05 01:00:00 | ES | Futures | 6074.35 | 6074.61 | 6069.52 | 6071.81 | 3927.0 |
| 2025-06-05 02:00:00 | ES | Futures | 6071.56 | 6072.83 | 6068.76 | 6071.3 | 4051.0 |
| 2025-06-05 03:00:00 | ES | Futures | 6071.3 | 6090.86 | 6071.3 | 6087.56 | 16010.0 |
| 2025-06-05 04:00:00 | ES | Futures | 6087.56 | 6093.4 | 6080.7 | 6083.75 | 11596.0 |
| 2025-06-05 05:00:00 | ES | Futures | 6084.01 | 6084.77 | 6078.67 | 6080.7 | 8961.0 |
| 2025-06-05 06:00:00 | ES | Futures | 6080.45 | 6086.29 | 6075.37 | 6079.94 | 8723.0 |
| 2025-06-05 07:00:00 | ES | Futures | 6079.69 | 6081.46 | 6073.84 | 6078.67 | 10503.0 |
| 2025-06-05 08:00:00 | ES | Futures | 6078.67 | 6113.73 | 6067.49 | 6088.32 | 63604.0 |
| 2025-06-05 09:00:00 | ES | Futures | 6088.58 | 6094.67 | 6053.77 | 6057.58 | 155755.0 |
| 2025-06-05 10:00:00 | ES | Futures | 6057.84 | 6091.63 | 6054.28 | 6088.32 | 223529.0 |
| 2025-06-05 11:00:00 | ES | Futures | 6088.32 | 6106.11 | 6086.04 | 6103.57 | 119945.0 |
| 2025-06-05 12:00:00 | ES | Futures | 6103.31 | 6105.34 | 6057.08 | 6062.16 | 184634.0 |
| 2025-06-05 13:00:00 | ES | Futures | 6062.41 | 6084.77 | 6057.58 | 6073.08 | 132458.0 |
| 2025-06-05 14:00:00 | ES | Futures | 6073.34 | 6075.88 | 6044.88 | 6067.49 | 182128.0 |
| 2025-06-05 15:00:00 | ES | Futures | 6067.24 | 6070.03 | 6024.56 | 6043.87 | 311645.0 |
| 2025-06-05 16:00:00 | ES | Futures | 6044.12 | 6051.74 | 6034.98 | 6035.74 | 46769.0 |
| 2025-06-05 18:00:00 | ES | Futures | 6027.61 | 6044.12 | 6025.83 | 6043.36 | 8935.0 |
| 2025-06-05 19:00:00 | ES | Futures | 6043.61 | 6048.95 | 6039.8 | 6043.1 | 6309.0 |
| 2025-06-05 20:00:00 | ES | Futures | 6042.85 | 6053.27 | 6042.85 | 6050.22 | 7461.0 |
| 2025-06-05 21:00:00 | ES | Futures | 6050.22 | 6055.81 | 6047.68 | 6052.25 | 5846.0 |
| 2025-06-05 22:00:00 | ES | Futures | 6052.0 | 6053.01 | 6048.69 | 6051.74 | 3860.0 |
| 2025-06-05 23:00:00 | ES | Futures | 6051.49 | 6058.09 | 6049.96 | 6055.81 | 4516.0 |
| 2025-06-05 00:00:00 | NQ | Futures | 22155.81 | 22164.21 | 22149.95 | 22153.26 | 2438.0 |
| 2025-06-05 01:00:00 | NQ | Futures | 22153.26 | 22154.03 | 22129.07 | 22138.75 | 3066.0 |
| 2025-06-05 02:00:00 | NQ | Futures | 22138.49 | 22148.94 | 22127.29 | 22143.59 | 3283.0 |
| 2025-06-05 03:00:00 | NQ | Futures | 22144.61 | 22246.47 | 22143.84 | 22218.46 | 11578.0 |
| 2025-06-05 04:00:00 | NQ | Futures | 22218.96 | 22249.27 | 22178.73 | 22195.54 | 8127.0 |
| 2025-06-05 05:00:00 | NQ | Futures | 22196.05 | 22197.06 | 22169.05 | 22181.02 | 5279.0 |
| 2025-06-05 06:00:00 | NQ | Futures | 22181.02 | 22210.56 | 22158.61 | 22182.29 | 5704.0 |
| 2025-06-05 07:00:00 | NQ | Futures | 22181.79 | 22185.61 | 22150.46 | 22174.91 | 6341.0 |
| 2025-06-05 08:00:00 | NQ | Futures | 22172.36 | 22305.55 | 22116.59 | 22207.25 | 23794.0 |
| 2025-06-05 09:00:00 | NQ | Futures | 22206.23 | 22246.98 | 22095.2 | 22128.05 | 69446.0 |
| 2025-06-05 10:00:00 | NQ | Futures | 22129.07 | 22285.94 | 22107.17 | 22264.55 | 88412.0 |
| 2025-06-05 11:00:00 | NQ | Futures | 22265.06 | 22343.24 | 22251.05 | 22327.96 | 49880.0 |
| 2025-06-05 12:00:00 | NQ | Futures | 22328.21 | 22331.01 | 22073.56 | 22090.87 | 73729.0 |
| 2025-06-05 13:00:00 | NQ | Futures | 22090.62 | 22195.28 | 22062.61 | 22133.4 | 44250.0 |
| 2025-06-05 14:00:00 | NQ | Futures | 22134.42 | 22144.61 | 22008.37 | 22090.37 | 58796.0 |
| 2025-06-05 15:00:00 | NQ | Futures | 22090.11 | 22101.82 | 21903.7 | 21988.76 | 90006.0 |
| 2025-06-05 16:00:00 | NQ | Futures | 21989.01 | 22021.86 | 21911.09 | 21915.42 | 18244.0 |
| 2025-06-05 18:00:00 | NQ | Futures | 21870.6 | 21961.77 | 21870.6 | 21959.22 | 6011.0 |
| 2025-06-05 19:00:00 | NQ | Futures | 21959.73 | 21972.72 | 21940.88 | 21946.49 | 5309.0 |
| 2025-06-05 20:00:00 | NQ | Futures | 21946.23 | 21990.03 | 21944.96 | 21973.22 | 5812.0 |
| 2025-06-05 21:00:00 | NQ | Futures | 21972.72 | 22002.76 | 21964.31 | 21986.21 | 4723.0 |
| 2025-06-05 22:00:00 | NQ | Futures | 21986.21 | 21992.83 | 21973.99 | 21990.03 | 2810.0 |
| 2025-06-05 23:00:00 | NQ | Futures | 21990.8 | 22020.08 | 21981.37 | 22011.93 | 3894.0 |
| 2025-06-05 00:00:00 | YM | Futures | 43715.9 | 43737.6 | 43714.9 | 43736.5 | 142.0 |
| 2025-06-05 01:00:00 | YM | Futures | 43735.5 | 43737.6 | 43710.8 | 43728.3 | 425.0 |
| 2025-06-05 02:00:00 | YM | Futures | 43724.2 | 43731.4 | 43706.7 | 43717.0 | 492.0 |
| 2025-06-05 03:00:00 | YM | Futures | 43717.0 | 43820.9 | 43715.9 | 43814.7 | 1439.0 |
> showing 50 of 2,021 rows — these rows as CSV