PREVIEW / futures_1hour / 2024-12-26
file: by_date/futures_1hour/2024/2024-12-26.parquet size: 52 KB rows: 1,587
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-26 00:00:00 | ES | Futures | 6256.64 | 6259.97 | 6255.87 | 6258.43 | 1918.0 |
| 2024-12-26 01:00:00 | ES | Futures | 6258.69 | 6259.2 | 6254.84 | 6254.84 | 2482.0 |
| 2024-12-26 02:00:00 | ES | Futures | 6255.1 | 6257.92 | 6253.82 | 6256.9 | 2460.0 |
| 2024-12-26 03:00:00 | ES | Futures | 6256.64 | 6256.9 | 6237.92 | 6240.23 | 14465.0 |
| 2024-12-26 04:00:00 | ES | Futures | 6240.23 | 6242.28 | 6229.21 | 6231.26 | 12764.0 |
| 2024-12-26 05:00:00 | ES | Futures | 6231.51 | 6231.51 | 6223.82 | 6228.69 | 9351.0 |
| 2024-12-26 06:00:00 | ES | Futures | 6228.69 | 6232.8 | 6222.28 | 6232.03 | 10405.0 |
| 2024-12-26 07:00:00 | ES | Futures | 6232.03 | 6235.36 | 6229.72 | 6232.8 | 10153.0 |
| 2024-12-26 08:00:00 | ES | Futures | 6232.8 | 6235.36 | 6225.87 | 6231.77 | 18329.0 |
| 2024-12-26 09:00:00 | ES | Futures | 6231.51 | 6241.77 | 6217.93 | 6237.15 | 133192.0 |
| 2024-12-26 10:00:00 | ES | Futures | 6236.9 | 6246.13 | 6231.26 | 6245.87 | 130400.0 |
| 2024-12-26 11:00:00 | ES | Futures | 6245.87 | 6256.9 | 6242.03 | 6256.13 | 79213.0 |
| 2024-12-26 12:00:00 | ES | Futures | 6256.38 | 6263.3 | 6241.0 | 6247.41 | 95134.0 |
| 2024-12-26 13:00:00 | ES | Futures | 6247.41 | 6256.38 | 6245.36 | 6251.25 | 83447.0 |
| 2024-12-26 14:00:00 | ES | Futures | 6251.25 | 6256.13 | 6243.82 | 6255.61 | 64503.0 |
| 2024-12-26 15:00:00 | ES | Futures | 6255.61 | 6259.72 | 6248.43 | 6250.23 | 117420.0 |
| 2024-12-26 16:00:00 | ES | Futures | 6250.23 | 6254.08 | 6246.38 | 6246.9 | 34237.0 |
| 2024-12-26 18:00:00 | ES | Futures | 6247.41 | 6250.74 | 6245.1 | 6250.49 | 3736.0 |
| 2024-12-26 19:00:00 | ES | Futures | 6250.74 | 6250.74 | 6238.18 | 6241.77 | 5437.0 |
| 2024-12-26 20:00:00 | ES | Futures | 6241.77 | 6243.31 | 6238.95 | 6241.51 | 3745.0 |
| 2024-12-26 21:00:00 | ES | Futures | 6241.51 | 6243.05 | 6239.97 | 6240.23 | 2103.0 |
| 2024-12-26 22:00:00 | ES | Futures | 6240.23 | 6241.51 | 6237.67 | 6239.72 | 2972.0 |
| 2024-12-26 23:00:00 | ES | Futures | 6239.72 | 6240.74 | 6237.67 | 6238.44 | 1876.0 |
| 2024-12-26 00:00:00 | NQ | Futures | 22735.55 | 22745.59 | 22724.74 | 22739.41 | 2366.0 |
| 2024-12-26 01:00:00 | NQ | Futures | 22739.41 | 22747.39 | 22723.71 | 22726.03 | 1756.0 |
| 2024-12-26 02:00:00 | NQ | Futures | 22726.03 | 22732.46 | 22713.16 | 22727.57 | 1744.0 |
| 2024-12-26 03:00:00 | NQ | Futures | 22726.03 | 22726.8 | 22603.02 | 22629.01 | 11016.0 |
| 2024-12-26 04:00:00 | NQ | Futures | 22629.52 | 22640.33 | 22566.22 | 22577.8 | 12021.0 |
| 2024-12-26 05:00:00 | NQ | Futures | 22575.99 | 22590.92 | 22537.65 | 22579.08 | 8077.0 |
| 2024-12-26 06:00:00 | NQ | Futures | 22578.31 | 22609.45 | 22561.33 | 22606.36 | 5324.0 |
| 2024-12-26 07:00:00 | NQ | Futures | 22606.62 | 22623.35 | 22575.22 | 22594.27 | 7928.0 |
| 2024-12-26 08:00:00 | NQ | Futures | 22593.75 | 22608.94 | 22551.29 | 22596.07 | 10910.0 |
| 2024-12-26 09:00:00 | NQ | Futures | 22595.04 | 22654.74 | 22512.94 | 22603.02 | 60337.0 |
| 2024-12-26 10:00:00 | NQ | Futures | 22602.24 | 22657.83 | 22572.39 | 22652.94 | 61315.0 |
| 2024-12-26 11:00:00 | NQ | Futures | 22653.71 | 22688.2 | 22621.55 | 22687.43 | 36537.0 |
| 2024-12-26 12:00:00 | NQ | Futures | 22687.43 | 22725.0 | 22618.46 | 22652.17 | 47162.0 |
| 2024-12-26 13:00:00 | NQ | Futures | 22653.2 | 22688.71 | 22641.1 | 22664.01 | 37068.0 |
| 2024-12-26 14:00:00 | NQ | Futures | 22663.75 | 22695.15 | 22640.59 | 22692.06 | 27344.0 |
| 2024-12-26 15:00:00 | NQ | Futures | 22692.32 | 22709.56 | 22647.79 | 22653.71 | 38056.0 |
| 2024-12-26 16:00:00 | NQ | Futures | 22654.23 | 22668.9 | 22625.92 | 22630.29 | 13327.0 |
| 2024-12-26 18:00:00 | NQ | Futures | 22636.99 | 22653.46 | 22620.52 | 22652.43 | 2587.0 |
| 2024-12-26 19:00:00 | NQ | Futures | 22652.68 | 22654.74 | 22599.93 | 22617.94 | 3195.0 |
| 2024-12-26 20:00:00 | NQ | Futures | 22617.94 | 22623.09 | 22595.3 | 22609.19 | 2905.0 |
| 2024-12-26 21:00:00 | NQ | Futures | 22607.39 | 22617.68 | 22599.93 | 22606.36 | 1321.0 |
| 2024-12-26 22:00:00 | NQ | Futures | 22606.88 | 22612.54 | 22587.32 | 22597.1 | 2195.0 |
| 2024-12-26 23:00:00 | NQ | Futures | 22597.1 | 22605.59 | 22588.35 | 22591.44 | 1143.0 |
| 2024-12-26 00:00:00 | YM | Futures | 44895.6 | 44925.4 | 44893.5 | 44919.2 | 265.0 |
| 2024-12-26 01:00:00 | YM | Futures | 44918.2 | 44921.3 | 44891.4 | 44893.5 | 255.0 |
| 2024-12-26 02:00:00 | YM | Futures | 44892.5 | 44926.4 | 44889.4 | 44920.3 | 743.0 |
| 2024-12-26 03:00:00 | YM | Futures | 44918.2 | 44918.2 | 44816.3 | 44826.6 | 1155.0 |
> showing 50 of 1,587 rows — these rows as CSV