PREVIEW / futures_1hour / 2024-09-30
file: by_date/futures_1hour/2024/2024-09-30.parquet size: 68 KB rows: 2,086
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-30 00:00:00 | ES | Futures | 6016.01 | 6017.05 | 6012.12 | 6013.42 | 3436.0 |
| 2024-09-30 01:00:00 | ES | Futures | 6013.42 | 6013.94 | 6007.19 | 6008.75 | 6379.0 |
| 2024-09-30 02:00:00 | ES | Futures | 6008.49 | 6010.82 | 6003.04 | 6006.93 | 10630.0 |
| 2024-09-30 03:00:00 | ES | Futures | 6006.93 | 6017.57 | 6005.63 | 6013.68 | 13708.0 |
| 2024-09-30 04:00:00 | ES | Futures | 6013.42 | 6013.94 | 6005.63 | 6009.52 | 12694.0 |
| 2024-09-30 05:00:00 | ES | Futures | 6009.52 | 6011.6 | 6003.3 | 6009.78 | 8131.0 |
| 2024-09-30 06:00:00 | ES | Futures | 6009.78 | 6011.6 | 6003.81 | 6005.63 | 9344.0 |
| 2024-09-30 07:00:00 | ES | Futures | 6005.89 | 6006.15 | 5994.21 | 5996.03 | 21533.0 |
| 2024-09-30 08:00:00 | ES | Futures | 5996.29 | 6000.44 | 5995.25 | 5998.62 | 17692.0 |
| 2024-09-30 09:00:00 | ES | Futures | 5998.88 | 6011.6 | 5996.81 | 6002.78 | 123529.0 |
| 2024-09-30 10:00:00 | ES | Futures | 6002.78 | 6013.16 | 5998.62 | 6009.26 | 140789.0 |
| 2024-09-30 11:00:00 | ES | Futures | 6009.26 | 6015.23 | 6003.55 | 6012.64 | 96515.0 |
| 2024-09-30 12:00:00 | ES | Futures | 6012.64 | 6019.65 | 6011.86 | 6012.64 | 80754.0 |
| 2024-09-30 13:00:00 | ES | Futures | 6012.64 | 6014.2 | 6005.63 | 6012.9 | 80019.0 |
| 2024-09-30 14:00:00 | ES | Futures | 6012.9 | 6013.16 | 5975.53 | 6002.0 | 244603.0 |
| 2024-09-30 15:00:00 | ES | Futures | 6002.0 | 6041.96 | 5995.25 | 6037.55 | 337464.0 |
| 2024-09-30 16:00:00 | ES | Futures | 6037.55 | 6037.81 | 6026.65 | 6027.43 | 94447.0 |
| 2024-09-30 18:00:00 | ES | Futures | 6028.21 | 6030.29 | 6022.5 | 6028.21 | 8823.0 |
| 2024-09-30 19:00:00 | ES | Futures | 6027.95 | 6030.29 | 6024.84 | 6029.51 | 2845.0 |
| 2024-09-30 20:00:00 | ES | Futures | 6029.77 | 6036.51 | 6025.35 | 6034.44 | 7555.0 |
| 2024-09-30 21:00:00 | ES | Futures | 6034.44 | 6044.3 | 6034.18 | 6043.26 | 8803.0 |
| 2024-09-30 22:00:00 | ES | Futures | 6043.26 | 6044.3 | 6037.03 | 6038.59 | 5023.0 |
| 2024-09-30 23:00:00 | ES | Futures | 6038.59 | 6038.85 | 6034.44 | 6036.51 | 4644.0 |
| 2024-09-30 00:00:00 | NQ | Futures | 21102.33 | 21109.63 | 21068.41 | 21078.32 | 2502.0 |
| 2024-09-30 01:00:00 | NQ | Futures | 21078.58 | 21085.89 | 21047.01 | 21054.06 | 3217.0 |
| 2024-09-30 02:00:00 | NQ | Futures | 21053.54 | 21078.58 | 21025.36 | 21068.67 | 5052.0 |
| 2024-09-30 03:00:00 | NQ | Futures | 21069.19 | 21131.03 | 21064.5 | 21107.02 | 7473.0 |
| 2024-09-30 04:00:00 | NQ | Futures | 21107.02 | 21107.28 | 21056.15 | 21078.58 | 6841.0 |
| 2024-09-30 05:00:00 | NQ | Futures | 21078.85 | 21094.24 | 21050.93 | 21085.89 | 4118.0 |
| 2024-09-30 06:00:00 | NQ | Futures | 21085.37 | 21101.54 | 21063.71 | 21077.02 | 4219.0 |
| 2024-09-30 07:00:00 | NQ | Futures | 21077.54 | 21080.15 | 20997.7 | 21008.66 | 9789.0 |
| 2024-09-30 08:00:00 | NQ | Futures | 21008.4 | 21056.93 | 21002.66 | 21050.15 | 9814.0 |
| 2024-09-30 09:00:00 | NQ | Futures | 21050.41 | 21146.94 | 21042.32 | 21086.15 | 57615.0 |
| 2024-09-30 10:00:00 | NQ | Futures | 21086.67 | 21104.15 | 21006.05 | 21060.58 | 64592.0 |
| 2024-09-30 11:00:00 | NQ | Futures | 21060.32 | 21117.98 | 21047.54 | 21089.8 | 45693.0 |
| 2024-09-30 12:00:00 | NQ | Futures | 21088.76 | 21138.59 | 21086.41 | 21094.24 | 32717.0 |
| 2024-09-30 13:00:00 | NQ | Futures | 21094.76 | 21100.5 | 21049.36 | 21087.46 | 37779.0 |
| 2024-09-30 14:00:00 | NQ | Futures | 21088.24 | 21094.24 | 20931.43 | 21026.66 | 81585.0 |
| 2024-09-30 15:00:00 | NQ | Futures | 21027.18 | 21172.25 | 20996.92 | 21155.55 | 83600.0 |
| 2024-09-30 16:00:00 | NQ | Futures | 21155.29 | 21160.77 | 21115.63 | 21116.42 | 17121.0 |
| 2024-09-30 18:00:00 | NQ | Futures | 21117.46 | 21129.46 | 21095.54 | 21117.72 | 2998.0 |
| 2024-09-30 19:00:00 | NQ | Futures | 21116.68 | 21133.38 | 21103.63 | 21130.77 | 1903.0 |
| 2024-09-30 20:00:00 | NQ | Futures | 21130.77 | 21163.38 | 21104.68 | 21153.73 | 4380.0 |
| 2024-09-30 21:00:00 | NQ | Futures | 21153.99 | 21219.22 | 21153.73 | 21216.09 | 5482.0 |
| 2024-09-30 22:00:00 | NQ | Futures | 21214.52 | 21218.43 | 21168.08 | 21179.3 | 3920.0 |
| 2024-09-30 23:00:00 | NQ | Futures | 21179.04 | 21180.86 | 21153.21 | 21169.9 | 3189.0 |
| 2024-09-30 00:00:00 | YM | Futures | 44413.1 | 44417.2 | 44397.5 | 44405.8 | 386.0 |
| 2024-09-30 01:00:00 | YM | Futures | 44404.7 | 44413.1 | 44376.6 | 44381.8 | 1038.0 |
| 2024-09-30 02:00:00 | YM | Futures | 44381.8 | 44389.1 | 44318.4 | 44328.8 | 1826.0 |
| 2024-09-30 03:00:00 | YM | Futures | 44327.7 | 44377.7 | 44305.9 | 44351.7 | 1978.0 |
> showing 50 of 2,086 rows — these rows as CSV