PREVIEW / futures_1hour / 2024-11-19
file: by_date/futures_1hour/2024/2024-11-19.parquet size: 69 KB rows: 2,136
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-11-19 00:00:00 | ES | Futures | 6156.41 | 6156.93 | 6152.26 | 6154.08 | 4509.0 |
| 2024-11-19 01:00:00 | ES | Futures | 6154.08 | 6155.38 | 6152.26 | 6153.3 | 4068.0 |
| 2024-11-19 02:00:00 | ES | Futures | 6153.3 | 6155.64 | 6148.37 | 6153.04 | 6522.0 |
| 2024-11-19 03:00:00 | ES | Futures | 6152.78 | 6157.45 | 6129.42 | 6141.1 | 31448.0 |
| 2024-11-19 04:00:00 | ES | Futures | 6141.1 | 6145.51 | 6106.07 | 6114.63 | 62254.0 |
| 2024-11-19 05:00:00 | ES | Futures | 6114.37 | 6125.27 | 6112.04 | 6121.9 | 23760.0 |
| 2024-11-19 06:00:00 | ES | Futures | 6121.64 | 6124.49 | 6113.85 | 6121.12 | 14668.0 |
| 2024-11-19 07:00:00 | ES | Futures | 6121.38 | 6133.32 | 6120.08 | 6131.76 | 25382.0 |
| 2024-11-19 08:00:00 | ES | Futures | 6131.76 | 6132.28 | 6084.27 | 6085.3 | 79287.0 |
| 2024-11-19 09:00:00 | ES | Futures | 6085.3 | 6119.04 | 6078.04 | 6113.07 | 250560.0 |
| 2024-11-19 10:00:00 | ES | Futures | 6112.81 | 6142.92 | 6106.33 | 6138.77 | 244041.0 |
| 2024-11-19 11:00:00 | ES | Futures | 6138.77 | 6154.86 | 6137.73 | 6150.7 | 145172.0 |
| 2024-11-19 12:00:00 | ES | Futures | 6150.7 | 6158.23 | 6142.4 | 6154.6 | 112532.0 |
| 2024-11-19 13:00:00 | ES | Futures | 6154.6 | 6174.06 | 6150.19 | 6172.25 | 116023.0 |
| 2024-11-19 14:00:00 | ES | Futures | 6172.25 | 6173.02 | 6152.78 | 6158.23 | 138360.0 |
| 2024-11-19 15:00:00 | ES | Futures | 6158.23 | 6168.61 | 6155.64 | 6165.24 | 189830.0 |
| 2024-11-19 16:00:00 | ES | Futures | 6165.24 | 6170.95 | 6163.16 | 6163.68 | 48410.0 |
| 2024-11-19 18:00:00 | ES | Futures | 6163.94 | 6172.25 | 6163.16 | 6171.47 | 7217.0 |
| 2024-11-19 19:00:00 | ES | Futures | 6171.73 | 6180.81 | 6170.95 | 6176.66 | 9907.0 |
| 2024-11-19 20:00:00 | ES | Futures | 6176.4 | 6178.73 | 6169.65 | 6172.25 | 8374.0 |
| 2024-11-19 21:00:00 | ES | Futures | 6172.25 | 6177.7 | 6171.21 | 6176.66 | 4882.0 |
| 2024-11-19 22:00:00 | ES | Futures | 6176.4 | 6176.92 | 6168.09 | 6170.95 | 6626.0 |
| 2024-11-19 23:00:00 | ES | Futures | 6170.69 | 6175.1 | 6170.69 | 6174.32 | 4478.0 |
| 2024-11-19 00:00:00 | NQ | Futures | 21585.54 | 21586.84 | 21562.06 | 21571.45 | 3143.0 |
| 2024-11-19 01:00:00 | NQ | Futures | 21571.71 | 21586.84 | 21566.75 | 21579.8 | 2368.0 |
| 2024-11-19 02:00:00 | NQ | Futures | 21580.32 | 21582.93 | 21552.14 | 21575.62 | 3847.0 |
| 2024-11-19 03:00:00 | NQ | Futures | 21575.62 | 21591.28 | 21460.04 | 21529.44 | 15390.0 |
| 2024-11-19 04:00:00 | NQ | Futures | 21529.44 | 21549.53 | 21387.24 | 21437.08 | 26858.0 |
| 2024-11-19 05:00:00 | NQ | Futures | 21437.34 | 21493.7 | 21426.64 | 21477.26 | 13074.0 |
| 2024-11-19 06:00:00 | NQ | Futures | 21477.0 | 21486.39 | 21433.43 | 21478.04 | 9404.0 |
| 2024-11-19 07:00:00 | NQ | Futures | 21479.35 | 21523.7 | 21475.17 | 21513.79 | 13198.0 |
| 2024-11-19 08:00:00 | NQ | Futures | 21514.05 | 21521.87 | 21306.88 | 21313.67 | 30930.0 |
| 2024-11-19 09:00:00 | NQ | Futures | 21313.14 | 21484.56 | 21272.18 | 21451.43 | 86815.0 |
| 2024-11-19 10:00:00 | NQ | Futures | 21451.17 | 21559.19 | 21420.38 | 21537.53 | 71742.0 |
| 2024-11-19 11:00:00 | NQ | Futures | 21537.79 | 21604.32 | 21537.27 | 21571.71 | 52852.0 |
| 2024-11-19 12:00:00 | NQ | Futures | 21571.97 | 21612.93 | 21544.31 | 21598.06 | 37760.0 |
| 2024-11-19 13:00:00 | NQ | Futures | 21598.06 | 21700.08 | 21581.88 | 21691.99 | 42470.0 |
| 2024-11-19 14:00:00 | NQ | Futures | 21691.99 | 21699.56 | 21613.19 | 21645.03 | 48085.0 |
| 2024-11-19 15:00:00 | NQ | Futures | 21644.5 | 21686.77 | 21631.46 | 21671.9 | 49326.0 |
| 2024-11-19 16:00:00 | NQ | Futures | 21671.38 | 21698.77 | 21659.9 | 21660.42 | 13676.0 |
| 2024-11-19 18:00:00 | NQ | Futures | 21668.51 | 21695.12 | 21655.98 | 21689.9 | 3909.0 |
| 2024-11-19 19:00:00 | NQ | Futures | 21690.16 | 21743.65 | 21687.81 | 21721.99 | 7454.0 |
| 2024-11-19 20:00:00 | NQ | Futures | 21721.73 | 21732.17 | 21683.64 | 21697.47 | 7364.0 |
| 2024-11-19 21:00:00 | NQ | Futures | 21697.99 | 21723.3 | 21692.25 | 21717.82 | 4236.0 |
| 2024-11-19 22:00:00 | NQ | Futures | 21718.34 | 21720.95 | 21679.73 | 21692.77 | 4608.0 |
| 2024-11-19 23:00:00 | NQ | Futures | 21694.08 | 21717.3 | 21691.47 | 21709.73 | 3216.0 |
| 2024-11-19 00:00:00 | YM | Futures | 45378.9 | 45378.9 | 45353.9 | 45369.5 | 576.0 |
| 2024-11-19 01:00:00 | YM | Futures | 45368.5 | 45368.5 | 45343.5 | 45346.6 | 600.0 |
| 2024-11-19 02:00:00 | YM | Futures | 45346.6 | 45372.6 | 45317.5 | 45347.7 | 1328.0 |
| 2024-11-19 03:00:00 | YM | Futures | 45346.6 | 45390.3 | 45204.0 | 45268.6 | 4217.0 |
> showing 50 of 2,136 rows — these rows as CSV