PREVIEW / futures_1hour / 2025-10-17
file: by_date/futures_1hour/2025/2025-10-17.parquet size: 57 KB rows: 1,702
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-10-17 00:00:00 | ES | Futures | 6691.81 | 6693.82 | 6685.26 | 6686.52 | 7536.0 |
| 2025-10-17 01:00:00 | ES | Futures | 6686.77 | 6687.27 | 6668.13 | 6677.95 | 15961.0 |
| 2025-10-17 02:00:00 | ES | Futures | 6678.21 | 6684.25 | 6658.31 | 6660.83 | 21891.0 |
| 2025-10-17 03:00:00 | ES | Futures | 6661.08 | 6662.84 | 6620.78 | 6634.13 | 62561.0 |
| 2025-10-17 04:00:00 | ES | Futures | 6634.13 | 6647.22 | 6620.53 | 6640.42 | 39320.0 |
| 2025-10-17 05:00:00 | ES | Futures | 6640.17 | 6658.06 | 6638.91 | 6641.43 | 30507.0 |
| 2025-10-17 06:00:00 | ES | Futures | 6641.68 | 6665.61 | 6640.17 | 6665.11 | 50990.0 |
| 2025-10-17 07:00:00 | ES | Futures | 6665.36 | 6705.66 | 6662.34 | 6702.64 | 90159.0 |
| 2025-10-17 08:00:00 | ES | Futures | 6702.64 | 6722.03 | 6696.59 | 6708.43 | 78204.0 |
| 2025-10-17 09:00:00 | ES | Futures | 6708.18 | 6734.63 | 6691.3 | 6716.24 | 255458.0 |
| 2025-10-17 10:00:00 | ES | Futures | 6716.24 | 6747.72 | 6702.89 | 6705.41 | 299620.0 |
| 2025-10-17 11:00:00 | ES | Futures | 6705.41 | 6732.36 | 6690.3 | 6727.07 | 269944.0 |
| 2025-10-17 12:00:00 | ES | Futures | 6727.07 | 6746.97 | 6722.28 | 6730.09 | 178342.0 |
| 2025-10-17 13:00:00 | ES | Futures | 6730.09 | 6740.92 | 6714.98 | 6738.91 | 145998.0 |
| 2025-10-17 14:00:00 | ES | Futures | 6738.91 | 6761.83 | 6738.66 | 6754.27 | 125027.0 |
| 2025-10-17 15:00:00 | ES | Futures | 6754.52 | 6768.38 | 6750.75 | 6754.02 | 213238.0 |
| 2025-10-17 16:00:00 | ES | Futures | 6754.02 | 6763.34 | 6751.75 | 6761.32 | 51766.0 |
| 2025-10-17 00:00:00 | NQ | Futures | 24948.43 | 24956.75 | 24916.15 | 24922.71 | 4021.0 |
| 2025-10-17 01:00:00 | NQ | Futures | 24922.71 | 24927.25 | 24831.42 | 24876.06 | 10770.0 |
| 2025-10-17 02:00:00 | NQ | Futures | 24877.06 | 24906.57 | 24784.76 | 24795.61 | 10746.0 |
| 2025-10-17 03:00:00 | NQ | Futures | 24796.62 | 24803.43 | 24641.52 | 24689.44 | 26604.0 |
| 2025-10-17 04:00:00 | NQ | Futures | 24692.21 | 24742.14 | 24623.37 | 24706.33 | 19529.0 |
| 2025-10-17 05:00:00 | NQ | Futures | 24705.83 | 24776.19 | 24700.03 | 24710.62 | 12269.0 |
| 2025-10-17 06:00:00 | NQ | Futures | 24711.13 | 24790.31 | 24697.0 | 24789.05 | 19139.0 |
| 2025-10-17 07:00:00 | NQ | Futures | 24789.3 | 24949.69 | 24783.25 | 24945.15 | 34376.0 |
| 2025-10-17 08:00:00 | NQ | Futures | 24944.65 | 25019.55 | 24926.49 | 24954.48 | 26812.0 |
| 2025-10-17 09:00:00 | NQ | Futures | 24953.22 | 25107.31 | 24888.16 | 25039.22 | 95266.0 |
| 2025-10-17 10:00:00 | NQ | Futures | 25038.97 | 25178.93 | 24965.33 | 24980.46 | 107275.0 |
| 2025-10-17 11:00:00 | NQ | Futures | 24980.96 | 25090.92 | 24890.68 | 25066.71 | 94149.0 |
| 2025-10-17 12:00:00 | NQ | Futures | 25066.71 | 25191.54 | 25066.2 | 25120.42 | 68857.0 |
| 2025-10-17 13:00:00 | NQ | Futures | 25120.93 | 25164.56 | 25046.03 | 25154.47 | 50007.0 |
| 2025-10-17 14:00:00 | NQ | Futures | 25153.21 | 25248.79 | 25152.95 | 25215.24 | 43777.0 |
| 2025-10-17 15:00:00 | NQ | Futures | 25216.25 | 25274.76 | 25197.59 | 25207.17 | 54349.0 |
| 2025-10-17 16:00:00 | NQ | Futures | 25207.17 | 25261.9 | 25194.31 | 25252.32 | 17293.0 |
| 2025-10-17 00:00:00 | YM | Futures | 46691.7 | 46700.9 | 46643.1 | 46650.2 | 882.0 |
| 2025-10-17 01:00:00 | YM | Futures | 46652.2 | 46656.3 | 46565.0 | 46613.7 | 2062.0 |
| 2025-10-17 02:00:00 | YM | Futures | 46615.7 | 46646.1 | 46509.2 | 46524.4 | 3294.0 |
| 2025-10-17 03:00:00 | YM | Futures | 46524.4 | 46534.6 | 46248.6 | 46358.1 | 8725.0 |
| 2025-10-17 04:00:00 | YM | Futures | 46359.1 | 46441.3 | 46281.0 | 46403.7 | 4888.0 |
| 2025-10-17 05:00:00 | YM | Futures | 46399.7 | 46525.4 | 46392.6 | 46423.0 | 3631.0 |
| 2025-10-17 06:00:00 | YM | Futures | 46424.0 | 46555.9 | 46411.9 | 46553.8 | 4688.0 |
| 2025-10-17 07:00:00 | YM | Futures | 46553.8 | 46838.8 | 46545.7 | 46787.1 | 11067.0 |
| 2025-10-17 08:00:00 | YM | Futures | 46785.0 | 46920.9 | 46754.6 | 46835.8 | 6185.0 |
| 2025-10-17 09:00:00 | YM | Futures | 46834.7 | 47046.7 | 46765.8 | 46902.7 | 23824.0 |
| 2025-10-17 10:00:00 | YM | Futures | 46901.7 | 47073.1 | 46794.2 | 46801.3 | 25040.0 |
| 2025-10-17 11:00:00 | YM | Futures | 46801.3 | 47012.2 | 46746.5 | 46976.7 | 12549.0 |
| 2025-10-17 12:00:00 | YM | Futures | 46978.7 | 47072.0 | 46888.5 | 46936.2 | 8307.0 |
| 2025-10-17 13:00:00 | YM | Futures | 46933.1 | 47002.1 | 46855.0 | 46986.9 | 6303.0 |
| 2025-10-17 14:00:00 | YM | Futures | 46986.9 | 47129.8 | 46986.9 | 47105.5 | 6520.0 |
| 2025-10-17 15:00:00 | YM | Futures | 47104.5 | 47174.5 | 47027.4 | 47037.6 | 10063.0 |
> showing 50 of 1,702 rows — these rows as CSV