PREVIEW / futures_1hour / 2024-10-17
file: by_date/futures_1hour/2024/2024-10-17.parquet size: 66 KB rows: 2,092
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-10-17 00:00:00 | ES | Futures | 6098.02 | 6098.28 | 6095.95 | 6097.5 | 1993.0 |
| 2024-10-17 01:00:00 | ES | Futures | 6097.24 | 6105.81 | 6096.72 | 6104.77 | 5757.0 |
| 2024-10-17 02:00:00 | ES | Futures | 6104.77 | 6120.08 | 6103.73 | 6117.23 | 20237.0 |
| 2024-10-17 03:00:00 | ES | Futures | 6117.49 | 6124.23 | 6115.67 | 6122.68 | 14768.0 |
| 2024-10-17 04:00:00 | ES | Futures | 6122.94 | 6133.58 | 6122.16 | 6133.06 | 15350.0 |
| 2024-10-17 05:00:00 | ES | Futures | 6133.32 | 6137.21 | 6130.46 | 6136.17 | 10187.0 |
| 2024-10-17 06:00:00 | ES | Futures | 6135.91 | 6139.55 | 6133.84 | 6139.03 | 10792.0 |
| 2024-10-17 07:00:00 | ES | Futures | 6138.77 | 6138.77 | 6134.35 | 6135.65 | 11877.0 |
| 2024-10-17 08:00:00 | ES | Futures | 6135.65 | 6145.25 | 6135.13 | 6144.22 | 42427.0 |
| 2024-10-17 09:00:00 | ES | Futures | 6144.22 | 6153.04 | 6120.08 | 6128.65 | 209087.0 |
| 2024-10-17 10:00:00 | ES | Futures | 6128.65 | 6132.28 | 6115.67 | 6118.52 | 188025.0 |
| 2024-10-17 11:00:00 | ES | Futures | 6118.78 | 6135.91 | 6110.74 | 6135.39 | 112236.0 |
| 2024-10-17 12:00:00 | ES | Futures | 6135.39 | 6138.77 | 6125.27 | 6132.28 | 78569.0 |
| 2024-10-17 13:00:00 | ES | Futures | 6132.28 | 6135.65 | 6128.9 | 6132.02 | 66375.0 |
| 2024-10-17 14:00:00 | ES | Futures | 6132.02 | 6132.54 | 6111.52 | 6121.12 | 137695.0 |
| 2024-10-17 15:00:00 | ES | Futures | 6121.12 | 6121.64 | 6108.92 | 6110.48 | 153429.0 |
| 2024-10-17 16:00:00 | ES | Futures | 6110.74 | 6116.71 | 6108.92 | 6111.78 | 58116.0 |
| 2024-10-17 18:00:00 | ES | Futures | 6112.55 | 6118.26 | 6110.48 | 6116.45 | 4468.0 |
| 2024-10-17 19:00:00 | ES | Futures | 6116.19 | 6116.97 | 6114.63 | 6116.19 | 2098.0 |
| 2024-10-17 20:00:00 | ES | Futures | 6115.93 | 6116.19 | 6100.1 | 6108.4 | 10851.0 |
| 2024-10-17 21:00:00 | ES | Futures | 6108.4 | 6112.55 | 6106.85 | 6111.52 | 5467.0 |
| 2024-10-17 22:00:00 | ES | Futures | 6111.52 | 6113.07 | 6108.66 | 6110.74 | 5057.0 |
| 2024-10-17 23:00:00 | ES | Futures | 6110.48 | 6112.04 | 6106.85 | 6108.4 | 3218.0 |
| 2024-10-17 00:00:00 | NQ | Futures | 21182.95 | 21186.08 | 21173.56 | 21182.17 | 1109.0 |
| 2024-10-17 01:00:00 | NQ | Futures | 21182.17 | 21235.91 | 21179.3 | 21229.39 | 4575.0 |
| 2024-10-17 02:00:00 | NQ | Futures | 21230.17 | 21368.2 | 21228.09 | 21322.8 | 16948.0 |
| 2024-10-17 03:00:00 | NQ | Futures | 21323.06 | 21348.37 | 21295.92 | 21340.8 | 8234.0 |
| 2024-10-17 04:00:00 | NQ | Futures | 21340.28 | 21390.11 | 21330.1 | 21386.72 | 8283.0 |
| 2024-10-17 05:00:00 | NQ | Futures | 21387.77 | 21402.12 | 21359.59 | 21385.16 | 5953.0 |
| 2024-10-17 06:00:00 | NQ | Futures | 21384.63 | 21432.64 | 21381.24 | 21425.34 | 6757.0 |
| 2024-10-17 07:00:00 | NQ | Futures | 21424.55 | 21424.82 | 21400.03 | 21413.6 | 6660.0 |
| 2024-10-17 08:00:00 | NQ | Futures | 21413.34 | 21458.21 | 21405.77 | 21456.12 | 18852.0 |
| 2024-10-17 09:00:00 | NQ | Futures | 21456.65 | 21493.7 | 21293.32 | 21326.19 | 96464.0 |
| 2024-10-17 10:00:00 | NQ | Futures | 21326.19 | 21357.5 | 21255.48 | 21290.18 | 89225.0 |
| 2024-10-17 11:00:00 | NQ | Futures | 21290.45 | 21406.29 | 21258.09 | 21403.68 | 50102.0 |
| 2024-10-17 12:00:00 | NQ | Futures | 21403.16 | 21424.82 | 21339.5 | 21360.89 | 40230.0 |
| 2024-10-17 13:00:00 | NQ | Futures | 21360.63 | 21396.11 | 21352.28 | 21371.33 | 26384.0 |
| 2024-10-17 14:00:00 | NQ | Futures | 21371.33 | 21378.11 | 21254.7 | 21323.58 | 59462.0 |
| 2024-10-17 15:00:00 | NQ | Futures | 21323.58 | 21328.02 | 21242.18 | 21252.87 | 54854.0 |
| 2024-10-17 16:00:00 | NQ | Futures | 21252.35 | 21302.97 | 21243.74 | 21273.23 | 14871.0 |
| 2024-10-17 18:00:00 | NQ | Futures | 21273.75 | 21304.53 | 21266.44 | 21298.01 | 2907.0 |
| 2024-10-17 19:00:00 | NQ | Futures | 21298.01 | 21305.58 | 21287.31 | 21295.92 | 1577.0 |
| 2024-10-17 20:00:00 | NQ | Futures | 21296.71 | 21297.49 | 21207.74 | 21249.22 | 7358.0 |
| 2024-10-17 21:00:00 | NQ | Futures | 21248.7 | 21274.79 | 21237.74 | 21268.79 | 3402.0 |
| 2024-10-17 22:00:00 | NQ | Futures | 21269.05 | 21282.1 | 21253.92 | 21267.75 | 3532.0 |
| 2024-10-17 23:00:00 | NQ | Futures | 21267.75 | 21275.31 | 21240.61 | 21250.79 | 2109.0 |
| 2024-10-17 00:00:00 | YM | Futures | 45044.8 | 45049.0 | 45034.4 | 45042.7 | 260.0 |
| 2024-10-17 01:00:00 | YM | Futures | 45040.6 | 45073.9 | 45035.4 | 45057.3 | 580.0 |
| 2024-10-17 02:00:00 | YM | Futures | 45056.2 | 45078.1 | 45016.7 | 45077.1 | 2317.0 |
| 2024-10-17 03:00:00 | YM | Futures | 45076.0 | 45129.1 | 45067.7 | 45118.7 | 1684.0 |
> showing 50 of 2,092 rows — these rows as CSV