PREVIEW / futures_1hour / 2024-02-21
file: by_date/futures_1hour/2024/2024-02-21.parquet size: 66 KB rows: 2,080
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-02-21 00:00:00 | ES | Futures | 5355.43 | 5357.04 | 5353.82 | 5356.5 | 3034.0 |
| 2024-02-21 01:00:00 | ES | Futures | 5356.5 | 5360.53 | 5355.97 | 5359.99 | 6323.0 |
| 2024-02-21 02:00:00 | ES | Futures | 5360.26 | 5360.53 | 5357.31 | 5357.58 | 6662.0 |
| 2024-02-21 03:00:00 | ES | Futures | 5357.31 | 5358.11 | 5346.03 | 5346.56 | 18382.0 |
| 2024-02-21 04:00:00 | ES | Futures | 5346.56 | 5351.94 | 5346.03 | 5350.32 | 11893.0 |
| 2024-02-21 05:00:00 | ES | Futures | 5350.06 | 5355.16 | 5349.25 | 5353.01 | 9503.0 |
| 2024-02-21 06:00:00 | ES | Futures | 5352.74 | 5353.82 | 5348.18 | 5351.13 | 9363.0 |
| 2024-02-21 07:00:00 | ES | Futures | 5350.86 | 5354.89 | 5344.15 | 5345.49 | 18960.0 |
| 2024-02-21 08:00:00 | ES | Futures | 5345.49 | 5348.98 | 5342.8 | 5348.71 | 32246.0 |
| 2024-02-21 09:00:00 | ES | Futures | 5348.71 | 5351.13 | 5342.8 | 5346.83 | 173046.0 |
| 2024-02-21 10:00:00 | ES | Futures | 5346.56 | 5355.43 | 5344.15 | 5346.83 | 148804.0 |
| 2024-02-21 11:00:00 | ES | Futures | 5346.56 | 5357.85 | 5346.56 | 5354.35 | 100857.0 |
| 2024-02-21 12:00:00 | ES | Futures | 5354.35 | 5355.16 | 5339.58 | 5349.52 | 113222.0 |
| 2024-02-21 13:00:00 | ES | Futures | 5349.52 | 5351.94 | 5337.16 | 5347.1 | 124383.0 |
| 2024-02-21 14:00:00 | ES | Futures | 5347.1 | 5355.43 | 5331.79 | 5339.31 | 201678.0 |
| 2024-02-21 15:00:00 | ES | Futures | 5339.04 | 5369.93 | 5327.76 | 5367.25 | 277799.0 |
| 2024-02-21 16:00:00 | ES | Futures | 5367.25 | 5393.84 | 5343.07 | 5391.96 | 118994.0 |
| 2024-02-21 18:00:00 | ES | Futures | 5389.0 | 5396.52 | 5388.2 | 5394.91 | 15880.0 |
| 2024-02-21 19:00:00 | ES | Futures | 5394.91 | 5410.49 | 5394.11 | 5407.27 | 20475.0 |
| 2024-02-21 20:00:00 | ES | Futures | 5407.53 | 5409.68 | 5402.7 | 5402.97 | 12869.0 |
| 2024-02-21 21:00:00 | ES | Futures | 5402.97 | 5406.46 | 5400.82 | 5406.46 | 6903.0 |
| 2024-02-21 22:00:00 | ES | Futures | 5406.19 | 5407.53 | 5404.58 | 5405.39 | 4249.0 |
| 2024-02-21 23:00:00 | ES | Futures | 5405.39 | 5407.8 | 5404.58 | 5407.8 | 3268.0 |
| 2024-02-21 00:00:00 | NQ | Futures | 19044.06 | 19053.55 | 19034.29 | 19051.11 | 2454.0 |
| 2024-02-21 01:00:00 | NQ | Futures | 19051.38 | 19065.75 | 19042.16 | 19061.42 | 4202.0 |
| 2024-02-21 02:00:00 | NQ | Futures | 19061.42 | 19077.69 | 19044.87 | 19067.11 | 5361.0 |
| 2024-02-21 03:00:00 | NQ | Futures | 19066.84 | 19071.18 | 18999.58 | 19005.0 | 13803.0 |
| 2024-02-21 04:00:00 | NQ | Futures | 19005.0 | 19027.24 | 19000.39 | 19018.84 | 8387.0 |
| 2024-02-21 05:00:00 | NQ | Futures | 19018.56 | 19043.24 | 19012.6 | 19031.04 | 7262.0 |
| 2024-02-21 06:00:00 | NQ | Futures | 19031.04 | 19035.38 | 18999.58 | 19015.31 | 8722.0 |
| 2024-02-21 07:00:00 | NQ | Futures | 19015.31 | 19026.16 | 18967.04 | 18971.1 | 16549.0 |
| 2024-02-21 08:00:00 | NQ | Futures | 18971.65 | 18995.24 | 18963.24 | 18989.82 | 18951.0 |
| 2024-02-21 09:00:00 | NQ | Futures | 18989.82 | 19000.39 | 18928.25 | 18955.1 | 93813.0 |
| 2024-02-21 10:00:00 | NQ | Futures | 18954.83 | 19012.06 | 18934.76 | 18951.03 | 93919.0 |
| 2024-02-21 11:00:00 | NQ | Futures | 18950.76 | 19005.0 | 18948.05 | 18990.9 | 57258.0 |
| 2024-02-21 12:00:00 | NQ | Futures | 18991.72 | 18993.89 | 18914.15 | 18960.8 | 65471.0 |
| 2024-02-21 13:00:00 | NQ | Futures | 18960.8 | 18969.75 | 18905.74 | 18932.59 | 58742.0 |
| 2024-02-21 14:00:00 | NQ | Futures | 18932.59 | 18970.56 | 18846.35 | 18881.88 | 94402.0 |
| 2024-02-21 15:00:00 | NQ | Futures | 18882.42 | 19030.5 | 18857.2 | 19024.26 | 88874.0 |
| 2024-02-21 16:00:00 | NQ | Futures | 19024.53 | 19226.31 | 18889.2 | 19212.21 | 57759.0 |
| 2024-02-21 18:00:00 | NQ | Futures | 19204.07 | 19210.85 | 19175.32 | 19205.15 | 10599.0 |
| 2024-02-21 19:00:00 | NQ | Futures | 19205.15 | 19296.01 | 19203.8 | 19278.65 | 14598.0 |
| 2024-02-21 20:00:00 | NQ | Futures | 19278.38 | 19305.5 | 19272.41 | 19276.48 | 9201.0 |
| 2024-02-21 21:00:00 | NQ | Futures | 19276.48 | 19304.42 | 19265.63 | 19304.14 | 6163.0 |
| 2024-02-21 22:00:00 | NQ | Futures | 19303.87 | 19312.01 | 19291.13 | 19293.84 | 4242.0 |
| 2024-02-21 23:00:00 | NQ | Futures | 19293.57 | 19308.21 | 19291.4 | 19307.67 | 2293.0 |
| 2024-02-21 00:00:00 | YM | Futures | 41460.5 | 41468.0 | 41450.8 | 41460.5 | 670.0 |
| 2024-02-21 01:00:00 | YM | Futures | 41460.5 | 41490.5 | 41460.5 | 41490.5 | 860.0 |
| 2024-02-21 02:00:00 | YM | Futures | 41490.5 | 41490.5 | 41458.3 | 41458.3 | 1225.0 |
| 2024-02-21 03:00:00 | YM | Futures | 41458.3 | 41464.8 | 41384.2 | 41388.5 | 3443.0 |
> showing 50 of 2,080 rows — these rows as CSV