PREVIEW / futures_1hour / 2024-12-27
file: by_date/futures_1hour/2024/2024-12-27.parquet size: 56 KB rows: 1,665
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-27 00:00:00 | ES | Futures | 6238.44 | 6241.77 | 6237.67 | 6238.18 | 2484.0 |
| 2024-12-27 01:00:00 | ES | Futures | 6237.92 | 6238.18 | 6232.54 | 6234.33 | 4507.0 |
| 2024-12-27 02:00:00 | ES | Futures | 6234.33 | 6236.39 | 6230.74 | 6232.03 | 3264.0 |
| 2024-12-27 03:00:00 | ES | Futures | 6232.03 | 6233.56 | 6225.36 | 6226.9 | 11970.0 |
| 2024-12-27 04:00:00 | ES | Futures | 6226.64 | 6230.49 | 6225.1 | 6227.16 | 8214.0 |
| 2024-12-27 05:00:00 | ES | Futures | 6227.41 | 6229.21 | 6225.62 | 6228.95 | 6524.0 |
| 2024-12-27 06:00:00 | ES | Futures | 6228.95 | 6231.0 | 6226.64 | 6230.74 | 6457.0 |
| 2024-12-27 07:00:00 | ES | Futures | 6230.49 | 6233.82 | 6228.44 | 6230.23 | 9239.0 |
| 2024-12-27 08:00:00 | ES | Futures | 6230.23 | 6230.49 | 6219.72 | 6221.0 | 23702.0 |
| 2024-12-27 09:00:00 | ES | Futures | 6221.26 | 6222.8 | 6195.36 | 6199.21 | 200464.0 |
| 2024-12-27 10:00:00 | ES | Futures | 6198.95 | 6201.26 | 6150.75 | 6169.21 | 321644.0 |
| 2024-12-27 11:00:00 | ES | Futures | 6168.96 | 6177.16 | 6144.86 | 6148.96 | 183549.0 |
| 2024-12-27 12:00:00 | ES | Futures | 6148.96 | 6153.32 | 6135.37 | 6148.96 | 164258.0 |
| 2024-12-27 13:00:00 | ES | Futures | 6148.96 | 6170.75 | 6146.65 | 6169.21 | 110267.0 |
| 2024-12-27 14:00:00 | ES | Futures | 6168.96 | 6187.67 | 6165.62 | 6184.85 | 125421.0 |
| 2024-12-27 15:00:00 | ES | Futures | 6184.6 | 6185.37 | 6156.14 | 6182.29 | 276368.0 |
| 2024-12-27 16:00:00 | ES | Futures | 6182.55 | 6185.62 | 6180.75 | 6183.06 | 62956.0 |
| 2024-12-27 00:00:00 | NQ | Futures | 22592.46 | 22611.51 | 22591.44 | 22597.1 | 1416.0 |
| 2024-12-27 01:00:00 | NQ | Futures | 22597.35 | 22599.16 | 22570.08 | 22580.88 | 2309.0 |
| 2024-12-27 02:00:00 | NQ | Futures | 22580.63 | 22588.35 | 22563.13 | 22571.62 | 2155.0 |
| 2024-12-27 03:00:00 | NQ | Futures | 22571.36 | 22582.69 | 22545.63 | 22551.03 | 6856.0 |
| 2024-12-27 04:00:00 | NQ | Futures | 22551.8 | 22572.39 | 22541.77 | 22556.18 | 4231.0 |
| 2024-12-27 05:00:00 | NQ | Futures | 22557.21 | 22570.33 | 22552.32 | 22569.82 | 3930.0 |
| 2024-12-27 06:00:00 | NQ | Futures | 22570.08 | 22580.11 | 22555.92 | 22578.31 | 3297.0 |
| 2024-12-27 07:00:00 | NQ | Futures | 22578.57 | 22600.44 | 22578.05 | 22586.55 | 4650.0 |
| 2024-12-27 08:00:00 | NQ | Futures | 22585.52 | 22585.52 | 22528.39 | 22537.65 | 10923.0 |
| 2024-12-27 09:00:00 | NQ | Futures | 22537.65 | 22543.05 | 22312.73 | 22333.57 | 87558.0 |
| 2024-12-27 10:00:00 | NQ | Futures | 22332.8 | 22345.93 | 22139.02 | 22230.64 | 116707.0 |
| 2024-12-27 11:00:00 | NQ | Futures | 22230.38 | 22287.51 | 22157.55 | 22184.57 | 66816.0 |
| 2024-12-27 12:00:00 | NQ | Futures | 22184.06 | 22213.65 | 22130.53 | 22206.19 | 57909.0 |
| 2024-12-27 13:00:00 | NQ | Futures | 22205.67 | 22314.79 | 22189.97 | 22305.78 | 44348.0 |
| 2024-12-27 14:00:00 | NQ | Futures | 22303.46 | 22354.68 | 22271.55 | 22343.61 | 41447.0 |
| 2024-12-27 15:00:00 | NQ | Futures | 22343.35 | 22350.04 | 22241.44 | 22340.78 | 72041.0 |
| 2024-12-27 16:00:00 | NQ | Futures | 22341.04 | 22371.66 | 22339.49 | 22358.02 | 15323.0 |
| 2024-12-27 00:00:00 | YM | Futures | 44913.1 | 44929.5 | 44906.9 | 44907.9 | 263.0 |
| 2024-12-27 01:00:00 | YM | Futures | 44908.9 | 44908.9 | 44882.2 | 44892.5 | 508.0 |
| 2024-12-27 02:00:00 | YM | Futures | 44889.4 | 44913.1 | 44859.5 | 44870.9 | 895.0 |
| 2024-12-27 03:00:00 | YM | Futures | 44870.9 | 44877.0 | 44828.7 | 44844.1 | 1454.0 |
| 2024-12-27 04:00:00 | YM | Futures | 44845.1 | 44869.8 | 44837.9 | 44851.3 | 910.0 |
| 2024-12-27 05:00:00 | YM | Futures | 44851.3 | 44864.7 | 44830.7 | 44846.2 | 992.0 |
| 2024-12-27 06:00:00 | YM | Futures | 44848.2 | 44853.4 | 44833.8 | 44851.3 | 910.0 |
| 2024-12-27 07:00:00 | YM | Futures | 44851.3 | 44863.7 | 44819.4 | 44848.2 | 1250.0 |
| 2024-12-27 08:00:00 | YM | Futures | 44847.2 | 44848.2 | 44781.3 | 44782.3 | 1692.0 |
| 2024-12-27 09:00:00 | YM | Futures | 44782.3 | 44853.4 | 44652.7 | 44824.5 | 14408.0 |
| 2024-12-27 10:00:00 | YM | Futures | 44823.5 | 44834.8 | 44464.3 | 44569.3 | 23956.0 |
| 2024-12-27 11:00:00 | YM | Futures | 44568.3 | 44630.0 | 44383.0 | 44412.8 | 11845.0 |
| 2024-12-27 12:00:00 | YM | Futures | 44412.8 | 44451.9 | 44336.7 | 44413.9 | 11010.0 |
| 2024-12-27 13:00:00 | YM | Futures | 44411.8 | 44556.9 | 44408.7 | 44543.5 | 6974.0 |
| 2024-12-27 14:00:00 | YM | Futures | 44542.5 | 44684.6 | 44520.9 | 44662.9 | 7898.0 |
| 2024-12-27 15:00:00 | YM | Futures | 44664.0 | 44665.0 | 44465.3 | 44618.7 | 14587.0 |
> showing 50 of 1,665 rows — these rows as CSV