PREVIEW / futures_1hour / 2025-10-28
file: by_date/futures_1hour/2025/2025-10-28.parquet size: 64 KB rows: 2,101
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-28 00:00:00 | ES | Futures | 6959.8 | 6960.81 | 6956.53 | 6956.78 | 4247.0 |
| 2025-10-28 01:00:00 | ES | Futures | 6957.03 | 6958.29 | 6954.01 | 6956.53 | 5385.0 |
| 2025-10-28 02:00:00 | ES | Futures | 6956.78 | 6961.56 | 6955.27 | 6955.52 | 5520.0 |
| 2025-10-28 03:00:00 | ES | Futures | 6955.77 | 6960.56 | 6954.01 | 6955.27 | 8075.0 |
| 2025-10-28 04:00:00 | ES | Futures | 6955.52 | 6959.8 | 6953.25 | 6958.54 | 14254.0 |
| 2025-10-28 05:00:00 | ES | Futures | 6958.54 | 6960.05 | 6955.77 | 6959.05 | 6952.0 |
| 2025-10-28 06:00:00 | ES | Futures | 6959.05 | 6962.32 | 6957.79 | 6959.3 | 7345.0 |
| 2025-10-28 07:00:00 | ES | Futures | 6959.3 | 6965.85 | 6958.79 | 6964.33 | 14381.0 |
| 2025-10-28 08:00:00 | ES | Futures | 6964.59 | 6970.13 | 6964.08 | 6967.86 | 19729.0 |
| 2025-10-28 09:00:00 | ES | Futures | 6968.11 | 6979.45 | 6958.54 | 6963.33 | 173879.0 |
| 2025-10-28 10:00:00 | ES | Futures | 6963.33 | 6970.88 | 6961.82 | 6965.59 | 127670.0 |
| 2025-10-28 11:00:00 | ES | Futures | 6965.85 | 6969.37 | 6954.76 | 6962.82 | 100570.0 |
| 2025-10-28 12:00:00 | ES | Futures | 6962.57 | 6981.97 | 6962.57 | 6976.17 | 159442.0 |
| 2025-10-28 13:00:00 | ES | Futures | 6976.42 | 6984.48 | 6975.92 | 6983.48 | 111871.0 |
| 2025-10-28 14:00:00 | ES | Futures | 6983.73 | 6991.79 | 6982.97 | 6989.02 | 96048.0 |
| 2025-10-28 15:00:00 | ES | Futures | 6989.02 | 6996.83 | 6976.17 | 6977.43 | 218751.0 |
| 2025-10-28 16:00:00 | ES | Futures | 6977.43 | 6979.95 | 6973.4 | 6979.45 | 52477.0 |
| 2025-10-28 18:00:00 | ES | Futures | 6981.21 | 6983.48 | 6977.18 | 6977.94 | 4546.0 |
| 2025-10-28 19:00:00 | ES | Futures | 6977.94 | 6980.96 | 6976.42 | 6979.7 | 3161.0 |
| 2025-10-28 20:00:00 | ES | Futures | 6979.95 | 6982.47 | 6976.42 | 6977.94 | 5758.0 |
| 2025-10-28 21:00:00 | ES | Futures | 6977.68 | 6987.0 | 6977.43 | 6984.74 | 9819.0 |
| 2025-10-28 22:00:00 | ES | Futures | 6984.74 | 6992.04 | 6984.48 | 6989.52 | 7067.0 |
| 2025-10-28 23:00:00 | ES | Futures | 6989.77 | 6991.29 | 6986.5 | 6990.03 | 4109.0 |
| 2025-10-28 00:00:00 | NQ | Futures | 26208.35 | 26210.62 | 26182.88 | 26184.14 | 2575.0 |
| 2025-10-28 01:00:00 | NQ | Futures | 26184.39 | 26194.23 | 26173.3 | 26187.92 | 3366.0 |
| 2025-10-28 02:00:00 | NQ | Futures | 26188.43 | 26212.64 | 26180.61 | 26184.39 | 3320.0 |
| 2025-10-28 03:00:00 | NQ | Futures | 26185.4 | 26207.85 | 26178.59 | 26184.64 | 3770.0 |
| 2025-10-28 04:00:00 | NQ | Futures | 26185.65 | 26200.53 | 26169.77 | 26194.98 | 5295.0 |
| 2025-10-28 05:00:00 | NQ | Futures | 26195.74 | 26208.85 | 26189.44 | 26202.8 | 3065.0 |
| 2025-10-28 06:00:00 | NQ | Futures | 26202.55 | 26216.67 | 26194.73 | 26204.57 | 4035.0 |
| 2025-10-28 07:00:00 | NQ | Futures | 26205.07 | 26231.3 | 26204.31 | 26220.96 | 6427.0 |
| 2025-10-28 08:00:00 | NQ | Futures | 26220.96 | 26252.48 | 26219.7 | 26239.87 | 9137.0 |
| 2025-10-28 09:00:00 | NQ | Futures | 26239.87 | 26322.84 | 26235.59 | 26292.83 | 70433.0 |
| 2025-10-28 10:00:00 | NQ | Futures | 26292.83 | 26304.43 | 26236.09 | 26262.57 | 56005.0 |
| 2025-10-28 11:00:00 | NQ | Futures | 26263.07 | 26289.55 | 26233.32 | 26288.29 | 37887.0 |
| 2025-10-28 12:00:00 | NQ | Futures | 26288.54 | 26375.3 | 26288.29 | 26336.71 | 52363.0 |
| 2025-10-28 13:00:00 | NQ | Futures | 26336.71 | 26386.9 | 26330.91 | 26381.85 | 41186.0 |
| 2025-10-28 14:00:00 | NQ | Futures | 26382.11 | 26425.99 | 26375.8 | 26423.72 | 35549.0 |
| 2025-10-28 15:00:00 | NQ | Futures | 26423.72 | 26460.79 | 26386.39 | 26388.66 | 67919.0 |
| 2025-10-28 16:00:00 | NQ | Futures | 26388.66 | 26406.82 | 26379.08 | 26401.27 | 18179.0 |
| 2025-10-28 18:00:00 | NQ | Futures | 26408.58 | 26419.18 | 26397.24 | 26402.28 | 2859.0 |
| 2025-10-28 19:00:00 | NQ | Futures | 26401.02 | 26418.67 | 26393.2 | 26412.37 | 2206.0 |
| 2025-10-28 20:00:00 | NQ | Futures | 26413.12 | 26422.96 | 26394.71 | 26403.29 | 3702.0 |
| 2025-10-28 21:00:00 | NQ | Futures | 26403.04 | 26451.96 | 26401.52 | 26444.65 | 7127.0 |
| 2025-10-28 22:00:00 | NQ | Futures | 26445.15 | 26482.22 | 26443.39 | 26468.6 | 6585.0 |
| 2025-10-28 23:00:00 | NQ | Futures | 26469.11 | 26480.46 | 26453.47 | 26473.9 | 3231.0 |
| 2025-10-28 00:00:00 | YM | Futures | 48387.3 | 48395.5 | 48365.0 | 48372.1 | 464.0 |
| 2025-10-28 01:00:00 | YM | Futures | 48373.1 | 48385.3 | 48362.0 | 48374.2 | 402.0 |
| 2025-10-28 02:00:00 | YM | Futures | 48375.2 | 48398.5 | 48366.0 | 48372.1 | 605.0 |
| 2025-10-28 03:00:00 | YM | Futures | 48372.1 | 48398.5 | 48366.0 | 48371.1 | 859.0 |
> showing 50 of 2,101 rows — these rows as CSV