PREVIEW / futures_1hour / 2025-05-19
file: by_date/futures_1hour/2025/2025-05-19.parquet size: 67 KB rows: 2,072
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-05-19 00:00:00 | ES | Futures | 6007.79 | 6012.37 | 6005.25 | 6008.56 | 5702.0 |
| 2025-05-19 01:00:00 | ES | Futures | 6008.3 | 6014.4 | 6005.76 | 6012.87 | 5877.0 |
| 2025-05-19 02:00:00 | ES | Futures | 6012.62 | 6019.22 | 6000.43 | 6000.93 | 12002.0 |
| 2025-05-19 03:00:00 | ES | Futures | 6001.19 | 6008.56 | 5997.89 | 6001.44 | 12660.0 |
| 2025-05-19 04:00:00 | ES | Futures | 6001.19 | 6003.22 | 5987.98 | 5993.06 | 19022.0 |
| 2025-05-19 05:00:00 | ES | Futures | 5993.06 | 6003.22 | 5988.99 | 5998.9 | 13099.0 |
| 2025-05-19 06:00:00 | ES | Futures | 5999.16 | 6008.3 | 5990.77 | 6005.0 | 12224.0 |
| 2025-05-19 07:00:00 | ES | Futures | 6005.25 | 6013.64 | 6000.93 | 6011.6 | 15594.0 |
| 2025-05-19 08:00:00 | ES | Futures | 6011.6 | 6014.65 | 6003.47 | 6013.13 | 26222.0 |
| 2025-05-19 09:00:00 | ES | Futures | 6013.38 | 6041.58 | 5997.89 | 6039.8 | 166623.0 |
| 2025-05-19 10:00:00 | ES | Futures | 6039.55 | 6061.14 | 6037.77 | 6047.93 | 179747.0 |
| 2025-05-19 11:00:00 | ES | Futures | 6047.93 | 6065.97 | 6047.17 | 6058.86 | 103254.0 |
| 2025-05-19 12:00:00 | ES | Futures | 6058.86 | 6076.13 | 6057.08 | 6073.84 | 88512.0 |
| 2025-05-19 13:00:00 | ES | Futures | 6073.84 | 6084.26 | 6071.56 | 6072.07 | 119067.0 |
| 2025-05-19 14:00:00 | ES | Futures | 6072.07 | 6074.1 | 6061.4 | 6072.32 | 99419.0 |
| 2025-05-19 15:00:00 | ES | Futures | 6072.57 | 6081.21 | 6059.11 | 6077.91 | 204406.0 |
| 2025-05-19 16:00:00 | ES | Futures | 6077.91 | 6079.18 | 6066.73 | 6077.15 | 42019.0 |
| 2025-05-19 18:00:00 | ES | Futures | 6076.64 | 6077.91 | 6072.32 | 6076.38 | 7053.0 |
| 2025-05-19 19:00:00 | ES | Futures | 6076.38 | 6090.36 | 6075.37 | 6084.01 | 11635.0 |
| 2025-05-19 20:00:00 | ES | Futures | 6083.75 | 6087.82 | 6078.67 | 6078.67 | 8561.0 |
| 2025-05-19 21:00:00 | ES | Futures | 6078.67 | 6078.67 | 6061.14 | 6065.46 | 10083.0 |
| 2025-05-19 22:00:00 | ES | Futures | 6065.46 | 6068.0 | 6061.65 | 6065.21 | 4819.0 |
| 2025-05-19 23:00:00 | ES | Futures | 6064.95 | 6065.71 | 6060.13 | 6061.14 | 3840.0 |
| 2025-05-19 00:00:00 | NQ | Futures | 21606.78 | 21634.28 | 21599.9 | 21615.95 | 6009.0 |
| 2025-05-19 01:00:00 | NQ | Futures | 21616.2 | 21648.8 | 21607.29 | 21642.43 | 5100.0 |
| 2025-05-19 02:00:00 | NQ | Futures | 21642.94 | 21686.23 | 21580.55 | 21581.82 | 9908.0 |
| 2025-05-19 03:00:00 | NQ | Futures | 21582.59 | 21621.8 | 21556.1 | 21588.95 | 10414.0 |
| 2025-05-19 04:00:00 | NQ | Futures | 21588.44 | 21588.44 | 21505.43 | 21528.6 | 13704.0 |
| 2025-05-19 05:00:00 | NQ | Futures | 21528.09 | 21573.67 | 21510.78 | 21558.65 | 7132.0 |
| 2025-05-19 06:00:00 | NQ | Futures | 21558.9 | 21599.9 | 21523.76 | 21580.55 | 8011.0 |
| 2025-05-19 07:00:00 | NQ | Futures | 21580.8 | 21608.05 | 21554.83 | 21598.89 | 8180.0 |
| 2025-05-19 08:00:00 | NQ | Futures | 21598.63 | 21614.93 | 21558.4 | 21607.03 | 12122.0 |
| 2025-05-19 09:00:00 | NQ | Futures | 21607.29 | 21772.81 | 21546.94 | 21753.71 | 72970.0 |
| 2025-05-19 10:00:00 | NQ | Futures | 21753.71 | 21861.94 | 21745.06 | 21792.17 | 68496.0 |
| 2025-05-19 11:00:00 | NQ | Futures | 21792.17 | 21875.95 | 21777.65 | 21832.66 | 41857.0 |
| 2025-05-19 12:00:00 | NQ | Futures | 21832.91 | 21903.7 | 21827.05 | 21898.61 | 34768.0 |
| 2025-05-19 13:00:00 | NQ | Futures | 21898.36 | 21945.47 | 21893.52 | 21899.38 | 43132.0 |
| 2025-05-19 14:00:00 | NQ | Futures | 21899.38 | 21906.0 | 21848.95 | 21895.81 | 37909.0 |
| 2025-05-19 15:00:00 | NQ | Futures | 21896.32 | 21934.26 | 21842.59 | 21923.82 | 58974.0 |
| 2025-05-19 16:00:00 | NQ | Futures | 21923.57 | 21928.15 | 21877.73 | 21917.46 | 14492.0 |
| 2025-05-19 18:00:00 | NQ | Futures | 21913.38 | 21915.42 | 21893.01 | 21900.14 | 3634.0 |
| 2025-05-19 19:00:00 | NQ | Futures | 21899.88 | 21963.29 | 21897.85 | 21940.12 | 7129.0 |
| 2025-05-19 20:00:00 | NQ | Futures | 21939.87 | 21963.55 | 21913.64 | 21914.4 | 5516.0 |
| 2025-05-19 21:00:00 | NQ | Futures | 21913.64 | 21914.4 | 21835.2 | 21857.36 | 8260.0 |
| 2025-05-19 22:00:00 | NQ | Futures | 21857.36 | 21866.53 | 21833.42 | 21853.79 | 4270.0 |
| 2025-05-19 23:00:00 | NQ | Futures | 21853.03 | 21854.05 | 21826.29 | 21832.91 | 3378.0 |
| 2025-05-19 00:00:00 | YM | Futures | 43647.0 | 43667.6 | 43629.5 | 43641.8 | 733.0 |
| 2025-05-19 01:00:00 | YM | Futures | 43642.9 | 43664.5 | 43625.4 | 43655.2 | 580.0 |
| 2025-05-19 02:00:00 | YM | Futures | 43656.2 | 43679.9 | 43587.3 | 43612.0 | 1620.0 |
| 2025-05-19 03:00:00 | YM | Futures | 43609.9 | 43642.9 | 43582.1 | 43585.2 | 1195.0 |
> showing 50 of 2,072 rows — these rows as CSV