PREVIEW / futures_1hour / 2024-01-02
file: by_date/futures_1hour/2024/2024-01-02.parquet size: 67 KB rows: 2,043
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-01-02 00:00:00 | ES | Futures | 5179.23 | 5182.19 | 5179.23 | 5180.84 | 4562.0 |
| 2024-01-02 01:00:00 | ES | Futures | 5181.11 | 5181.11 | 5178.16 | 5178.43 | 4434.0 |
| 2024-01-02 02:00:00 | ES | Futures | 5178.7 | 5182.72 | 5178.7 | 5180.84 | 7001.0 |
| 2024-01-02 03:00:00 | ES | Futures | 5181.11 | 5187.02 | 5180.84 | 5185.41 | 16755.0 |
| 2024-01-02 04:00:00 | ES | Futures | 5185.41 | 5185.68 | 5173.05 | 5174.67 | 16685.0 |
| 2024-01-02 05:00:00 | ES | Futures | 5174.4 | 5176.01 | 5170.64 | 5171.17 | 18401.0 |
| 2024-01-02 06:00:00 | ES | Futures | 5171.17 | 5171.17 | 5142.17 | 5147.81 | 48438.0 |
| 2024-01-02 07:00:00 | ES | Futures | 5147.81 | 5148.08 | 5133.57 | 5134.38 | 31973.0 |
| 2024-01-02 08:00:00 | ES | Futures | 5134.38 | 5141.09 | 5133.03 | 5138.41 | 43053.0 |
| 2024-01-02 09:00:00 | ES | Futures | 5138.14 | 5145.93 | 5129.01 | 5138.94 | 261972.0 |
| 2024-01-02 10:00:00 | ES | Futures | 5138.68 | 5143.78 | 5128.2 | 5132.5 | 208555.0 |
| 2024-01-02 11:00:00 | ES | Futures | 5132.5 | 5150.49 | 5131.69 | 5148.88 | 148931.0 |
| 2024-01-02 12:00:00 | ES | Futures | 5149.15 | 5154.25 | 5142.44 | 5142.97 | 123853.0 |
| 2024-01-02 13:00:00 | ES | Futures | 5143.24 | 5146.73 | 5136.26 | 5137.6 | 114524.0 |
| 2024-01-02 14:00:00 | ES | Futures | 5137.6 | 5138.94 | 5124.44 | 5124.44 | 120276.0 |
| 2024-01-02 15:00:00 | ES | Futures | 5124.44 | 5144.58 | 5119.87 | 5144.05 | 282062.0 |
| 2024-01-02 16:00:00 | ES | Futures | 5144.05 | 5145.66 | 5141.09 | 5144.58 | 53185.0 |
| 2024-01-02 18:00:00 | ES | Futures | 5147.0 | 5147.0 | 5142.7 | 5144.58 | 4356.0 |
| 2024-01-02 19:00:00 | ES | Futures | 5144.85 | 5145.39 | 5141.63 | 5142.17 | 3710.0 |
| 2024-01-02 20:00:00 | ES | Futures | 5142.17 | 5143.51 | 5141.09 | 5142.17 | 5613.0 |
| 2024-01-02 21:00:00 | ES | Futures | 5142.44 | 5142.97 | 5140.02 | 5140.82 | 4362.0 |
| 2024-01-02 22:00:00 | ES | Futures | 5141.09 | 5141.9 | 5140.02 | 5140.56 | 3058.0 |
| 2024-01-02 23:00:00 | ES | Futures | 5140.29 | 5140.82 | 5138.94 | 5139.21 | 3694.0 |
| 2024-01-02 00:00:00 | NQ | Futures | 18450.66 | 18462.59 | 18449.3 | 18461.24 | 2232.0 |
| 2024-01-02 01:00:00 | NQ | Futures | 18460.97 | 18463.14 | 18445.24 | 18446.86 | 2096.0 |
| 2024-01-02 02:00:00 | NQ | Futures | 18446.59 | 18467.2 | 18446.59 | 18460.7 | 4035.0 |
| 2024-01-02 03:00:00 | NQ | Futures | 18460.97 | 18481.85 | 18459.34 | 18471.54 | 5498.0 |
| 2024-01-02 04:00:00 | NQ | Futures | 18471.54 | 18472.9 | 18428.96 | 18436.02 | 8051.0 |
| 2024-01-02 05:00:00 | NQ | Futures | 18436.02 | 18439.27 | 18407.54 | 18410.52 | 6528.0 |
| 2024-01-02 06:00:00 | NQ | Futures | 18410.25 | 18416.49 | 18274.11 | 18306.11 | 22200.0 |
| 2024-01-02 07:00:00 | NQ | Futures | 18306.65 | 18309.63 | 18243.46 | 18250.51 | 16517.0 |
| 2024-01-02 08:00:00 | NQ | Futures | 18249.97 | 18285.22 | 18243.46 | 18282.51 | 20061.0 |
| 2024-01-02 09:00:00 | NQ | Futures | 18282.51 | 18309.36 | 18137.69 | 18185.42 | 101991.0 |
| 2024-01-02 10:00:00 | NQ | Futures | 18185.42 | 18213.08 | 18100.26 | 18127.93 | 94465.0 |
| 2024-01-02 11:00:00 | NQ | Futures | 18128.2 | 18209.29 | 18126.3 | 18201.42 | 63112.0 |
| 2024-01-02 12:00:00 | NQ | Futures | 18201.15 | 18211.73 | 18135.79 | 18138.23 | 52066.0 |
| 2024-01-02 13:00:00 | NQ | Futures | 18138.5 | 18162.1 | 18103.79 | 18112.2 | 49670.0 |
| 2024-01-02 14:00:00 | NQ | Futures | 18112.74 | 18124.67 | 18066.36 | 18067.72 | 54751.0 |
| 2024-01-02 15:00:00 | NQ | Futures | 18067.45 | 18144.74 | 18032.46 | 18139.32 | 95834.0 |
| 2024-01-02 16:00:00 | NQ | Futures | 18139.32 | 18156.13 | 18131.72 | 18150.98 | 15888.0 |
| 2024-01-02 18:00:00 | NQ | Futures | 18156.4 | 18156.94 | 18134.71 | 18143.38 | 3472.0 |
| 2024-01-02 19:00:00 | NQ | Futures | 18143.11 | 18147.99 | 18132.81 | 18134.43 | 3030.0 |
| 2024-01-02 20:00:00 | NQ | Futures | 18134.71 | 18139.32 | 18124.67 | 18129.28 | 4019.0 |
| 2024-01-02 21:00:00 | NQ | Futures | 18128.74 | 18132.54 | 18116.54 | 18119.52 | 2982.0 |
| 2024-01-02 22:00:00 | NQ | Futures | 18119.79 | 18126.57 | 18118.16 | 18120.33 | 2060.0 |
| 2024-01-02 23:00:00 | NQ | Futures | 18120.06 | 18121.42 | 18109.21 | 18110.84 | 2368.0 |
| 2024-01-02 00:00:00 | YM | Futures | 40852.5 | 40874.0 | 40852.5 | 40860.1 | 844.0 |
| 2024-01-02 01:00:00 | YM | Futures | 40860.1 | 40861.1 | 40844.0 | 40850.4 | 820.0 |
| 2024-01-02 02:00:00 | YM | Futures | 40851.5 | 40883.7 | 40849.3 | 40862.2 | 1334.0 |
| 2024-01-02 03:00:00 | YM | Futures | 40863.3 | 40936.3 | 40863.3 | 40931.0 | 2943.0 |
> showing 50 of 2,043 rows — these rows as CSV