PREVIEW / futures_1hour / 2024-12-24
file: by_date/futures_1hour/2024/2024-12-24.parquet size: 39 KB rows: 1,111
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-24 00:00:00 | ES | Futures | 6189.47 | 6189.98 | 6186.9 | 6188.19 | 1502.0 |
| 2024-12-24 01:00:00 | ES | Futures | 6188.19 | 6192.29 | 6186.39 | 6190.75 | 2116.0 |
| 2024-12-24 02:00:00 | ES | Futures | 6190.75 | 6196.65 | 6190.24 | 6193.06 | 4895.0 |
| 2024-12-24 03:00:00 | ES | Futures | 6193.31 | 6194.34 | 6187.42 | 6191.78 | 5647.0 |
| 2024-12-24 04:00:00 | ES | Futures | 6191.52 | 6200.24 | 6190.24 | 6198.95 | 5850.0 |
| 2024-12-24 05:00:00 | ES | Futures | 6199.21 | 6200.24 | 6194.85 | 6198.18 | 3917.0 |
| 2024-12-24 06:00:00 | ES | Futures | 6198.18 | 6199.98 | 6191.52 | 6194.85 | 4579.0 |
| 2024-12-24 07:00:00 | ES | Futures | 6194.85 | 6198.18 | 6193.31 | 6197.67 | 6948.0 |
| 2024-12-24 08:00:00 | ES | Futures | 6197.42 | 6200.24 | 6194.85 | 6199.72 | 8991.0 |
| 2024-12-24 09:00:00 | ES | Futures | 6199.72 | 6214.59 | 6196.39 | 6213.57 | 104374.0 |
| 2024-12-24 10:00:00 | ES | Futures | 6213.82 | 6236.39 | 6213.57 | 6234.08 | 128404.0 |
| 2024-12-24 11:00:00 | ES | Futures | 6234.08 | 6240.74 | 6229.98 | 6232.03 | 85673.0 |
| 2024-12-24 12:00:00 | ES | Futures | 6232.03 | 6255.1 | 6230.49 | 6254.08 | 165276.0 |
| 2024-12-24 13:00:00 | ES | Futures | 6254.08 | 6254.84 | 6249.72 | 6254.59 | 31387.0 |
| 2024-12-24 00:00:00 | NQ | Futures | 22390.19 | 22394.05 | 22379.9 | 22385.56 | 1554.0 |
| 2024-12-24 01:00:00 | NQ | Futures | 22385.56 | 22410.78 | 22377.07 | 22404.09 | 1844.0 |
| 2024-12-24 02:00:00 | NQ | Futures | 22404.34 | 22439.09 | 22403.32 | 22413.35 | 4493.0 |
| 2024-12-24 03:00:00 | NQ | Futures | 22414.12 | 22418.76 | 22377.58 | 22402.8 | 4760.0 |
| 2024-12-24 04:00:00 | NQ | Futures | 22402.29 | 22443.98 | 22395.34 | 22438.06 | 4566.0 |
| 2024-12-24 05:00:00 | NQ | Futures | 22438.57 | 22447.84 | 22416.95 | 22438.83 | 3067.0 |
| 2024-12-24 06:00:00 | NQ | Futures | 22439.86 | 22445.78 | 22404.86 | 22425.19 | 3903.0 |
| 2024-12-24 07:00:00 | NQ | Futures | 22425.96 | 22443.72 | 22418.76 | 22439.86 | 4030.0 |
| 2024-12-24 08:00:00 | NQ | Futures | 22438.83 | 22468.42 | 22427.76 | 22467.65 | 6694.0 |
| 2024-12-24 09:00:00 | NQ | Futures | 22467.39 | 22551.29 | 22439.86 | 22547.94 | 50459.0 |
| 2024-12-24 10:00:00 | NQ | Futures | 22546.91 | 22614.08 | 22540.74 | 22606.1 | 63179.0 |
| 2024-12-24 11:00:00 | NQ | Futures | 22606.1 | 22641.1 | 22596.07 | 22607.13 | 38417.0 |
| 2024-12-24 12:00:00 | NQ | Futures | 22607.13 | 22681.76 | 22587.83 | 22679.71 | 45409.0 |
| 2024-12-24 13:00:00 | NQ | Futures | 22679.45 | 22697.72 | 22670.44 | 22694.37 | 9708.0 |
| 2024-12-24 00:00:00 | YM | Futures | 44584.7 | 44587.8 | 44558.0 | 44569.3 | 237.0 |
| 2024-12-24 01:00:00 | YM | Futures | 44568.3 | 44591.9 | 44559.0 | 44580.6 | 309.0 |
| 2024-12-24 02:00:00 | YM | Futures | 44578.5 | 44603.2 | 44575.5 | 44577.5 | 580.0 |
| 2024-12-24 03:00:00 | YM | Futures | 44578.5 | 44582.7 | 44545.6 | 44567.2 | 692.0 |
| 2024-12-24 04:00:00 | YM | Futures | 44563.1 | 44620.7 | 44561.0 | 44615.6 | 846.0 |
| 2024-12-24 05:00:00 | YM | Futures | 44616.6 | 44617.7 | 44590.9 | 44596.0 | 652.0 |
| 2024-12-24 06:00:00 | YM | Futures | 44596.0 | 44609.4 | 44552.8 | 44570.3 | 622.0 |
| 2024-12-24 07:00:00 | YM | Futures | 44566.2 | 44583.7 | 44553.8 | 44579.6 | 993.0 |
| 2024-12-24 08:00:00 | YM | Futures | 44577.5 | 44581.6 | 44553.8 | 44570.3 | 945.0 |
| 2024-12-24 09:00:00 | YM | Futures | 44571.3 | 44609.4 | 44510.6 | 44581.6 | 10726.0 |
| 2024-12-24 10:00:00 | YM | Futures | 44582.7 | 44801.9 | 44582.7 | 44794.7 | 9125.0 |
| 2024-12-24 11:00:00 | YM | Futures | 44794.7 | 44837.9 | 44732.9 | 44775.1 | 5823.0 |
| 2024-12-24 12:00:00 | YM | Futures | 44775.1 | 44941.9 | 44763.8 | 44923.3 | 8053.0 |
| 2024-12-24 13:00:00 | YM | Futures | 44922.3 | 44930.6 | 44891.4 | 44917.2 | 1512.0 |
| 2024-12-24 00:00:00 | CL | Futures | 63.15 | 63.22 | 63.12 | 63.16 | 885.0 |
| 2024-12-24 01:00:00 | CL | Futures | 63.15 | 63.22 | 63.13 | 63.14 | 1000.0 |
| 2024-12-24 02:00:00 | CL | Futures | 63.14 | 63.28 | 63.14 | 63.25 | 1442.0 |
| 2024-12-24 03:00:00 | CL | Futures | 63.25 | 63.43 | 63.24 | 63.36 | 4590.0 |
| 2024-12-24 04:00:00 | CL | Futures | 63.35 | 63.44 | 63.27 | 63.3 | 2844.0 |
| 2024-12-24 05:00:00 | CL | Futures | 63.31 | 63.49 | 63.18 | 63.48 | 3070.0 |
| 2024-12-24 06:00:00 | CL | Futures | 63.47 | 63.55 | 63.39 | 63.4 | 3180.0 |
| 2024-12-24 07:00:00 | CL | Futures | 63.4 | 63.48 | 63.13 | 63.41 | 7418.0 |
> showing 50 of 1,111 rows — these rows as CSV