PREVIEW / futures_1hour / 2025-05-23
file: by_date/futures_1hour/2025/2025-05-23.parquet size: 57 KB rows: 1,668
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-05-23 00:00:00 | ES | Futures | 5957.24 | 5957.24 | 5946.32 | 5948.6 | 3970.0 |
| 2025-05-23 01:00:00 | ES | Futures | 5948.6 | 5955.21 | 5946.82 | 5949.36 | 3953.0 |
| 2025-05-23 02:00:00 | ES | Futures | 5949.11 | 5949.36 | 5936.15 | 5944.79 | 9804.0 |
| 2025-05-23 03:00:00 | ES | Futures | 5944.79 | 5965.11 | 5944.79 | 5961.3 | 12595.0 |
| 2025-05-23 04:00:00 | ES | Futures | 5961.3 | 5966.38 | 5954.7 | 5955.46 | 8624.0 |
| 2025-05-23 05:00:00 | ES | Futures | 5955.46 | 5955.97 | 5937.93 | 5952.67 | 11855.0 |
| 2025-05-23 06:00:00 | ES | Futures | 5952.41 | 5954.44 | 5943.52 | 5951.4 | 7888.0 |
| 2025-05-23 07:00:00 | ES | Futures | 5951.14 | 5953.43 | 5861.47 | 5869.34 | 110279.0 |
| 2025-05-23 08:00:00 | ES | Futures | 5869.34 | 5878.23 | 5849.53 | 5868.07 | 92238.0 |
| 2025-05-23 09:00:00 | ES | Futures | 5868.07 | 5900.33 | 5855.88 | 5886.62 | 225135.0 |
| 2025-05-23 10:00:00 | ES | Futures | 5886.62 | 5908.46 | 5885.09 | 5889.66 | 195045.0 |
| 2025-05-23 11:00:00 | ES | Futures | 5889.66 | 5916.34 | 5886.36 | 5899.06 | 145858.0 |
| 2025-05-23 12:00:00 | ES | Futures | 5899.06 | 5915.32 | 5893.73 | 5908.97 | 108022.0 |
| 2025-05-23 13:00:00 | ES | Futures | 5908.97 | 5934.38 | 5905.92 | 5928.02 | 107392.0 |
| 2025-05-23 14:00:00 | ES | Futures | 5928.02 | 5938.19 | 5919.39 | 5927.01 | 116123.0 |
| 2025-05-23 15:00:00 | ES | Futures | 5927.01 | 5934.38 | 5904.14 | 5911.0 | 219600.0 |
| 2025-05-23 16:00:00 | ES | Futures | 5911.26 | 5911.51 | 5900.84 | 5908.72 | 49958.0 |
| 2025-05-23 00:00:00 | NQ | Futures | 21584.88 | 21584.88 | 21534.46 | 21546.94 | 3147.0 |
| 2025-05-23 01:00:00 | NQ | Futures | 21547.95 | 21575.71 | 21530.13 | 21547.19 | 3786.0 |
| 2025-05-23 02:00:00 | NQ | Futures | 21545.66 | 21548.46 | 21484.8 | 21526.56 | 7109.0 |
| 2025-05-23 03:00:00 | NQ | Futures | 21527.33 | 21614.93 | 21524.02 | 21602.45 | 8242.0 |
| 2025-05-23 04:00:00 | NQ | Futures | 21601.94 | 21626.13 | 21574.69 | 21582.33 | 6047.0 |
| 2025-05-23 05:00:00 | NQ | Futures | 21580.8 | 21586.41 | 21511.03 | 21575.46 | 7572.0 |
| 2025-05-23 06:00:00 | NQ | Futures | 21575.97 | 21585.64 | 21538.28 | 21571.13 | 4935.0 |
| 2025-05-23 07:00:00 | NQ | Futures | 21570.87 | 21577.49 | 21189.15 | 21222.51 | 41577.0 |
| 2025-05-23 08:00:00 | NQ | Futures | 21222.76 | 21227.86 | 21112.75 | 21187.62 | 42541.0 |
| 2025-05-23 09:00:00 | NQ | Futures | 21188.89 | 21343.72 | 21143.06 | 21273.69 | 78543.0 |
| 2025-05-23 10:00:00 | NQ | Futures | 21277.0 | 21384.98 | 21270.38 | 21300.43 | 62180.0 |
| 2025-05-23 11:00:00 | NQ | Futures | 21300.43 | 21399.75 | 21273.95 | 21324.88 | 46481.0 |
| 2025-05-23 12:00:00 | NQ | Futures | 21325.39 | 21396.95 | 21307.05 | 21373.52 | 36582.0 |
| 2025-05-23 13:00:00 | NQ | Futures | 21374.03 | 21466.47 | 21362.06 | 21443.8 | 39553.0 |
| 2025-05-23 14:00:00 | NQ | Futures | 21443.55 | 21475.38 | 21397.2 | 21430.56 | 36130.0 |
| 2025-05-23 15:00:00 | NQ | Futures | 21430.31 | 21461.88 | 21348.82 | 21368.93 | 53510.0 |
| 2025-05-23 16:00:00 | NQ | Futures | 21369.7 | 21371.23 | 21320.3 | 21343.21 | 15378.0 |
| 2025-05-23 00:00:00 | YM | Futures | 43183.9 | 43183.9 | 43124.2 | 43132.4 | 373.0 |
| 2025-05-23 01:00:00 | YM | Futures | 43140.6 | 43175.6 | 43134.5 | 43146.8 | 453.0 |
| 2025-05-23 02:00:00 | YM | Futures | 43143.7 | 43144.8 | 43064.5 | 43118.0 | 1223.0 |
| 2025-05-23 03:00:00 | YM | Futures | 43119.0 | 43252.8 | 43119.0 | 43207.5 | 1451.0 |
| 2025-05-23 04:00:00 | YM | Futures | 43207.5 | 43235.3 | 43166.4 | 43171.5 | 1226.0 |
| 2025-05-23 05:00:00 | YM | Futures | 43168.4 | 43170.5 | 43025.4 | 43131.4 | 1618.0 |
| 2025-05-23 06:00:00 | YM | Futures | 43131.4 | 43146.8 | 43071.7 | 43119.0 | 1227.0 |
| 2025-05-23 07:00:00 | YM | Futures | 43118.0 | 43130.3 | 42536.5 | 42589.0 | 11975.0 |
| 2025-05-23 08:00:00 | YM | Futures | 42588.0 | 42677.5 | 42438.7 | 42606.5 | 10703.0 |
| 2025-05-23 09:00:00 | YM | Futures | 42606.5 | 42813.4 | 42501.5 | 42757.8 | 16532.0 |
| 2025-05-23 10:00:00 | YM | Futures | 42767.0 | 42908.0 | 42756.8 | 42760.9 | 9034.0 |
| 2025-05-23 11:00:00 | YM | Futures | 42767.0 | 42958.5 | 42751.6 | 42817.5 | 5795.0 |
| 2025-05-23 12:00:00 | YM | Futures | 42822.6 | 42929.7 | 42783.5 | 42883.3 | 4835.0 |
| 2025-05-23 13:00:00 | YM | Futures | 42885.4 | 43059.3 | 42866.9 | 43012.0 | 4703.0 |
| 2025-05-23 14:00:00 | YM | Futures | 43012.0 | 43077.9 | 42957.4 | 43009.9 | 3904.0 |
| 2025-05-23 15:00:00 | YM | Futures | 43012.0 | 43061.4 | 42838.1 | 42888.5 | 8548.0 |
> showing 50 of 1,668 rows — these rows as CSV