PREVIEW / futures_1hour / 2024-12-23
file: by_date/futures_1hour/2024/2024-12-23.parquet size: 65 KB rows: 2,038
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-23 00:00:00 | ES | Futures | 6182.29 | 6185.88 | 6179.73 | 6185.11 | 4983.0 |
| 2024-12-23 01:00:00 | ES | Futures | 6185.11 | 6186.9 | 6182.8 | 6184.6 | 4672.0 |
| 2024-12-23 02:00:00 | ES | Futures | 6184.85 | 6185.37 | 6176.39 | 6180.24 | 9902.0 |
| 2024-12-23 03:00:00 | ES | Futures | 6180.49 | 6182.29 | 6168.7 | 6173.83 | 15085.0 |
| 2024-12-23 04:00:00 | ES | Futures | 6174.09 | 6177.67 | 6169.73 | 6171.78 | 11488.0 |
| 2024-12-23 05:00:00 | ES | Futures | 6171.52 | 6174.6 | 6158.7 | 6159.47 | 9686.0 |
| 2024-12-23 06:00:00 | ES | Futures | 6159.47 | 6161.01 | 6145.37 | 6148.19 | 14278.0 |
| 2024-12-23 07:00:00 | ES | Futures | 6148.45 | 6162.8 | 6148.45 | 6162.29 | 19143.0 |
| 2024-12-23 08:00:00 | ES | Futures | 6161.78 | 6162.55 | 6135.63 | 6141.78 | 35468.0 |
| 2024-12-23 09:00:00 | ES | Futures | 6142.04 | 6161.52 | 6133.83 | 6146.4 | 189872.0 |
| 2024-12-23 10:00:00 | ES | Futures | 6146.4 | 6148.7 | 6117.17 | 6131.78 | 223267.0 |
| 2024-12-23 11:00:00 | ES | Futures | 6131.53 | 6168.45 | 6130.24 | 6167.68 | 119229.0 |
| 2024-12-23 12:00:00 | ES | Futures | 6167.93 | 6174.09 | 6155.63 | 6168.96 | 119361.0 |
| 2024-12-23 13:00:00 | ES | Futures | 6168.96 | 6183.57 | 6166.91 | 6180.75 | 90441.0 |
| 2024-12-23 14:00:00 | ES | Futures | 6180.75 | 6187.42 | 6172.55 | 6173.06 | 84131.0 |
| 2024-12-23 15:00:00 | ES | Futures | 6172.8 | 6197.16 | 6165.37 | 6190.75 | 243047.0 |
| 2024-12-23 16:00:00 | ES | Futures | 6191.01 | 6195.62 | 6183.83 | 6189.98 | 57050.0 |
| 2024-12-23 18:00:00 | ES | Futures | 6191.78 | 6196.65 | 6187.93 | 6189.98 | 6732.0 |
| 2024-12-23 19:00:00 | ES | Futures | 6190.24 | 6190.49 | 6183.83 | 6189.21 | 4507.0 |
| 2024-12-23 20:00:00 | ES | Futures | 6189.21 | 6190.49 | 6185.88 | 6188.19 | 3649.0 |
| 2024-12-23 21:00:00 | ES | Futures | 6187.93 | 6189.98 | 6186.14 | 6189.47 | 2768.0 |
| 2024-12-23 22:00:00 | ES | Futures | 6189.72 | 6192.03 | 6186.14 | 6188.44 | 2928.0 |
| 2024-12-23 23:00:00 | ES | Futures | 6188.44 | 6189.72 | 6185.88 | 6189.72 | 1319.0 |
| 2024-12-23 00:00:00 | NQ | Futures | 22343.61 | 22369.86 | 22335.63 | 22366.51 | 3326.0 |
| 2024-12-23 01:00:00 | NQ | Futures | 22366.26 | 22380.67 | 22349.27 | 22369.86 | 3941.0 |
| 2024-12-23 02:00:00 | NQ | Futures | 22371.15 | 22374.49 | 22323.28 | 22349.53 | 5420.0 |
| 2024-12-23 03:00:00 | NQ | Futures | 22350.56 | 22358.28 | 22298.06 | 22312.21 | 8716.0 |
| 2024-12-23 04:00:00 | NQ | Futures | 22312.21 | 22330.49 | 22290.34 | 22302.18 | 7775.0 |
| 2024-12-23 05:00:00 | NQ | Futures | 22302.18 | 22316.85 | 22248.14 | 22260.23 | 6065.0 |
| 2024-12-23 06:00:00 | NQ | Futures | 22260.49 | 22265.12 | 22206.96 | 22229.35 | 8432.0 |
| 2024-12-23 07:00:00 | NQ | Futures | 22228.83 | 22308.1 | 22228.83 | 22306.3 | 10317.0 |
| 2024-12-23 08:00:00 | NQ | Futures | 22304.75 | 22309.38 | 22177.36 | 22206.44 | 19315.0 |
| 2024-12-23 09:00:00 | NQ | Futures | 22206.44 | 22312.47 | 22186.37 | 22266.15 | 72841.0 |
| 2024-12-23 10:00:00 | NQ | Futures | 22268.72 | 22276.96 | 22107.88 | 22193.32 | 92724.0 |
| 2024-12-23 11:00:00 | NQ | Futures | 22193.06 | 22333.57 | 22187.66 | 22330.74 | 55679.0 |
| 2024-12-23 12:00:00 | NQ | Futures | 22330.74 | 22364.97 | 22278.24 | 22332.03 | 44990.0 |
| 2024-12-23 13:00:00 | NQ | Futures | 22332.8 | 22395.59 | 22322.51 | 22384.53 | 32754.0 |
| 2024-12-23 14:00:00 | NQ | Futures | 22384.01 | 22416.7 | 22344.13 | 22345.67 | 28534.0 |
| 2024-12-23 15:00:00 | NQ | Futures | 22345.93 | 22407.18 | 22302.69 | 22394.31 | 57190.0 |
| 2024-12-23 16:00:00 | NQ | Futures | 22394.31 | 22408.2 | 22354.16 | 22376.04 | 13653.0 |
| 2024-12-23 18:00:00 | NQ | Futures | 22382.21 | 22401.51 | 22358.02 | 22375.78 | 3038.0 |
| 2024-12-23 19:00:00 | NQ | Futures | 22376.55 | 22378.1 | 22346.96 | 22373.98 | 2857.0 |
| 2024-12-23 20:00:00 | NQ | Futures | 22375.26 | 22386.84 | 22358.54 | 22377.58 | 3341.0 |
| 2024-12-23 21:00:00 | NQ | Futures | 22377.07 | 22391.22 | 22368.83 | 22390.71 | 2034.0 |
| 2024-12-23 22:00:00 | NQ | Futures | 22390.45 | 22399.45 | 22374.49 | 22382.47 | 1777.0 |
| 2024-12-23 23:00:00 | NQ | Futures | 22383.24 | 22391.73 | 22365.23 | 22390.71 | 1767.0 |
| 2024-12-23 00:00:00 | YM | Futures | 44725.7 | 44743.2 | 44715.4 | 44735.0 | 657.0 |
| 2024-12-23 01:00:00 | YM | Futures | 44734.0 | 44741.2 | 44720.6 | 44725.7 | 517.0 |
| 2024-12-23 02:00:00 | YM | Futures | 44729.8 | 44735.0 | 44685.6 | 44696.9 | 1237.0 |
| 2024-12-23 03:00:00 | YM | Futures | 44697.9 | 44699.0 | 44603.2 | 44661.9 | 2017.0 |
> showing 50 of 2,038 rows — these rows as CSV