PREVIEW / futures_1hour / 2026-07-20
file: by_date/futures_1hour/2026/2026-07-20.parquet size: 61 KB rows: 2,103
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 |
|---|---|---|---|---|---|---|---|
| 2026-07-20 00:00:00 | ES | Futures | 7505.75 | 7515.0 | 7499.0 | 7509.25 | 6091.0 |
| 2026-07-20 01:00:00 | ES | Futures | 7509.5 | 7510.25 | 7494.0 | 7496.0 | 6822.0 |
| 2026-07-20 02:00:00 | ES | Futures | 7496.25 | 7499.75 | 7491.0 | 7497.0 | 8162.0 |
| 2026-07-20 03:00:00 | ES | Futures | 7497.25 | 7519.5 | 7496.75 | 7516.0 | 20758.0 |
| 2026-07-20 04:00:00 | ES | Futures | 7516.0 | 7521.75 | 7512.0 | 7514.25 | 13786.0 |
| 2026-07-20 05:00:00 | ES | Futures | 7514.25 | 7527.75 | 7510.5 | 7521.75 | 11315.0 |
| 2026-07-20 06:00:00 | ES | Futures | 7521.75 | 7524.25 | 7516.0 | 7522.0 | 10363.0 |
| 2026-07-20 07:00:00 | ES | Futures | 7522.0 | 7545.25 | 7520.75 | 7535.5 | 43193.0 |
| 2026-07-20 08:00:00 | ES | Futures | 7535.5 | 7536.0 | 7521.0 | 7527.25 | 38509.0 |
| 2026-07-20 09:00:00 | ES | Futures | 7527.25 | 7552.0 | 7519.0 | 7520.5 | 175025.0 |
| 2026-07-20 10:00:00 | ES | Futures | 7520.75 | 7527.5 | 7500.75 | 7505.25 | 189423.0 |
| 2026-07-20 11:00:00 | ES | Futures | 7505.0 | 7528.25 | 7502.0 | 7523.5 | 132809.0 |
| 2026-07-20 12:00:00 | ES | Futures | 7523.75 | 7534.0 | 7508.25 | 7513.75 | 123912.0 |
| 2026-07-20 13:00:00 | ES | Futures | 7513.75 | 7515.75 | 7499.25 | 7509.0 | 88166.0 |
| 2026-07-20 14:00:00 | ES | Futures | 7509.25 | 7517.75 | 7487.75 | 7490.5 | 110688.0 |
| 2026-07-20 15:00:00 | ES | Futures | 7490.25 | 7497.25 | 7478.0 | 7486.0 | 209386.0 |
| 2026-07-20 16:00:00 | ES | Futures | 7485.75 | 7493.25 | 7476.75 | 7483.25 | 44277.0 |
| 2026-07-20 18:00:00 | ES | Futures | 7484.0 | 7485.75 | 7473.0 | 7475.5 | 6393.0 |
| 2026-07-20 19:00:00 | ES | Futures | 7475.5 | 7491.0 | 7474.5 | 7485.25 | 6208.0 |
| 2026-07-20 20:00:00 | ES | Futures | 7485.0 | 7495.75 | 7473.75 | 7492.25 | 14216.0 |
| 2026-07-20 21:00:00 | ES | Futures | 7492.25 | 7499.25 | 7489.5 | 7492.5 | 10569.0 |
| 2026-07-20 22:00:00 | ES | Futures | 7493.0 | 7501.75 | 7488.75 | 7501.75 | 8022.0 |
| 2026-07-20 23:00:00 | ES | Futures | 7501.5 | 7513.0 | 7501.5 | 7512.75 | 9032.0 |
| 2026-07-20 00:00:00 | NQ | Futures | 28900.0 | 28942.0 | 28844.5 | 28897.75 | 5081.0 |
| 2026-07-20 01:00:00 | NQ | Futures | 28898.0 | 28901.75 | 28789.0 | 28807.25 | 5620.0 |
| 2026-07-20 02:00:00 | NQ | Futures | 28808.0 | 28823.75 | 28766.0 | 28803.5 | 4758.0 |
| 2026-07-20 03:00:00 | NQ | Futures | 28805.75 | 28926.0 | 28797.75 | 28911.0 | 7043.0 |
| 2026-07-20 04:00:00 | NQ | Futures | 28908.25 | 28939.75 | 28860.0 | 28882.0 | 4920.0 |
| 2026-07-20 05:00:00 | NQ | Futures | 28879.25 | 28998.25 | 28854.0 | 28952.5 | 5825.0 |
| 2026-07-20 06:00:00 | NQ | Futures | 28952.75 | 28980.0 | 28920.5 | 28969.0 | 4816.0 |
| 2026-07-20 07:00:00 | NQ | Futures | 28970.75 | 29109.5 | 28963.75 | 29072.5 | 13737.0 |
| 2026-07-20 08:00:00 | NQ | Futures | 29072.5 | 29075.5 | 28981.75 | 29025.0 | 10768.0 |
| 2026-07-20 09:00:00 | NQ | Futures | 29025.0 | 29192.5 | 28979.75 | 28994.75 | 68333.0 |
| 2026-07-20 10:00:00 | NQ | Futures | 28996.0 | 29053.75 | 28874.0 | 28891.5 | 75409.0 |
| 2026-07-20 11:00:00 | NQ | Futures | 28891.75 | 29066.75 | 28873.25 | 29050.75 | 50609.0 |
| 2026-07-20 12:00:00 | NQ | Futures | 29050.75 | 29119.0 | 28956.0 | 28983.75 | 46115.0 |
| 2026-07-20 13:00:00 | NQ | Futures | 28983.0 | 28999.75 | 28900.75 | 28956.5 | 32686.0 |
| 2026-07-20 14:00:00 | NQ | Futures | 28957.0 | 29009.75 | 28855.75 | 28870.0 | 35068.0 |
| 2026-07-20 15:00:00 | NQ | Futures | 28871.0 | 28896.0 | 28767.75 | 28785.5 | 58239.0 |
| 2026-07-20 16:00:00 | NQ | Futures | 28784.75 | 28831.5 | 28750.5 | 28777.0 | 13452.0 |
| 2026-07-20 18:00:00 | NQ | Futures | 28778.25 | 28803.5 | 28701.0 | 28717.75 | 4870.0 |
| 2026-07-20 19:00:00 | NQ | Futures | 28717.75 | 28832.5 | 28711.25 | 28779.25 | 6831.0 |
| 2026-07-20 20:00:00 | NQ | Futures | 28777.5 | 28897.0 | 28707.25 | 28856.25 | 11898.0 |
| 2026-07-20 21:00:00 | NQ | Futures | 28859.75 | 28920.5 | 28837.5 | 28885.25 | 7398.0 |
| 2026-07-20 22:00:00 | NQ | Futures | 28885.25 | 28956.75 | 28859.0 | 28955.0 | 5770.0 |
| 2026-07-20 23:00:00 | NQ | Futures | 28954.0 | 29078.0 | 28951.25 | 29072.5 | 7628.0 |
| 2026-07-20 00:00:00 | YM | Futures | 52346.0 | 52403.0 | 52312.0 | 52380.0 | 369.0 |
| 2026-07-20 01:00:00 | YM | Futures | 52383.0 | 52386.0 | 52309.0 | 52311.0 | 623.0 |
| 2026-07-20 02:00:00 | YM | Futures | 52317.0 | 52330.0 | 52270.0 | 52294.0 | 1133.0 |
| 2026-07-20 03:00:00 | YM | Futures | 52297.0 | 52470.0 | 52295.0 | 52430.0 | 1852.0 |
> showing 50 of 2,103 rows — these rows as CSV