PREVIEW / futures_1hour / 2025-09-18
file: by_date/futures_1hour/2025/2025-09-18.parquet size: 65 KB rows: 2,062
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-09-18 00:00:00 | ES | Futures | 6740.42 | 6743.69 | 6738.91 | 6742.94 | 4964.0 |
| 2025-09-18 01:00:00 | ES | Futures | 6742.69 | 6743.69 | 6734.88 | 6736.89 | 6585.0 |
| 2025-09-18 02:00:00 | ES | Futures | 6736.64 | 6740.17 | 6730.09 | 6739.66 | 9960.0 |
| 2025-09-18 03:00:00 | ES | Futures | 6739.66 | 6751.75 | 6738.4 | 6749.74 | 17511.0 |
| 2025-09-18 04:00:00 | ES | Futures | 6749.74 | 6769.38 | 6748.23 | 6768.38 | 24994.0 |
| 2025-09-18 05:00:00 | ES | Futures | 6768.38 | 6770.14 | 6764.35 | 6765.61 | 15748.0 |
| 2025-09-18 06:00:00 | ES | Futures | 6765.61 | 6768.12 | 6757.8 | 6760.57 | 11903.0 |
| 2025-09-18 07:00:00 | ES | Futures | 6760.82 | 6767.37 | 6756.54 | 6760.57 | 20746.0 |
| 2025-09-18 08:00:00 | ES | Futures | 6760.57 | 6762.84 | 6742.94 | 6743.19 | 31907.0 |
| 2025-09-18 09:00:00 | ES | Futures | 6743.44 | 6744.2 | 6720.27 | 6738.91 | 225840.0 |
| 2025-09-18 10:00:00 | ES | Futures | 6738.91 | 6768.38 | 6738.15 | 6745.96 | 231938.0 |
| 2025-09-18 11:00:00 | ES | Futures | 6746.21 | 6758.81 | 6739.91 | 6744.2 | 150525.0 |
| 2025-09-18 12:00:00 | ES | Futures | 6744.2 | 6760.82 | 6741.17 | 6759.31 | 93428.0 |
| 2025-09-18 13:00:00 | ES | Futures | 6759.31 | 6761.32 | 6743.69 | 6746.21 | 103895.0 |
| 2025-09-18 14:00:00 | ES | Futures | 6746.46 | 6754.27 | 6741.68 | 6751.5 | 81149.0 |
| 2025-09-18 15:00:00 | ES | Futures | 6751.5 | 6753.77 | 6738.4 | 6742.43 | 196859.0 |
| 2025-09-18 16:00:00 | ES | Futures | 6742.43 | 6750.49 | 6741.17 | 6748.98 | 50021.0 |
| 2025-09-18 18:00:00 | ES | Futures | 6750.24 | 6755.28 | 6747.47 | 6753.77 | 6674.0 |
| 2025-09-18 19:00:00 | ES | Futures | 6754.02 | 6755.78 | 6752.76 | 6753.26 | 3254.0 |
| 2025-09-18 20:00:00 | ES | Futures | 6753.52 | 6756.03 | 6743.69 | 6746.72 | 7280.0 |
| 2025-09-18 21:00:00 | ES | Futures | 6746.72 | 6751.25 | 6745.46 | 6749.49 | 5339.0 |
| 2025-09-18 22:00:00 | ES | Futures | 6749.49 | 6750.75 | 6744.45 | 6746.72 | 4481.0 |
| 2025-09-18 23:00:00 | ES | Futures | 6746.72 | 6753.26 | 6745.96 | 6747.72 | 5657.0 |
| 2025-09-18 00:00:00 | NQ | Futures | 24851.09 | 24868.99 | 24845.29 | 24861.43 | 3093.0 |
| 2025-09-18 01:00:00 | NQ | Futures | 24860.92 | 24866.22 | 24826.12 | 24830.16 | 3418.0 |
| 2025-09-18 02:00:00 | NQ | Futures | 24829.65 | 24841.0 | 24801.41 | 24839.74 | 5517.0 |
| 2025-09-18 03:00:00 | NQ | Futures | 24839.99 | 24886.39 | 24834.7 | 24878.83 | 7587.0 |
| 2025-09-18 04:00:00 | NQ | Futures | 24879.08 | 24948.94 | 24871.77 | 24943.64 | 10371.0 |
| 2025-09-18 05:00:00 | NQ | Futures | 24944.9 | 24948.43 | 24924.22 | 24934.06 | 5988.0 |
| 2025-09-18 06:00:00 | NQ | Futures | 24933.81 | 24945.66 | 24908.84 | 24922.46 | 5402.0 |
| 2025-09-18 07:00:00 | NQ | Futures | 24922.71 | 24972.14 | 24916.4 | 24958.52 | 11627.0 |
| 2025-09-18 08:00:00 | NQ | Futures | 24958.77 | 24979.2 | 24905.31 | 24905.56 | 13360.0 |
| 2025-09-18 09:00:00 | NQ | Futures | 24906.07 | 24929.27 | 24813.77 | 24912.87 | 92808.0 |
| 2025-09-18 10:00:00 | NQ | Futures | 24912.62 | 25026.11 | 24909.85 | 24950.7 | 84147.0 |
| 2025-09-18 11:00:00 | NQ | Futures | 24950.95 | 25032.91 | 24941.88 | 24952.72 | 60693.0 |
| 2025-09-18 12:00:00 | NQ | Futures | 24952.47 | 25009.97 | 24936.83 | 25004.42 | 35503.0 |
| 2025-09-18 13:00:00 | NQ | Futures | 25004.17 | 25013.5 | 24939.61 | 24950.45 | 39229.0 |
| 2025-09-18 14:00:00 | NQ | Futures | 24950.7 | 24985.5 | 24943.89 | 24972.64 | 36948.0 |
| 2025-09-18 15:00:00 | NQ | Futures | 24972.39 | 24975.16 | 24912.62 | 24914.39 | 59448.0 |
| 2025-09-18 16:00:00 | NQ | Futures | 24914.39 | 24938.85 | 24900.77 | 24929.77 | 16324.0 |
| 2025-09-18 18:00:00 | NQ | Futures | 24933.81 | 24959.28 | 24927.5 | 24954.23 | 4173.0 |
| 2025-09-18 19:00:00 | NQ | Futures | 24953.98 | 24965.08 | 24947.17 | 24956.25 | 2832.0 |
| 2025-09-18 20:00:00 | NQ | Futures | 24955.75 | 24965.33 | 24910.6 | 24926.24 | 5377.0 |
| 2025-09-18 21:00:00 | NQ | Futures | 24925.99 | 24936.83 | 24917.41 | 24932.54 | 3214.0 |
| 2025-09-18 22:00:00 | NQ | Futures | 24932.8 | 24938.85 | 24915.9 | 24928.01 | 2436.0 |
| 2025-09-18 23:00:00 | NQ | Futures | 24928.01 | 24953.73 | 24919.43 | 24928.01 | 4340.0 |
| 2025-09-18 00:00:00 | YM | Futures | 47156.2 | 47178.5 | 47148.1 | 47177.5 | 351.0 |
| 2025-09-18 01:00:00 | YM | Futures | 47174.5 | 47180.6 | 47126.8 | 47154.2 | 504.0 |
| 2025-09-18 02:00:00 | YM | Futures | 47151.1 | 47182.6 | 47109.6 | 47176.5 | 955.0 |
| 2025-09-18 03:00:00 | YM | Futures | 47176.5 | 47256.6 | 47165.3 | 47247.5 | 1509.0 |
> showing 50 of 2,062 rows — these rows as CSV