PREVIEW / futures_1hour / 2024-09-12
file: by_date/futures_1hour/2024/2024-09-12.parquet size: 64 KB rows: 1,953
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-09-12 00:00:00 | ES | Futures | 5838.13 | 5841.54 | 5837.34 | 5841.01 | 4995.0 |
| 2024-09-12 01:00:00 | ES | Futures | 5840.75 | 5843.37 | 5839.18 | 5841.27 | 6607.0 |
| 2024-09-12 02:00:00 | ES | Futures | 5841.01 | 5844.95 | 5837.34 | 5837.87 | 9236.0 |
| 2024-09-12 03:00:00 | ES | Futures | 5838.13 | 5848.88 | 5836.03 | 5837.6 | 23748.0 |
| 2024-09-12 04:00:00 | ES | Futures | 5837.6 | 5844.42 | 5832.62 | 5840.23 | 17344.0 |
| 2024-09-12 05:00:00 | ES | Futures | 5840.23 | 5847.83 | 5838.65 | 5840.23 | 11108.0 |
| 2024-09-12 06:00:00 | ES | Futures | 5839.96 | 5844.68 | 5838.13 | 5840.23 | 15389.0 |
| 2024-09-12 07:00:00 | ES | Futures | 5839.96 | 5844.16 | 5837.34 | 5843.63 | 17739.0 |
| 2024-09-12 08:00:00 | ES | Futures | 5843.63 | 5853.07 | 5833.41 | 5835.51 | 50169.0 |
| 2024-09-12 09:00:00 | ES | Futures | 5835.51 | 5841.8 | 5809.82 | 5820.56 | 204392.0 |
| 2024-09-12 10:00:00 | ES | Futures | 5820.83 | 5846.78 | 5815.58 | 5827.38 | 266025.0 |
| 2024-09-12 11:00:00 | ES | Futures | 5827.38 | 5850.71 | 5823.19 | 5828.43 | 172644.0 |
| 2024-09-12 12:00:00 | ES | Futures | 5828.43 | 5857.79 | 5826.59 | 5855.69 | 110324.0 |
| 2024-09-12 13:00:00 | ES | Futures | 5855.96 | 5879.29 | 5854.65 | 5877.19 | 136495.0 |
| 2024-09-12 14:00:00 | ES | Futures | 5876.93 | 5879.81 | 5849.4 | 5872.21 | 166933.0 |
| 2024-09-12 15:00:00 | ES | Futures | 5872.47 | 5877.72 | 5866.18 | 5876.14 | 202042.0 |
| 2024-09-12 16:00:00 | ES | Futures | 5876.14 | 5876.4 | 5866.44 | 5868.8 | 63118.0 |
| 2024-09-12 18:00:00 | ES | Futures | 5870.9 | 5876.14 | 5869.59 | 5875.36 | 3411.0 |
| 2024-09-12 19:00:00 | ES | Futures | 5875.36 | 5881.39 | 5875.36 | 5878.24 | 5047.0 |
| 2024-09-12 20:00:00 | ES | Futures | 5878.5 | 5882.43 | 5876.67 | 5879.03 | 5852.0 |
| 2024-09-12 21:00:00 | ES | Futures | 5879.29 | 5879.81 | 5874.83 | 5875.88 | 4724.0 |
| 2024-09-12 22:00:00 | ES | Futures | 5876.14 | 5876.93 | 5871.69 | 5873.0 | 3558.0 |
| 2024-09-12 23:00:00 | ES | Futures | 5872.73 | 5878.5 | 5872.73 | 5877.72 | 3116.0 |
| 2024-09-12 00:00:00 | NQ | Futures | 20387.9 | 20405.85 | 20378.92 | 20393.97 | 2642.0 |
| 2024-09-12 01:00:00 | NQ | Futures | 20393.44 | 20410.34 | 20381.03 | 20390.54 | 3928.0 |
| 2024-09-12 02:00:00 | NQ | Futures | 20390.54 | 20424.59 | 20379.45 | 20382.09 | 6001.0 |
| 2024-09-12 03:00:00 | NQ | Futures | 20382.88 | 20421.16 | 20349.36 | 20360.44 | 12343.0 |
| 2024-09-12 04:00:00 | NQ | Futures | 20360.18 | 20396.34 | 20336.95 | 20378.39 | 7706.0 |
| 2024-09-12 05:00:00 | NQ | Futures | 20376.55 | 20413.5 | 20369.15 | 20373.64 | 5063.0 |
| 2024-09-12 06:00:00 | NQ | Futures | 20374.17 | 20390.01 | 20360.18 | 20367.04 | 4760.0 |
| 2024-09-12 07:00:00 | NQ | Futures | 20366.51 | 20383.41 | 20350.68 | 20378.92 | 6232.0 |
| 2024-09-12 08:00:00 | NQ | Futures | 20378.13 | 20410.6 | 20325.07 | 20336.16 | 25773.0 |
| 2024-09-12 09:00:00 | NQ | Futures | 20336.16 | 20367.57 | 20258.02 | 20334.31 | 90551.0 |
| 2024-09-12 10:00:00 | NQ | Futures | 20334.57 | 20449.4 | 20296.56 | 20358.33 | 96907.0 |
| 2024-09-12 11:00:00 | NQ | Futures | 20358.33 | 20473.16 | 20322.69 | 20343.28 | 65331.0 |
| 2024-09-12 12:00:00 | NQ | Futures | 20342.76 | 20469.2 | 20335.1 | 20465.51 | 43468.0 |
| 2024-09-12 13:00:00 | NQ | Futures | 20464.98 | 20558.17 | 20453.63 | 20554.73 | 44791.0 |
| 2024-09-12 14:00:00 | NQ | Futures | 20555.0 | 20573.21 | 20439.37 | 20542.06 | 52756.0 |
| 2024-09-12 15:00:00 | NQ | Futures | 20541.8 | 20552.89 | 20496.39 | 20539.42 | 52963.0 |
| 2024-09-12 16:00:00 | NQ | Futures | 20539.69 | 20546.81 | 20486.1 | 20499.3 | 17584.0 |
| 2024-09-12 18:00:00 | NQ | Futures | 20505.63 | 20533.61 | 20499.03 | 20530.45 | 1892.0 |
| 2024-09-12 19:00:00 | NQ | Futures | 20529.92 | 20559.49 | 20529.92 | 20541.8 | 2331.0 |
| 2024-09-12 20:00:00 | NQ | Futures | 20542.33 | 20562.92 | 20531.24 | 20544.17 | 3225.0 |
| 2024-09-12 21:00:00 | NQ | Futures | 20544.17 | 20547.34 | 20521.21 | 20530.98 | 2838.0 |
| 2024-09-12 22:00:00 | NQ | Futures | 20531.5 | 20535.46 | 20506.42 | 20511.97 | 2309.0 |
| 2024-09-12 23:00:00 | NQ | Futures | 20511.7 | 20542.33 | 20510.65 | 20537.84 | 2576.0 |
| 2024-09-12 00:00:00 | YM | Futures | 43009.4 | 43026.3 | 43004.2 | 43026.3 | 599.0 |
| 2024-09-12 01:00:00 | YM | Futures | 43027.3 | 43052.5 | 43019.9 | 43044.1 | 845.0 |
| 2024-09-12 02:00:00 | YM | Futures | 43045.2 | 43056.7 | 42996.8 | 42998.9 | 1427.0 |
| 2024-09-12 03:00:00 | YM | Futures | 42997.9 | 43094.6 | 42997.9 | 43042.0 | 2455.0 |
> showing 50 of 1,953 rows — these rows as CSV