PREVIEW / futures_30min / 2024-09-25
file: by_date/futures_30min/2024/2024-09-25.parquet size: 112 KB rows: 3,998
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-25 00:00:00 | ES | Futures | 6003.81 | 6004.59 | 6002.78 | 6004.07 | 1202.0 |
| 2024-09-25 00:30:00 | ES | Futures | 6004.07 | 6005.63 | 6002.78 | 6003.55 | 1655.0 |
| 2024-09-25 01:00:00 | ES | Futures | 6003.3 | 6006.15 | 6002.26 | 6002.78 | 2770.0 |
| 2024-09-25 01:30:00 | ES | Futures | 6002.78 | 6003.81 | 5996.03 | 5998.36 | 4881.0 |
| 2024-09-25 02:00:00 | ES | Futures | 5998.36 | 5999.66 | 5993.43 | 5994.99 | 5624.0 |
| 2024-09-25 02:30:00 | ES | Futures | 5994.99 | 5996.81 | 5993.69 | 5993.95 | 3969.0 |
| 2024-09-25 03:00:00 | ES | Futures | 5994.21 | 6003.3 | 5994.21 | 6003.04 | 7242.0 |
| 2024-09-25 03:30:00 | ES | Futures | 6003.3 | 6004.59 | 6001.22 | 6003.81 | 3558.0 |
| 2024-09-25 04:00:00 | ES | Futures | 6003.55 | 6005.37 | 6001.74 | 6002.78 | 5697.0 |
| 2024-09-25 04:30:00 | ES | Futures | 6002.78 | 6004.07 | 6000.7 | 6002.78 | 3300.0 |
| 2024-09-25 05:00:00 | ES | Futures | 6002.78 | 6004.33 | 5999.4 | 6001.74 | 3281.0 |
| 2024-09-25 05:30:00 | ES | Futures | 6001.48 | 6005.63 | 6000.7 | 6004.59 | 3619.0 |
| 2024-09-25 06:00:00 | ES | Futures | 6004.59 | 6009.52 | 6004.59 | 6008.75 | 5154.0 |
| 2024-09-25 06:30:00 | ES | Futures | 6008.75 | 6011.6 | 6005.63 | 6011.34 | 4881.0 |
| 2024-09-25 07:00:00 | ES | Futures | 6011.6 | 6013.16 | 6009.52 | 6010.04 | 6082.0 |
| 2024-09-25 07:30:00 | ES | Futures | 6010.04 | 6010.82 | 6006.93 | 6010.56 | 5039.0 |
| 2024-09-25 08:00:00 | ES | Futures | 6010.3 | 6011.34 | 6007.45 | 6009.78 | 5437.0 |
| 2024-09-25 08:30:00 | ES | Futures | 6010.04 | 6012.12 | 6007.97 | 6010.56 | 7992.0 |
| 2024-09-25 09:00:00 | ES | Futures | 6010.56 | 6013.16 | 6008.75 | 6011.34 | 11887.0 |
| 2024-09-25 09:30:00 | ES | Futures | 6011.08 | 6018.87 | 6008.49 | 6015.23 | 119966.0 |
| 2024-09-25 10:00:00 | ES | Futures | 6015.23 | 6019.65 | 6009.0 | 6011.08 | 78919.0 |
| 2024-09-25 10:30:00 | ES | Futures | 6010.82 | 6014.2 | 6005.37 | 6012.12 | 68153.0 |
| 2024-09-25 11:00:00 | ES | Futures | 6012.12 | 6014.2 | 6006.67 | 6007.19 | 47234.0 |
| 2024-09-25 11:30:00 | ES | Futures | 6007.19 | 6012.38 | 6002.78 | 6007.45 | 59480.0 |
| 2024-09-25 12:00:00 | ES | Futures | 6007.19 | 6007.97 | 6002.0 | 6005.89 | 41417.0 |
| 2024-09-25 12:30:00 | ES | Futures | 6006.15 | 6006.15 | 5998.36 | 5999.14 | 50070.0 |
| 2024-09-25 13:00:00 | ES | Futures | 5999.14 | 6001.48 | 5989.8 | 5996.29 | 53079.0 |
| 2024-09-25 13:30:00 | ES | Futures | 5996.29 | 6002.78 | 5987.72 | 6002.26 | 64307.0 |
| 2024-09-25 14:00:00 | ES | Futures | 6002.26 | 6003.3 | 5988.76 | 6001.48 | 47636.0 |
| 2024-09-25 14:30:00 | ES | Futures | 6001.48 | 6002.26 | 5996.81 | 5999.66 | 33582.0 |
| 2024-09-25 15:00:00 | ES | Futures | 5999.92 | 6002.26 | 5996.29 | 5997.59 | 35453.0 |
| 2024-09-25 15:30:00 | ES | Futures | 5997.85 | 6001.48 | 5992.4 | 5999.66 | 98406.0 |
| 2024-09-25 16:00:00 | ES | Futures | 5999.66 | 6004.85 | 5998.1 | 6002.78 | 45721.0 |
| 2024-09-25 16:30:00 | ES | Futures | 6002.52 | 6004.33 | 6002.26 | 6003.55 | 5270.0 |
| 2024-09-25 18:00:00 | ES | Futures | 6003.81 | 6004.07 | 6000.96 | 6002.0 | 1768.0 |
| 2024-09-25 18:30:00 | ES | Futures | 6002.0 | 6006.15 | 6001.74 | 6004.33 | 1761.0 |
| 2024-09-25 19:00:00 | ES | Futures | 6004.33 | 6005.63 | 6003.04 | 6005.37 | 830.0 |
| 2024-09-25 19:30:00 | ES | Futures | 6005.37 | 6011.34 | 6004.85 | 6009.52 | 4413.0 |
| 2024-09-25 20:00:00 | ES | Futures | 6009.52 | 6014.97 | 6009.26 | 6014.71 | 5964.0 |
| 2024-09-25 20:30:00 | ES | Futures | 6014.97 | 6017.31 | 6013.42 | 6014.97 | 4550.0 |
| 2024-09-25 21:00:00 | ES | Futures | 6014.71 | 6016.27 | 6013.68 | 6014.45 | 2321.0 |
| 2024-09-25 21:30:00 | ES | Futures | 6014.45 | 6020.16 | 6013.94 | 6018.61 | 4539.0 |
| 2024-09-25 22:00:00 | ES | Futures | 6018.61 | 6020.68 | 6017.57 | 6019.65 | 3331.0 |
| 2024-09-25 22:30:00 | ES | Futures | 6019.9 | 6020.68 | 6019.39 | 6020.16 | 2372.0 |
| 2024-09-25 23:00:00 | ES | Futures | 6020.16 | 6022.5 | 6020.16 | 6020.94 | 2981.0 |
| 2024-09-25 23:30:00 | ES | Futures | 6020.94 | 6027.95 | 6020.94 | 6026.65 | 5864.0 |
| 2024-09-25 00:00:00 | NQ | Futures | 21006.83 | 21014.14 | 21003.18 | 21009.96 | 770.0 |
| 2024-09-25 00:30:00 | NQ | Futures | 21009.18 | 21019.1 | 21003.18 | 21007.88 | 866.0 |
| 2024-09-25 01:00:00 | NQ | Futures | 21007.62 | 21018.84 | 21000.31 | 21006.31 | 1286.0 |
| 2024-09-25 01:30:00 | NQ | Futures | 21005.53 | 21013.1 | 20964.83 | 20976.31 | 2601.0 |
> showing 50 of 3,998 rows — these rows as CSV