PREVIEW / futures_1hour / 2025-07-21
file: by_date/futures_1hour/2025/2025-07-21.parquet size: 65 KB rows: 2,034
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-07-21 00:00:00 | ES | Futures | 6387.29 | 6390.82 | 6386.79 | 6390.82 | 1918.0 |
| 2025-07-21 01:00:00 | ES | Futures | 6390.56 | 6391.57 | 6388.8 | 6389.31 | 2321.0 |
| 2025-07-21 02:00:00 | ES | Futures | 6389.31 | 6397.37 | 6388.8 | 6393.84 | 6167.0 |
| 2025-07-21 03:00:00 | ES | Futures | 6393.84 | 6399.13 | 6393.59 | 6396.86 | 6884.0 |
| 2025-07-21 04:00:00 | ES | Futures | 6396.61 | 6402.15 | 6396.61 | 6399.63 | 8428.0 |
| 2025-07-21 05:00:00 | ES | Futures | 6399.63 | 6401.14 | 6398.12 | 6398.88 | 3596.0 |
| 2025-07-21 06:00:00 | ES | Futures | 6399.13 | 6401.65 | 6395.35 | 6398.37 | 6636.0 |
| 2025-07-21 07:00:00 | ES | Futures | 6398.37 | 6399.13 | 6395.6 | 6396.36 | 8999.0 |
| 2025-07-21 08:00:00 | ES | Futures | 6396.61 | 6397.62 | 6389.31 | 6390.06 | 14677.0 |
| 2025-07-21 09:00:00 | ES | Futures | 6389.81 | 6413.23 | 6387.29 | 6412.23 | 124092.0 |
| 2025-07-21 10:00:00 | ES | Futures | 6411.97 | 6420.29 | 6409.96 | 6416.51 | 123288.0 |
| 2025-07-21 11:00:00 | ES | Futures | 6416.51 | 6421.8 | 6415.0 | 6418.27 | 77972.0 |
| 2025-07-21 12:00:00 | ES | Futures | 6418.02 | 6419.53 | 6411.22 | 6418.52 | 78068.0 |
| 2025-07-21 13:00:00 | ES | Futures | 6418.77 | 6421.55 | 6417.01 | 6417.77 | 49508.0 |
| 2025-07-21 14:00:00 | ES | Futures | 6417.52 | 6418.52 | 6408.7 | 6409.2 | 75625.0 |
| 2025-07-21 15:00:00 | ES | Futures | 6409.2 | 6409.71 | 6388.55 | 6392.83 | 240361.0 |
| 2025-07-21 16:00:00 | ES | Futures | 6393.08 | 6396.36 | 6391.32 | 6396.11 | 42173.0 |
| 2025-07-21 18:00:00 | ES | Futures | 6394.59 | 6397.11 | 6393.59 | 6395.1 | 3598.0 |
| 2025-07-21 19:00:00 | ES | Futures | 6395.35 | 6396.61 | 6393.59 | 6395.85 | 2456.0 |
| 2025-07-21 20:00:00 | ES | Futures | 6395.6 | 6399.13 | 6394.85 | 6395.35 | 5007.0 |
| 2025-07-21 21:00:00 | ES | Futures | 6395.35 | 6399.63 | 6394.34 | 6399.13 | 5681.0 |
| 2025-07-21 22:00:00 | ES | Futures | 6399.38 | 6399.63 | 6394.34 | 6394.85 | 2775.0 |
| 2025-07-21 23:00:00 | ES | Futures | 6395.1 | 6396.11 | 6391.32 | 6392.58 | 3829.0 |
| 2025-07-21 00:00:00 | NQ | Futures | 23449.47 | 23473.18 | 23448.72 | 23472.67 | 1708.0 |
| 2025-07-21 01:00:00 | NQ | Futures | 23472.67 | 23478.47 | 23465.11 | 23471.16 | 1993.0 |
| 2025-07-21 02:00:00 | NQ | Futures | 23471.41 | 23497.89 | 23468.39 | 23479.99 | 3964.0 |
| 2025-07-21 03:00:00 | NQ | Futures | 23479.73 | 23501.42 | 23479.48 | 23498.9 | 3776.0 |
| 2025-07-21 04:00:00 | NQ | Futures | 23498.9 | 23511.51 | 23484.78 | 23492.09 | 4879.0 |
| 2025-07-21 05:00:00 | NQ | Futures | 23493.86 | 23501.93 | 23488.31 | 23492.34 | 2088.0 |
| 2025-07-21 06:00:00 | NQ | Futures | 23492.6 | 23508.48 | 23483.77 | 23493.6 | 4176.0 |
| 2025-07-21 07:00:00 | NQ | Futures | 23493.86 | 23495.37 | 23477.72 | 23479.73 | 3749.0 |
| 2025-07-21 08:00:00 | NQ | Futures | 23480.24 | 23486.54 | 23438.38 | 23440.39 | 8479.0 |
| 2025-07-21 09:00:00 | NQ | Futures | 23440.39 | 23599.77 | 23426.02 | 23578.84 | 66829.0 |
| 2025-07-21 10:00:00 | NQ | Futures | 23579.6 | 23628.77 | 23579.6 | 23601.03 | 58970.0 |
| 2025-07-21 11:00:00 | NQ | Futures | 23601.28 | 23608.6 | 23582.37 | 23589.18 | 35742.0 |
| 2025-07-21 12:00:00 | NQ | Futures | 23589.18 | 23614.14 | 23562.2 | 23609.1 | 43025.0 |
| 2025-07-21 13:00:00 | NQ | Futures | 23609.1 | 23627.51 | 23607.84 | 23615.15 | 23728.0 |
| 2025-07-21 14:00:00 | NQ | Futures | 23615.41 | 23621.71 | 23589.94 | 23594.22 | 26779.0 |
| 2025-07-21 15:00:00 | NQ | Futures | 23594.22 | 23596.49 | 23531.68 | 23548.07 | 68869.0 |
| 2025-07-21 16:00:00 | NQ | Futures | 23548.07 | 23557.91 | 23541.52 | 23550.34 | 13399.0 |
| 2025-07-21 18:00:00 | NQ | Futures | 23542.78 | 23556.4 | 23539.25 | 23546.81 | 2003.0 |
| 2025-07-21 19:00:00 | NQ | Futures | 23547.07 | 23553.87 | 23538.74 | 23550.09 | 1880.0 |
| 2025-07-21 20:00:00 | NQ | Futures | 23549.84 | 23564.72 | 23541.27 | 23543.79 | 3379.0 |
| 2025-07-21 21:00:00 | NQ | Futures | 23543.28 | 23570.52 | 23538.24 | 23569.26 | 3990.0 |
| 2025-07-21 22:00:00 | NQ | Futures | 23569.01 | 23569.51 | 23547.32 | 23550.6 | 2373.0 |
| 2025-07-21 23:00:00 | NQ | Futures | 23550.85 | 23552.61 | 23524.12 | 23532.19 | 3680.0 |
| 2025-07-21 00:00:00 | YM | Futures | 45530.4 | 45545.8 | 45527.4 | 45542.7 | 241.0 |
| 2025-07-21 01:00:00 | YM | Futures | 45540.7 | 45545.8 | 45525.3 | 45528.4 | 197.0 |
| 2025-07-21 02:00:00 | YM | Futures | 45530.4 | 45614.2 | 45524.3 | 45584.6 | 1015.0 |
| 2025-07-21 03:00:00 | YM | Futures | 45587.6 | 45640.8 | 45587.6 | 45598.9 | 1295.0 |
> showing 50 of 2,034 rows — these rows as CSV