PREVIEW / futures_1hour / 2025-01-22
file: by_date/futures_1hour/2025/2025-01-22.parquet size: 67 KB rows: 2,096
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-01-22 00:00:00 | ES | Futures | 6259.97 | 6259.97 | 6257.92 | 6258.43 | 2182.0 |
| 2025-01-22 01:00:00 | ES | Futures | 6258.69 | 6259.2 | 6254.33 | 6254.59 | 3567.0 |
| 2025-01-22 02:00:00 | ES | Futures | 6254.84 | 6258.43 | 6253.56 | 6255.36 | 6117.0 |
| 2025-01-22 03:00:00 | ES | Futures | 6255.36 | 6265.87 | 6254.59 | 6265.36 | 13569.0 |
| 2025-01-22 04:00:00 | ES | Futures | 6265.36 | 6270.74 | 6264.59 | 6266.64 | 17578.0 |
| 2025-01-22 05:00:00 | ES | Futures | 6266.38 | 6268.69 | 6263.56 | 6267.66 | 8659.0 |
| 2025-01-22 06:00:00 | ES | Futures | 6267.41 | 6271.25 | 6264.59 | 6266.12 | 10488.0 |
| 2025-01-22 07:00:00 | ES | Futures | 6266.38 | 6272.53 | 6265.36 | 6268.43 | 14775.0 |
| 2025-01-22 08:00:00 | ES | Futures | 6268.69 | 6275.1 | 6268.43 | 6274.84 | 22710.0 |
| 2025-01-22 09:00:00 | ES | Futures | 6274.84 | 6278.94 | 6267.15 | 6278.43 | 168480.0 |
| 2025-01-22 10:00:00 | ES | Futures | 6278.43 | 6284.33 | 6273.05 | 6278.43 | 186203.0 |
| 2025-01-22 11:00:00 | ES | Futures | 6278.43 | 6291.51 | 6275.61 | 6289.97 | 134533.0 |
| 2025-01-22 12:00:00 | ES | Futures | 6290.22 | 6292.28 | 6286.64 | 6286.89 | 74022.0 |
| 2025-01-22 13:00:00 | ES | Futures | 6286.89 | 6289.71 | 6283.05 | 6283.56 | 94773.0 |
| 2025-01-22 14:00:00 | ES | Futures | 6283.56 | 6289.71 | 6280.99 | 6289.46 | 96563.0 |
| 2025-01-22 15:00:00 | ES | Futures | 6289.2 | 6289.71 | 6275.61 | 6276.38 | 210584.0 |
| 2025-01-22 16:00:00 | ES | Futures | 6276.12 | 6278.17 | 6271.0 | 6276.38 | 49082.0 |
| 2025-01-22 18:00:00 | ES | Futures | 6276.12 | 6276.12 | 6271.25 | 6272.02 | 13445.0 |
| 2025-01-22 19:00:00 | ES | Futures | 6272.28 | 6274.07 | 6269.97 | 6272.02 | 7869.0 |
| 2025-01-22 20:00:00 | ES | Futures | 6272.02 | 6274.07 | 6268.95 | 6269.71 | 8061.0 |
| 2025-01-22 21:00:00 | ES | Futures | 6269.71 | 6271.25 | 6265.61 | 6269.71 | 4113.0 |
| 2025-01-22 22:00:00 | ES | Futures | 6269.71 | 6272.28 | 6267.66 | 6269.2 | 3716.0 |
| 2025-01-22 23:00:00 | ES | Futures | 6269.46 | 6272.79 | 6268.95 | 6272.28 | 2182.0 |
| 2025-01-22 00:00:00 | NQ | Futures | 22511.66 | 22511.92 | 22496.99 | 22500.33 | 1631.0 |
| 2025-01-22 01:00:00 | NQ | Futures | 22500.85 | 22508.57 | 22481.29 | 22483.35 | 2507.0 |
| 2025-01-22 02:00:00 | NQ | Futures | 22483.61 | 22508.83 | 22481.55 | 22496.22 | 3149.0 |
| 2025-01-22 03:00:00 | NQ | Futures | 22495.96 | 22539.71 | 22492.1 | 22535.08 | 6783.0 |
| 2025-01-22 04:00:00 | NQ | Futures | 22535.08 | 22550.77 | 22519.12 | 22525.81 | 7333.0 |
| 2025-01-22 05:00:00 | NQ | Futures | 22525.3 | 22539.19 | 22511.4 | 22533.79 | 4266.0 |
| 2025-01-22 06:00:00 | NQ | Futures | 22533.28 | 22548.72 | 22526.84 | 22529.16 | 4571.0 |
| 2025-01-22 07:00:00 | NQ | Futures | 22529.93 | 22564.16 | 22522.98 | 22554.38 | 7271.0 |
| 2025-01-22 08:00:00 | NQ | Futures | 22554.38 | 22578.83 | 22547.43 | 22574.45 | 10490.0 |
| 2025-01-22 09:00:00 | NQ | Futures | 22574.97 | 22675.33 | 22542.54 | 22660.92 | 88293.0 |
| 2025-01-22 10:00:00 | NQ | Futures | 22660.66 | 22690.51 | 22621.8 | 22641.1 | 76326.0 |
| 2025-01-22 11:00:00 | NQ | Futures | 22640.85 | 22727.31 | 22635.7 | 22723.45 | 57119.0 |
| 2025-01-22 12:00:00 | NQ | Futures | 22724.48 | 22742.76 | 22693.86 | 22705.44 | 37895.0 |
| 2025-01-22 13:00:00 | NQ | Futures | 22705.44 | 22710.59 | 22657.32 | 22674.56 | 44736.0 |
| 2025-01-22 14:00:00 | NQ | Futures | 22674.82 | 22692.57 | 22653.2 | 22687.94 | 33222.0 |
| 2025-01-22 15:00:00 | NQ | Futures | 22687.94 | 22689.23 | 22627.98 | 22644.19 | 59501.0 |
| 2025-01-22 16:00:00 | NQ | Futures | 22643.93 | 22652.17 | 22613.05 | 22631.07 | 15629.0 |
| 2025-01-22 18:00:00 | NQ | Futures | 22627.72 | 22630.81 | 22603.53 | 22610.99 | 4772.0 |
| 2025-01-22 19:00:00 | NQ | Futures | 22610.99 | 22616.91 | 22588.09 | 22596.07 | 4027.0 |
| 2025-01-22 20:00:00 | NQ | Futures | 22595.81 | 22612.28 | 22589.63 | 22593.24 | 3719.0 |
| 2025-01-22 21:00:00 | NQ | Futures | 22594.01 | 22601.47 | 22570.33 | 22599.67 | 4008.0 |
| 2025-01-22 22:00:00 | NQ | Futures | 22599.16 | 22610.74 | 22587.32 | 22597.1 | 3284.0 |
| 2025-01-22 23:00:00 | NQ | Futures | 22597.61 | 22612.54 | 22596.58 | 22609.19 | 1395.0 |
| 2025-01-22 00:00:00 | YM | Futures | 45555.3 | 45557.4 | 45547.1 | 45551.2 | 249.0 |
| 2025-01-22 01:00:00 | YM | Futures | 45550.2 | 45554.3 | 45521.4 | 45522.4 | 443.0 |
| 2025-01-22 02:00:00 | YM | Futures | 45524.4 | 45544.0 | 45515.2 | 45527.5 | 644.0 |
| 2025-01-22 03:00:00 | YM | Futures | 45527.5 | 45611.9 | 45523.4 | 45599.6 | 1923.0 |
> showing 50 of 2,096 rows — these rows as CSV