PREVIEW / futures_1hour / 2025-08-19
file: by_date/futures_1hour/2025/2025-08-19.parquet size: 65 KB rows: 2,054
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-08-19 00:00:00 | ES | Futures | 6508.69 | 6508.69 | 6505.17 | 6507.43 | 3363.0 |
| 2025-08-19 01:00:00 | ES | Futures | 6507.69 | 6508.95 | 6502.4 | 6503.66 | 4030.0 |
| 2025-08-19 02:00:00 | ES | Futures | 6503.4 | 6509.2 | 6503.15 | 6507.94 | 4218.0 |
| 2025-08-19 03:00:00 | ES | Futures | 6507.94 | 6510.46 | 6505.17 | 6508.69 | 6073.0 |
| 2025-08-19 04:00:00 | ES | Futures | 6508.69 | 6513.98 | 6506.43 | 6513.73 | 5801.0 |
| 2025-08-19 05:00:00 | ES | Futures | 6513.73 | 6517.51 | 6512.72 | 6514.23 | 5594.0 |
| 2025-08-19 06:00:00 | ES | Futures | 6514.49 | 6514.49 | 6507.94 | 6509.95 | 9427.0 |
| 2025-08-19 07:00:00 | ES | Futures | 6509.7 | 6516.25 | 6509.45 | 6515.75 | 9019.0 |
| 2025-08-19 08:00:00 | ES | Futures | 6515.49 | 6517.26 | 6510.96 | 6511.72 | 15323.0 |
| 2025-08-19 09:00:00 | ES | Futures | 6511.72 | 6518.01 | 6503.15 | 6512.22 | 131632.0 |
| 2025-08-19 10:00:00 | ES | Futures | 6512.22 | 6524.81 | 6494.84 | 6495.09 | 247106.0 |
| 2025-08-19 11:00:00 | ES | Futures | 6495.09 | 6502.14 | 6487.28 | 6490.56 | 143372.0 |
| 2025-08-19 12:00:00 | ES | Futures | 6490.31 | 6494.34 | 6475.95 | 6479.48 | 130157.0 |
| 2025-08-19 13:00:00 | ES | Futures | 6479.48 | 6484.01 | 6470.66 | 6480.99 | 107177.0 |
| 2025-08-19 14:00:00 | ES | Futures | 6480.99 | 6481.74 | 6469.4 | 6473.93 | 84879.0 |
| 2025-08-19 15:00:00 | ES | Futures | 6474.19 | 6482.5 | 6467.39 | 6480.99 | 190471.0 |
| 2025-08-19 16:00:00 | ES | Futures | 6480.99 | 6484.77 | 6480.74 | 6483.25 | 43793.0 |
| 2025-08-19 18:00:00 | ES | Futures | 6481.24 | 6486.28 | 6477.96 | 6480.48 | 6240.0 |
| 2025-08-19 19:00:00 | ES | Futures | 6480.48 | 6482.5 | 6472.42 | 6475.45 | 6562.0 |
| 2025-08-19 20:00:00 | ES | Futures | 6475.7 | 6475.7 | 6470.41 | 6473.18 | 7266.0 |
| 2025-08-19 21:00:00 | ES | Futures | 6472.93 | 6475.7 | 6465.62 | 6466.88 | 11365.0 |
| 2025-08-19 22:00:00 | ES | Futures | 6466.63 | 6468.9 | 6463.61 | 6467.64 | 5374.0 |
| 2025-08-19 23:00:00 | ES | Futures | 6467.64 | 6468.39 | 6457.31 | 6458.57 | 7507.0 |
| 2025-08-19 00:00:00 | NQ | Futures | 23961.14 | 23968.2 | 23945.25 | 23964.67 | 2915.0 |
| 2025-08-19 01:00:00 | NQ | Futures | 23964.67 | 23970.72 | 23937.44 | 23942.98 | 3049.0 |
| 2025-08-19 02:00:00 | NQ | Futures | 23942.23 | 23974.0 | 23940.71 | 23970.22 | 2863.0 |
| 2025-08-19 03:00:00 | NQ | Futures | 23969.97 | 23979.3 | 23954.58 | 23977.53 | 3589.0 |
| 2025-08-19 04:00:00 | NQ | Futures | 23977.03 | 23994.93 | 23952.31 | 23993.92 | 4295.0 |
| 2025-08-19 05:00:00 | NQ | Futures | 23993.67 | 24012.08 | 23988.88 | 23994.43 | 3893.0 |
| 2025-08-19 06:00:00 | NQ | Futures | 23994.93 | 23997.96 | 23957.86 | 23970.72 | 6398.0 |
| 2025-08-19 07:00:00 | NQ | Futures | 23970.47 | 23984.85 | 23961.39 | 23982.32 | 4713.0 |
| 2025-08-19 08:00:00 | NQ | Futures | 23981.57 | 23990.14 | 23945.76 | 23950.8 | 10370.0 |
| 2025-08-19 09:00:00 | NQ | Futures | 23950.8 | 23977.53 | 23844.38 | 23884.98 | 86463.0 |
| 2025-08-19 10:00:00 | NQ | Futures | 23884.48 | 23935.42 | 23745.02 | 23745.78 | 105290.0 |
| 2025-08-19 11:00:00 | NQ | Futures | 23746.03 | 23794.96 | 23719.3 | 23764.44 | 59730.0 |
| 2025-08-19 12:00:00 | NQ | Futures | 23763.94 | 23783.1 | 23677.19 | 23686.77 | 60669.0 |
| 2025-08-19 13:00:00 | NQ | Futures | 23687.28 | 23722.08 | 23649.2 | 23711.74 | 49799.0 |
| 2025-08-19 14:00:00 | NQ | Futures | 23711.74 | 23712.75 | 23648.44 | 23666.6 | 45051.0 |
| 2025-08-19 15:00:00 | NQ | Futures | 23666.35 | 23681.48 | 23630.03 | 23674.67 | 62469.0 |
| 2025-08-19 16:00:00 | NQ | Futures | 23675.42 | 23692.07 | 23667.86 | 23677.95 | 16520.0 |
| 2025-08-19 18:00:00 | NQ | Futures | 23665.34 | 23690.05 | 23654.24 | 23662.56 | 4645.0 |
| 2025-08-19 19:00:00 | NQ | Futures | 23662.56 | 23671.89 | 23617.42 | 23626.0 | 5782.0 |
| 2025-08-19 20:00:00 | NQ | Futures | 23627.26 | 23628.01 | 23600.53 | 23619.19 | 6674.0 |
| 2025-08-19 21:00:00 | NQ | Futures | 23617.93 | 23628.77 | 23571.27 | 23581.36 | 8621.0 |
| 2025-08-19 22:00:00 | NQ | Futures | 23582.87 | 23598.51 | 23571.53 | 23596.24 | 3789.0 |
| 2025-08-19 23:00:00 | NQ | Futures | 23595.99 | 23599.27 | 23539.75 | 23548.58 | 5950.0 |
| 2025-08-19 00:00:00 | YM | Futures | 45918.6 | 45918.6 | 45896.2 | 45905.4 | 408.0 |
| 2025-08-19 01:00:00 | YM | Futures | 45906.4 | 45914.5 | 45875.7 | 45885.9 | 495.0 |
| 2025-08-19 02:00:00 | YM | Futures | 45884.9 | 45915.6 | 45882.9 | 45893.1 | 611.0 |
| 2025-08-19 03:00:00 | YM | Futures | 45896.2 | 45917.6 | 45884.9 | 45901.3 | 639.0 |
> showing 50 of 2,054 rows — these rows as CSV