PREVIEW / futures_1hour / 2024-12-19
file: by_date/futures_1hour/2024/2024-12-19.parquet size: 70 KB rows: 2,129
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-19 00:00:00 | ES | Futures | 6098.71 | 6102.3 | 6087.43 | 6088.46 | 9640.0 |
| 2024-12-19 01:00:00 | ES | Futures | 6088.46 | 6099.22 | 6087.94 | 6095.12 | 11376.0 |
| 2024-12-19 02:00:00 | ES | Futures | 6095.12 | 6115.12 | 6093.84 | 6113.07 | 22903.0 |
| 2024-12-19 03:00:00 | ES | Futures | 6113.07 | 6118.45 | 6105.63 | 6117.68 | 28391.0 |
| 2024-12-19 04:00:00 | ES | Futures | 6117.43 | 6118.96 | 6108.97 | 6117.17 | 28497.0 |
| 2024-12-19 05:00:00 | ES | Futures | 6117.17 | 6124.35 | 6113.32 | 6113.58 | 22112.0 |
| 2024-12-19 06:00:00 | ES | Futures | 6113.58 | 6121.53 | 6111.79 | 6120.76 | 17208.0 |
| 2024-12-19 07:00:00 | ES | Futures | 6120.25 | 6143.06 | 6118.71 | 6142.81 | 40496.0 |
| 2024-12-19 08:00:00 | ES | Futures | 6142.55 | 6145.63 | 6131.53 | 6132.04 | 60009.0 |
| 2024-12-19 09:00:00 | ES | Futures | 6132.04 | 6158.45 | 6125.12 | 6133.06 | 301476.0 |
| 2024-12-19 10:00:00 | ES | Futures | 6133.06 | 6137.17 | 6103.58 | 6123.32 | 325238.0 |
| 2024-12-19 11:00:00 | ES | Futures | 6123.58 | 6140.24 | 6103.33 | 6124.09 | 223600.0 |
| 2024-12-19 12:00:00 | ES | Futures | 6124.09 | 6126.91 | 6099.22 | 6115.63 | 164840.0 |
| 2024-12-19 13:00:00 | ES | Futures | 6115.37 | 6139.22 | 6097.17 | 6138.96 | 148528.0 |
| 2024-12-19 14:00:00 | ES | Futures | 6138.96 | 6139.22 | 6105.12 | 6105.12 | 145086.0 |
| 2024-12-19 15:00:00 | ES | Futures | 6105.38 | 6119.48 | 6083.07 | 6085.64 | 352161.0 |
| 2024-12-19 16:00:00 | ES | Futures | 6085.89 | 6095.38 | 6082.56 | 6092.81 | 94512.0 |
| 2024-12-19 18:00:00 | ES | Futures | 6096.15 | 6096.15 | 6084.1 | 6085.64 | 10716.0 |
| 2024-12-19 19:00:00 | ES | Futures | 6085.89 | 6089.22 | 6063.84 | 6065.89 | 19999.0 |
| 2024-12-19 20:00:00 | ES | Futures | 6066.15 | 6071.28 | 6063.33 | 6064.1 | 10492.0 |
| 2024-12-19 21:00:00 | ES | Futures | 6064.36 | 6064.61 | 6055.9 | 6062.82 | 11118.0 |
| 2024-12-19 22:00:00 | ES | Futures | 6062.82 | 6065.38 | 6052.31 | 6055.64 | 9149.0 |
| 2024-12-19 23:00:00 | ES | Futures | 6055.64 | 6065.12 | 6055.38 | 6064.87 | 8283.0 |
| 2024-12-19 00:00:00 | NQ | Futures | 22115.86 | 22140.82 | 22062.07 | 22070.05 | 5095.0 |
| 2024-12-19 01:00:00 | NQ | Futures | 22069.79 | 22133.62 | 22067.74 | 22118.18 | 5974.0 |
| 2024-12-19 02:00:00 | NQ | Futures | 22118.95 | 22200.78 | 22113.03 | 22194.61 | 13072.0 |
| 2024-12-19 03:00:00 | NQ | Futures | 22195.38 | 22223.69 | 22162.44 | 22222.14 | 11752.0 |
| 2024-12-19 04:00:00 | NQ | Futures | 22221.89 | 22232.44 | 22169.13 | 22201.56 | 12360.0 |
| 2024-12-19 05:00:00 | NQ | Futures | 22202.07 | 22249.68 | 22191.78 | 22198.47 | 8968.0 |
| 2024-12-19 06:00:00 | NQ | Futures | 22198.72 | 22218.03 | 22177.36 | 22209.28 | 7148.0 |
| 2024-12-19 07:00:00 | NQ | Futures | 22208.76 | 22312.99 | 22200.78 | 22312.21 | 18158.0 |
| 2024-12-19 08:00:00 | NQ | Futures | 22311.96 | 22317.88 | 22253.28 | 22259.72 | 18041.0 |
| 2024-12-19 09:00:00 | NQ | Futures | 22258.94 | 22335.38 | 22186.11 | 22212.36 | 103864.0 |
| 2024-12-19 10:00:00 | NQ | Futures | 22212.36 | 22273.87 | 22098.62 | 22184.57 | 105112.0 |
| 2024-12-19 11:00:00 | NQ | Futures | 22184.57 | 22264.35 | 22091.67 | 22196.15 | 66005.0 |
| 2024-12-19 12:00:00 | NQ | Futures | 22195.38 | 22203.61 | 22062.33 | 22151.12 | 52358.0 |
| 2024-12-19 13:00:00 | NQ | Futures | 22151.37 | 22233.72 | 22068.25 | 22232.95 | 48199.0 |
| 2024-12-19 14:00:00 | NQ | Futures | 22231.41 | 22233.21 | 22091.93 | 22092.96 | 54704.0 |
| 2024-12-19 15:00:00 | NQ | Futures | 22093.21 | 22164.24 | 21990.79 | 22004.17 | 92353.0 |
| 2024-12-19 16:00:00 | NQ | Futures | 22004.69 | 22048.95 | 21973.03 | 22037.37 | 21711.0 |
| 2024-12-19 18:00:00 | NQ | Futures | 22058.99 | 22058.99 | 21990.79 | 22002.37 | 6259.0 |
| 2024-12-19 19:00:00 | NQ | Futures | 22003.14 | 22017.04 | 21890.17 | 21903.03 | 14373.0 |
| 2024-12-19 20:00:00 | NQ | Futures | 21903.29 | 21926.97 | 21881.16 | 21895.57 | 8455.0 |
| 2024-12-19 21:00:00 | NQ | Futures | 21895.57 | 21897.89 | 21845.64 | 21878.33 | 7453.0 |
| 2024-12-19 22:00:00 | NQ | Futures | 21878.84 | 21902.78 | 21827.12 | 21843.59 | 6762.0 |
| 2024-12-19 23:00:00 | NQ | Futures | 21843.07 | 21873.44 | 21843.07 | 21871.89 | 4504.0 |
| 2024-12-19 00:00:00 | YM | Futures | 44122.6 | 44141.1 | 44066.0 | 44067.0 | 1471.0 |
| 2024-12-19 01:00:00 | YM | Futures | 44069.1 | 44122.6 | 44062.9 | 44094.8 | 1586.0 |
| 2024-12-19 02:00:00 | YM | Futures | 44096.8 | 44209.0 | 44092.7 | 44197.7 | 3517.0 |
| 2024-12-19 03:00:00 | YM | Futures | 44195.7 | 44224.5 | 44142.1 | 44218.3 | 3898.0 |
> showing 50 of 2,129 rows — these rows as CSV