PREVIEW / futures_1hour / 2025-10-20
file: by_date/futures_1hour/2025/2025-10-20.parquet size: 60 KB rows: 1,886
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-10-20 00:00:00 | ES | Futures | 6773.67 | 6778.96 | 6772.41 | 6777.7 | 5242.0 |
| 2025-10-20 01:00:00 | ES | Futures | 6777.44 | 6782.48 | 6774.42 | 6779.21 | 5931.0 |
| 2025-10-20 02:00:00 | ES | Futures | 6779.21 | 6781.73 | 6773.67 | 6778.2 | 8529.0 |
| 2025-10-20 03:00:00 | ES | Futures | 6778.45 | 6788.02 | 6775.43 | 6781.73 | 13667.0 |
| 2025-10-20 04:00:00 | ES | Futures | 6781.73 | 6782.99 | 6768.88 | 6770.64 | 11368.0 |
| 2025-10-20 05:00:00 | ES | Futures | 6770.39 | 6776.18 | 6767.62 | 6772.91 | 9755.0 |
| 2025-10-20 06:00:00 | ES | Futures | 6773.16 | 6777.44 | 6762.33 | 6763.09 | 12859.0 |
| 2025-10-20 07:00:00 | ES | Futures | 6762.84 | 6775.18 | 6761.83 | 6774.42 | 12250.0 |
| 2025-10-20 08:00:00 | ES | Futures | 6774.17 | 6785.0 | 6771.15 | 6784.5 | 24391.0 |
| 2025-10-20 09:00:00 | ES | Futures | 6784.24 | 6805.4 | 6782.48 | 6798.1 | 161722.0 |
| 2025-10-20 10:00:00 | ES | Futures | 6798.1 | 6826.31 | 6798.1 | 6823.79 | 182156.0 |
| 2025-10-20 11:00:00 | ES | Futures | 6823.54 | 6824.8 | 6812.96 | 6816.99 | 147282.0 |
| 2025-10-20 12:00:00 | ES | Futures | 6817.24 | 6822.53 | 6813.71 | 6822.03 | 98370.0 |
| 2025-10-20 13:00:00 | ES | Futures | 6822.03 | 6832.86 | 6821.77 | 6829.58 | 82010.0 |
| 2025-10-20 14:00:00 | ES | Futures | 6829.58 | 6833.86 | 6823.29 | 6828.07 | 81807.0 |
| 2025-10-20 15:00:00 | ES | Futures | 6828.32 | 6833.36 | 6823.29 | 6824.04 | 180319.0 |
| 2025-10-20 16:00:00 | ES | Futures | 6824.29 | 6831.35 | 6820.77 | 6831.09 | 46763.0 |
| 2025-10-20 18:00:00 | ES | Futures | 6830.34 | 6831.85 | 6827.06 | 6828.32 | 4657.0 |
| 2025-10-20 19:00:00 | ES | Futures | 6828.57 | 6833.61 | 6827.32 | 6828.83 | 4567.0 |
| 2025-10-20 20:00:00 | ES | Futures | 6828.83 | 6832.86 | 6826.81 | 6832.86 | 5090.0 |
| 2025-10-20 21:00:00 | ES | Futures | 6832.6 | 6835.63 | 6829.08 | 6831.35 | 6488.0 |
| 2025-10-20 22:00:00 | ES | Futures | 6831.35 | 6835.88 | 6830.34 | 6831.09 | 4249.0 |
| 2025-10-20 23:00:00 | ES | Futures | 6831.35 | 6832.86 | 6826.56 | 6828.57 | 3806.0 |
| 2025-10-20 00:00:00 | NQ | Futures | 25315.11 | 25339.32 | 25304.27 | 25331.25 | 4715.0 |
| 2025-10-20 01:00:00 | NQ | Futures | 25331.5 | 25347.39 | 25314.61 | 25332.51 | 4194.0 |
| 2025-10-20 02:00:00 | NQ | Futures | 25331.75 | 25345.37 | 25306.54 | 25330.75 | 4788.0 |
| 2025-10-20 03:00:00 | NQ | Futures | 25330.75 | 25372.36 | 25317.88 | 25340.83 | 6486.0 |
| 2025-10-20 04:00:00 | NQ | Futures | 25341.34 | 25352.94 | 25285.6 | 25293.67 | 7165.0 |
| 2025-10-20 05:00:00 | NQ | Futures | 25293.93 | 25318.89 | 25280.81 | 25306.28 | 5391.0 |
| 2025-10-20 06:00:00 | NQ | Futures | 25306.54 | 25322.17 | 25258.87 | 25260.39 | 6826.0 |
| 2025-10-20 07:00:00 | NQ | Futures | 25259.63 | 25309.31 | 25256.85 | 25303.76 | 5056.0 |
| 2025-10-20 08:00:00 | NQ | Futures | 25302.75 | 25351.93 | 25295.19 | 25349.15 | 8589.0 |
| 2025-10-20 09:00:00 | NQ | Futures | 25349.15 | 25460.62 | 25334.28 | 25442.46 | 62894.0 |
| 2025-10-20 10:00:00 | NQ | Futures | 25442.97 | 25543.34 | 25432.12 | 25535.52 | 74478.0 |
| 2025-10-20 11:00:00 | NQ | Futures | 25535.52 | 25567.04 | 25510.3 | 25538.04 | 55061.0 |
| 2025-10-20 12:00:00 | NQ | Futures | 25540.06 | 25549.14 | 25511.81 | 25535.77 | 33773.0 |
| 2025-10-20 13:00:00 | NQ | Futures | 25535.52 | 25576.12 | 25532.75 | 25558.22 | 26643.0 |
| 2025-10-20 14:00:00 | NQ | Futures | 25557.71 | 25574.86 | 25527.7 | 25548.63 | 26778.0 |
| 2025-10-20 15:00:00 | NQ | Futures | 25548.89 | 25557.96 | 25518.12 | 25521.4 | 46599.0 |
| 2025-10-20 16:00:00 | NQ | Futures | 25521.4 | 25549.14 | 25510.81 | 25548.13 | 14922.0 |
| 2025-10-20 18:00:00 | NQ | Futures | 25548.13 | 25551.41 | 25529.22 | 25541.82 | 3202.0 |
| 2025-10-20 19:00:00 | NQ | Futures | 25542.33 | 25566.54 | 25537.79 | 25544.6 | 3844.0 |
| 2025-10-20 20:00:00 | NQ | Futures | 25544.85 | 25564.77 | 25531.99 | 25563.26 | 3442.0 |
| 2025-10-20 21:00:00 | NQ | Futures | 25563.51 | 25580.91 | 25551.41 | 25566.03 | 3193.0 |
| 2025-10-20 22:00:00 | NQ | Futures | 25565.78 | 25589.74 | 25563.76 | 25569.06 | 3138.0 |
| 2025-10-20 23:00:00 | NQ | Futures | 25568.3 | 25577.38 | 25539.55 | 25550.15 | 2921.0 |
| 2025-10-20 00:00:00 | YM | Futures | 47141.0 | 47166.4 | 47133.9 | 47165.3 | 599.0 |
| 2025-10-20 01:00:00 | YM | Futures | 47164.3 | 47198.8 | 47143.0 | 47186.6 | 702.0 |
| 2025-10-20 02:00:00 | YM | Futures | 47184.6 | 47206.9 | 47153.2 | 47188.7 | 926.0 |
| 2025-10-20 03:00:00 | YM | Futures | 47187.7 | 47239.4 | 47171.4 | 47197.8 | 1285.0 |
> showing 50 of 1,886 rows — these rows as CSV