PREVIEW / futures_1hour / 2024-12-18
file: by_date/futures_1hour/2024/2024-12-18.parquet size: 69 KB rows: 2,097
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-18 00:00:00 | ES | Futures | 6292.53 | 6293.3 | 6289.46 | 6292.79 | 2311.0 |
| 2024-12-18 01:00:00 | ES | Futures | 6292.79 | 6294.33 | 6288.94 | 6292.79 | 4081.0 |
| 2024-12-18 02:00:00 | ES | Futures | 6292.79 | 6293.3 | 6289.97 | 6291.76 | 3433.0 |
| 2024-12-18 03:00:00 | ES | Futures | 6291.76 | 6296.12 | 6289.46 | 6290.99 | 11809.0 |
| 2024-12-18 04:00:00 | ES | Futures | 6290.99 | 6296.38 | 6288.94 | 6296.12 | 9800.0 |
| 2024-12-18 05:00:00 | ES | Futures | 6296.12 | 6302.53 | 6296.12 | 6301.25 | 10028.0 |
| 2024-12-18 06:00:00 | ES | Futures | 6300.99 | 6302.27 | 6298.94 | 6299.71 | 6176.0 |
| 2024-12-18 07:00:00 | ES | Futures | 6299.71 | 6304.07 | 6298.68 | 6303.56 | 9643.0 |
| 2024-12-18 08:00:00 | ES | Futures | 6303.3 | 6303.3 | 6288.17 | 6288.17 | 26368.0 |
| 2024-12-18 09:00:00 | ES | Futures | 6288.43 | 6289.2 | 6274.59 | 6285.87 | 139909.0 |
| 2024-12-18 10:00:00 | ES | Futures | 6285.61 | 6304.84 | 6284.33 | 6300.22 | 146188.0 |
| 2024-12-18 11:00:00 | ES | Futures | 6300.22 | 6303.56 | 6285.87 | 6297.66 | 153781.0 |
| 2024-12-18 12:00:00 | ES | Futures | 6297.66 | 6302.79 | 6290.74 | 6294.58 | 107463.0 |
| 2024-12-18 13:00:00 | ES | Futures | 6294.84 | 6295.1 | 6289.46 | 6292.53 | 73598.0 |
| 2024-12-18 14:00:00 | ES | Futures | 6292.79 | 6293.3 | 6193.57 | 6197.42 | 487626.0 |
| 2024-12-18 15:00:00 | ES | Futures | 6197.42 | 6202.29 | 6086.15 | 6091.02 | 709243.0 |
| 2024-12-18 16:00:00 | ES | Futures | 6091.02 | 6095.63 | 6057.18 | 6091.02 | 226322.0 |
| 2024-12-18 18:00:00 | ES | Futures | 6101.27 | 6106.91 | 6089.74 | 6092.56 | 28642.0 |
| 2024-12-18 19:00:00 | ES | Futures | 6092.81 | 6105.89 | 6092.04 | 6104.35 | 16959.0 |
| 2024-12-18 20:00:00 | ES | Futures | 6104.61 | 6109.22 | 6094.35 | 6102.56 | 17614.0 |
| 2024-12-18 21:00:00 | ES | Futures | 6102.56 | 6104.09 | 6093.84 | 6095.89 | 12109.0 |
| 2024-12-18 22:00:00 | ES | Futures | 6095.89 | 6100.5 | 6091.02 | 6098.97 | 11549.0 |
| 2024-12-18 23:00:00 | ES | Futures | 6098.71 | 6101.79 | 6096.15 | 6098.97 | 7352.0 |
| 2024-12-18 00:00:00 | NQ | Futures | 22991.35 | 22999.07 | 22978.74 | 22996.76 | 1751.0 |
| 2024-12-18 01:00:00 | NQ | Futures | 22996.24 | 23004.73 | 22970.25 | 22992.9 | 2585.0 |
| 2024-12-18 02:00:00 | NQ | Futures | 22993.41 | 22995.73 | 22975.14 | 22985.95 | 1986.0 |
| 2024-12-18 03:00:00 | NQ | Futures | 22985.43 | 23016.57 | 22984.92 | 22993.15 | 4529.0 |
| 2024-12-18 04:00:00 | NQ | Futures | 22992.38 | 23011.94 | 22969.74 | 23006.28 | 5807.0 |
| 2024-12-18 05:00:00 | NQ | Futures | 23006.54 | 23033.04 | 23003.19 | 23025.84 | 4239.0 |
| 2024-12-18 06:00:00 | NQ | Futures | 23025.58 | 23042.05 | 23016.57 | 23027.9 | 3502.0 |
| 2024-12-18 07:00:00 | NQ | Futures | 23027.38 | 23045.65 | 23019.15 | 23034.59 | 4727.0 |
| 2024-12-18 08:00:00 | NQ | Futures | 23033.81 | 23036.39 | 22939.88 | 22942.71 | 14893.0 |
| 2024-12-18 09:00:00 | NQ | Futures | 22942.71 | 22959.7 | 22863.97 | 22943.49 | 68016.0 |
| 2024-12-18 10:00:00 | NQ | Futures | 22943.49 | 23008.59 | 22927.27 | 22975.65 | 53612.0 |
| 2024-12-18 11:00:00 | NQ | Futures | 22975.4 | 22997.53 | 22903.85 | 22959.96 | 49536.0 |
| 2024-12-18 12:00:00 | NQ | Futures | 22960.73 | 22978.74 | 22931.39 | 22955.07 | 26782.0 |
| 2024-12-18 13:00:00 | NQ | Futures | 22955.58 | 22967.42 | 22927.79 | 22943.49 | 18668.0 |
| 2024-12-18 14:00:00 | NQ | Futures | 22943.49 | 22950.18 | 22546.14 | 22557.21 | 125118.0 |
| 2024-12-18 15:00:00 | NQ | Futures | 22559.01 | 22580.37 | 22059.76 | 22126.92 | 184813.0 |
| 2024-12-18 16:00:00 | NQ | Futures | 22127.44 | 22147.77 | 21937.26 | 22090.12 | 52204.0 |
| 2024-12-18 18:00:00 | NQ | Futures | 22131.56 | 22179.68 | 22084.21 | 22102.99 | 12162.0 |
| 2024-12-18 19:00:00 | NQ | Futures | 22103.25 | 22172.48 | 22099.9 | 22169.9 | 7030.0 |
| 2024-12-18 20:00:00 | NQ | Futures | 22170.42 | 22183.03 | 22104.54 | 22134.65 | 9153.0 |
| 2024-12-18 21:00:00 | NQ | Futures | 22135.16 | 22135.16 | 22084.46 | 22093.47 | 6040.0 |
| 2024-12-18 22:00:00 | NQ | Futures | 22094.24 | 22118.69 | 22057.44 | 22112.51 | 6470.0 |
| 2024-12-18 23:00:00 | NQ | Futures | 22114.06 | 22131.56 | 22099.13 | 22116.37 | 3314.0 |
| 2024-12-18 00:00:00 | YM | Futures | 45344.3 | 45344.3 | 45323.7 | 45339.2 | 334.0 |
| 2024-12-18 01:00:00 | YM | Futures | 45338.1 | 45348.4 | 45315.5 | 45330.9 | 792.0 |
| 2024-12-18 02:00:00 | YM | Futures | 45332.0 | 45352.6 | 45328.9 | 45330.9 | 763.0 |
| 2024-12-18 03:00:00 | YM | Futures | 45328.9 | 45356.7 | 45311.4 | 45322.7 | 1542.0 |
> showing 50 of 2,097 rows — these rows as CSV