PREVIEW / futures_1hour / 2024-09-24
file: by_date/futures_1hour/2024/2024-09-24.parquet size: 69 KB rows: 2,094
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-24 00:00:00 | ES | Futures | 5987.72 | 5993.43 | 5987.2 | 5993.43 | 4098.0 |
| 2024-09-24 01:00:00 | ES | Futures | 5993.43 | 5999.92 | 5993.43 | 5998.36 | 6519.0 |
| 2024-09-24 02:00:00 | ES | Futures | 5998.36 | 6007.19 | 5996.81 | 6005.37 | 8720.0 |
| 2024-09-24 03:00:00 | ES | Futures | 6005.37 | 6009.52 | 5998.36 | 6009.26 | 12583.0 |
| 2024-09-24 04:00:00 | ES | Futures | 6009.0 | 6014.2 | 6006.15 | 6012.9 | 11845.0 |
| 2024-09-24 05:00:00 | ES | Futures | 6012.9 | 6012.9 | 6004.85 | 6006.67 | 8912.0 |
| 2024-09-24 06:00:00 | ES | Futures | 6006.67 | 6010.56 | 6000.44 | 6001.22 | 10051.0 |
| 2024-09-24 07:00:00 | ES | Futures | 6001.22 | 6005.89 | 5989.02 | 6000.44 | 28062.0 |
| 2024-09-24 08:00:00 | ES | Futures | 6000.7 | 6004.33 | 5996.55 | 6002.26 | 23229.0 |
| 2024-09-24 09:00:00 | ES | Futures | 6002.0 | 6008.23 | 5991.1 | 5992.4 | 104470.0 |
| 2024-09-24 10:00:00 | ES | Futures | 5992.65 | 5996.29 | 5973.97 | 5993.95 | 253578.0 |
| 2024-09-24 11:00:00 | ES | Futures | 5993.69 | 6011.08 | 5992.4 | 6005.89 | 150900.0 |
| 2024-09-24 12:00:00 | ES | Futures | 6005.89 | 6011.86 | 6002.0 | 6004.07 | 84675.0 |
| 2024-09-24 13:00:00 | ES | Futures | 6004.07 | 6010.04 | 6002.26 | 6004.33 | 69691.0 |
| 2024-09-24 14:00:00 | ES | Futures | 6004.33 | 6006.93 | 5993.43 | 6004.33 | 96329.0 |
| 2024-09-24 15:00:00 | ES | Futures | 6004.33 | 6014.97 | 6003.3 | 6013.68 | 158833.0 |
| 2024-09-24 16:00:00 | ES | Futures | 6013.68 | 6014.45 | 6009.0 | 6013.42 | 46842.0 |
| 2024-09-24 18:00:00 | ES | Futures | 6012.9 | 6015.23 | 6011.34 | 6013.42 | 2772.0 |
| 2024-09-24 19:00:00 | ES | Futures | 6013.42 | 6015.23 | 6012.12 | 6012.64 | 3263.0 |
| 2024-09-24 20:00:00 | ES | Futures | 6012.64 | 6013.42 | 6004.85 | 6005.63 | 7353.0 |
| 2024-09-24 21:00:00 | ES | Futures | 6005.63 | 6007.71 | 6000.44 | 6002.0 | 8399.0 |
| 2024-09-24 22:00:00 | ES | Futures | 6002.0 | 6004.33 | 6000.7 | 6001.22 | 4142.0 |
| 2024-09-24 23:00:00 | ES | Futures | 6001.22 | 6006.15 | 5999.4 | 6003.81 | 5193.0 |
| 2024-09-24 00:00:00 | NQ | Futures | 20925.43 | 20951.0 | 20919.95 | 20949.43 | 2101.0 |
| 2024-09-24 01:00:00 | NQ | Futures | 20950.48 | 20987.79 | 20950.48 | 20981.79 | 4028.0 |
| 2024-09-24 02:00:00 | NQ | Futures | 20982.57 | 21019.1 | 20972.39 | 21006.57 | 4841.0 |
| 2024-09-24 03:00:00 | NQ | Futures | 21007.36 | 21033.45 | 20970.05 | 21032.14 | 6648.0 |
| 2024-09-24 04:00:00 | NQ | Futures | 21031.36 | 21060.06 | 21013.1 | 21044.67 | 8740.0 |
| 2024-09-24 05:00:00 | NQ | Futures | 21044.93 | 21045.71 | 21000.57 | 21010.23 | 7685.0 |
| 2024-09-24 06:00:00 | NQ | Futures | 21010.23 | 21035.27 | 20991.18 | 20994.31 | 5642.0 |
| 2024-09-24 07:00:00 | NQ | Futures | 20994.31 | 21005.27 | 20925.95 | 20983.35 | 13814.0 |
| 2024-09-24 08:00:00 | NQ | Futures | 20983.61 | 21003.18 | 20962.48 | 20991.18 | 9717.0 |
| 2024-09-24 09:00:00 | NQ | Futures | 20990.14 | 21033.71 | 20958.56 | 20966.13 | 45026.0 |
| 2024-09-24 10:00:00 | NQ | Futures | 20967.96 | 20970.31 | 20823.93 | 20950.74 | 97385.0 |
| 2024-09-24 11:00:00 | NQ | Futures | 20950.22 | 21097.11 | 20944.74 | 21068.15 | 71592.0 |
| 2024-09-24 12:00:00 | NQ | Futures | 21068.67 | 21096.59 | 21040.23 | 21042.06 | 40013.0 |
| 2024-09-24 13:00:00 | NQ | Futures | 21042.58 | 21074.93 | 21030.58 | 21045.71 | 28453.0 |
| 2024-09-24 14:00:00 | NQ | Futures | 21045.45 | 21056.41 | 20986.48 | 21027.18 | 34926.0 |
| 2024-09-24 15:00:00 | NQ | Futures | 21026.66 | 21054.84 | 21017.79 | 21050.67 | 38415.0 |
| 2024-09-24 16:00:00 | NQ | Futures | 21050.67 | 21070.76 | 21042.32 | 21066.32 | 13206.0 |
| 2024-09-24 18:00:00 | NQ | Futures | 21064.76 | 21070.24 | 21054.32 | 21067.37 | 1927.0 |
| 2024-09-24 19:00:00 | NQ | Futures | 21066.32 | 21073.63 | 21058.76 | 21060.58 | 1776.0 |
| 2024-09-24 20:00:00 | NQ | Futures | 21061.1 | 21063.97 | 21015.18 | 21021.44 | 4825.0 |
| 2024-09-24 21:00:00 | NQ | Futures | 21020.92 | 21035.53 | 20994.05 | 21003.96 | 4764.0 |
| 2024-09-24 22:00:00 | NQ | Futures | 21003.7 | 21015.97 | 20997.18 | 21000.83 | 2211.0 |
| 2024-09-24 23:00:00 | NQ | Futures | 20999.27 | 21021.44 | 20987.0 | 21006.31 | 3455.0 |
| 2024-09-24 00:00:00 | YM | Futures | 44153.9 | 44186.2 | 44151.8 | 44184.1 | 557.0 |
| 2024-09-24 01:00:00 | YM | Futures | 44185.1 | 44215.3 | 44185.1 | 44204.9 | 837.0 |
| 2024-09-24 02:00:00 | YM | Futures | 44204.9 | 44265.3 | 44196.6 | 44254.9 | 1177.0 |
| 2024-09-24 03:00:00 | YM | Futures | 44257.0 | 44288.2 | 44216.4 | 44280.9 | 1919.0 |
> showing 50 of 2,094 rows — these rows as CSV