PREVIEW / futures_1hour / 2025-08-20
file: by_date/futures_1hour/2025/2025-08-20.parquet size: 64 KB rows: 2,035
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-20 00:00:00 | ES | Futures | 6458.82 | 6463.86 | 6458.57 | 6461.09 | 4323.0 |
| 2025-08-20 01:00:00 | ES | Futures | 6460.84 | 6464.36 | 6457.06 | 6463.61 | 5190.0 |
| 2025-08-20 02:00:00 | ES | Futures | 6463.61 | 6467.39 | 6459.33 | 6465.87 | 7705.0 |
| 2025-08-20 03:00:00 | ES | Futures | 6465.87 | 6473.68 | 6465.37 | 6467.89 | 10148.0 |
| 2025-08-20 04:00:00 | ES | Futures | 6468.14 | 6470.16 | 6460.59 | 6467.64 | 10709.0 |
| 2025-08-20 05:00:00 | ES | Futures | 6467.89 | 6473.68 | 6465.87 | 6472.17 | 8639.0 |
| 2025-08-20 06:00:00 | ES | Futures | 6472.42 | 6475.95 | 6468.9 | 6473.43 | 7595.0 |
| 2025-08-20 07:00:00 | ES | Futures | 6473.18 | 6477.96 | 6466.63 | 6472.42 | 13803.0 |
| 2025-08-20 08:00:00 | ES | Futures | 6472.42 | 6477.96 | 6469.65 | 6475.19 | 22023.0 |
| 2025-08-20 09:00:00 | ES | Futures | 6475.19 | 6478.97 | 6430.86 | 6435.15 | 214717.0 |
| 2025-08-20 10:00:00 | ES | Futures | 6435.15 | 6444.47 | 6410.46 | 6415.0 | 301362.0 |
| 2025-08-20 11:00:00 | ES | Futures | 6415.25 | 6450.76 | 6412.98 | 6432.88 | 228880.0 |
| 2025-08-20 12:00:00 | ES | Futures | 6432.88 | 6456.56 | 6432.38 | 6444.97 | 134162.0 |
| 2025-08-20 13:00:00 | ES | Futures | 6444.72 | 6461.34 | 6442.95 | 6454.04 | 115354.0 |
| 2025-08-20 14:00:00 | ES | Futures | 6454.04 | 6455.3 | 6433.38 | 6448.5 | 140691.0 |
| 2025-08-20 15:00:00 | ES | Futures | 6448.5 | 6472.42 | 6448.24 | 6461.84 | 217997.0 |
| 2025-08-20 16:00:00 | ES | Futures | 6462.1 | 6463.61 | 6459.07 | 6462.6 | 38411.0 |
| 2025-08-20 18:00:00 | ES | Futures | 6462.35 | 6465.87 | 6458.07 | 6459.58 | 7047.0 |
| 2025-08-20 19:00:00 | ES | Futures | 6459.33 | 6460.84 | 6456.05 | 6459.33 | 3453.0 |
| 2025-08-20 20:00:00 | ES | Futures | 6459.07 | 6459.58 | 6449.25 | 6453.53 | 6954.0 |
| 2025-08-20 21:00:00 | ES | Futures | 6453.28 | 6464.87 | 6449.0 | 6464.36 | 6854.0 |
| 2025-08-20 22:00:00 | ES | Futures | 6464.11 | 6467.13 | 6461.84 | 6465.37 | 5321.0 |
| 2025-08-20 23:00:00 | ES | Futures | 6465.37 | 6466.88 | 6461.59 | 6461.84 | 2633.0 |
| 2025-08-20 00:00:00 | NQ | Futures | 23547.82 | 23572.28 | 23546.56 | 23555.39 | 4556.0 |
| 2025-08-20 01:00:00 | NQ | Futures | 23555.14 | 23570.27 | 23537.48 | 23569.01 | 3826.0 |
| 2025-08-20 02:00:00 | NQ | Futures | 23568.5 | 23595.74 | 23547.57 | 23592.46 | 6869.0 |
| 2025-08-20 03:00:00 | NQ | Futures | 23592.21 | 23634.57 | 23589.68 | 23603.3 | 8357.0 |
| 2025-08-20 04:00:00 | NQ | Futures | 23603.3 | 23625.49 | 23574.81 | 23618.18 | 8548.0 |
| 2025-08-20 05:00:00 | NQ | Futures | 23618.68 | 23643.9 | 23610.61 | 23636.59 | 6194.0 |
| 2025-08-20 06:00:00 | NQ | Futures | 23637.35 | 23646.17 | 23607.59 | 23629.28 | 5833.0 |
| 2025-08-20 07:00:00 | NQ | Futures | 23629.02 | 23656.26 | 23589.43 | 23618.18 | 10697.0 |
| 2025-08-20 08:00:00 | NQ | Futures | 23617.17 | 23640.37 | 23600.28 | 23630.79 | 11639.0 |
| 2025-08-20 09:00:00 | NQ | Futures | 23631.04 | 23636.08 | 23347.59 | 23375.08 | 104797.0 |
| 2025-08-20 10:00:00 | NQ | Futures | 23375.84 | 23417.19 | 23235.63 | 23257.82 | 139479.0 |
| 2025-08-20 11:00:00 | NQ | Futures | 23258.32 | 23468.64 | 23246.72 | 23373.57 | 99947.0 |
| 2025-08-20 12:00:00 | NQ | Futures | 23373.06 | 23507.98 | 23370.54 | 23436.36 | 64034.0 |
| 2025-08-20 13:00:00 | NQ | Futures | 23435.86 | 23518.57 | 23427.53 | 23467.13 | 53364.0 |
| 2025-08-20 14:00:00 | NQ | Futures | 23467.13 | 23483.77 | 23392.99 | 23446.19 | 57947.0 |
| 2025-08-20 15:00:00 | NQ | Futures | 23446.19 | 23572.28 | 23446.19 | 23527.9 | 69536.0 |
| 2025-08-20 16:00:00 | NQ | Futures | 23528.4 | 23534.2 | 23510.0 | 23522.1 | 13311.0 |
| 2025-08-20 18:00:00 | NQ | Futures | 23526.13 | 23545.8 | 23516.3 | 23523.11 | 4908.0 |
| 2025-08-20 19:00:00 | NQ | Futures | 23522.86 | 23533.2 | 23508.73 | 23521.6 | 3023.0 |
| 2025-08-20 20:00:00 | NQ | Futures | 23521.6 | 23526.64 | 23471.16 | 23495.12 | 6245.0 |
| 2025-08-20 21:00:00 | NQ | Futures | 23494.36 | 23558.41 | 23469.9 | 23556.9 | 6644.0 |
| 2025-08-20 22:00:00 | NQ | Futures | 23556.4 | 23572.79 | 23544.8 | 23557.91 | 4962.0 |
| 2025-08-20 23:00:00 | NQ | Futures | 23557.66 | 23563.71 | 23539.5 | 23545.3 | 2175.0 |
| 2025-08-20 00:00:00 | YM | Futures | 45835.9 | 45884.9 | 45834.9 | 45871.6 | 569.0 |
| 2025-08-20 01:00:00 | YM | Futures | 45870.6 | 45883.9 | 45844.1 | 45880.8 | 477.0 |
| 2025-08-20 02:00:00 | YM | Futures | 45878.8 | 45892.1 | 45842.0 | 45870.6 | 1244.0 |
| 2025-08-20 03:00:00 | YM | Futures | 45870.6 | 45915.6 | 45866.5 | 45888.0 | 974.0 |
> showing 50 of 2,035 rows — these rows as CSV