PREVIEW / futures_1hour / 2024-01-18
file: by_date/futures_1hour/2024/2024-01-18.parquet size: 67 KB rows: 2,068
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-18 00:00:00 | ES | Futures | 5120.14 | 5124.44 | 5119.34 | 5123.9 | 4579.0 |
| 2024-01-18 01:00:00 | ES | Futures | 5123.63 | 5127.66 | 5123.37 | 5126.59 | 10676.0 |
| 2024-01-18 02:00:00 | ES | Futures | 5126.59 | 5127.93 | 5122.29 | 5126.86 | 10886.0 |
| 2024-01-18 03:00:00 | ES | Futures | 5126.59 | 5129.81 | 5124.71 | 5127.66 | 28335.0 |
| 2024-01-18 04:00:00 | ES | Futures | 5127.39 | 5133.03 | 5126.59 | 5129.27 | 22593.0 |
| 2024-01-18 05:00:00 | ES | Futures | 5129.01 | 5135.99 | 5126.32 | 5135.45 | 15312.0 |
| 2024-01-18 06:00:00 | ES | Futures | 5135.72 | 5144.58 | 5135.45 | 5143.51 | 25890.0 |
| 2024-01-18 07:00:00 | ES | Futures | 5143.51 | 5149.42 | 5143.51 | 5145.39 | 28352.0 |
| 2024-01-18 08:00:00 | ES | Futures | 5145.66 | 5154.25 | 5138.14 | 5138.68 | 58423.0 |
| 2024-01-18 09:00:00 | ES | Futures | 5138.94 | 5148.88 | 5135.18 | 5140.29 | 196658.0 |
| 2024-01-18 10:00:00 | ES | Futures | 5140.29 | 5151.57 | 5135.18 | 5144.58 | 229565.0 |
| 2024-01-18 11:00:00 | ES | Futures | 5144.58 | 5152.91 | 5138.14 | 5146.73 | 171298.0 |
| 2024-01-18 12:00:00 | ES | Futures | 5147.0 | 5147.81 | 5130.89 | 5133.03 | 188726.0 |
| 2024-01-18 13:00:00 | ES | Futures | 5132.77 | 5143.24 | 5124.71 | 5141.63 | 154157.0 |
| 2024-01-18 14:00:00 | ES | Futures | 5141.63 | 5163.12 | 5141.36 | 5160.97 | 189287.0 |
| 2024-01-18 15:00:00 | ES | Futures | 5160.97 | 5175.2 | 5159.09 | 5168.76 | 229668.0 |
| 2024-01-18 16:00:00 | ES | Futures | 5168.49 | 5171.17 | 5163.92 | 5168.49 | 57779.0 |
| 2024-01-18 18:00:00 | ES | Futures | 5169.03 | 5173.05 | 5166.07 | 5172.79 | 9509.0 |
| 2024-01-18 19:00:00 | ES | Futures | 5172.52 | 5173.32 | 5169.29 | 5171.44 | 8448.0 |
| 2024-01-18 20:00:00 | ES | Futures | 5171.44 | 5172.79 | 5166.88 | 5172.52 | 9298.0 |
| 2024-01-18 21:00:00 | ES | Futures | 5172.25 | 5174.4 | 5170.37 | 5172.79 | 6740.0 |
| 2024-01-18 22:00:00 | ES | Futures | 5172.79 | 5174.67 | 5171.98 | 5173.59 | 4758.0 |
| 2024-01-18 23:00:00 | ES | Futures | 5173.59 | 5174.13 | 5171.98 | 5172.25 | 3388.0 |
| 2024-01-18 00:00:00 | NQ | Futures | 18277.09 | 18298.51 | 18271.66 | 18294.99 | 3664.0 |
| 2024-01-18 01:00:00 | NQ | Futures | 18294.72 | 18329.16 | 18293.9 | 18325.36 | 6135.0 |
| 2024-01-18 02:00:00 | NQ | Futures | 18325.09 | 18332.69 | 18301.23 | 18324.01 | 6362.0 |
| 2024-01-18 03:00:00 | NQ | Futures | 18323.74 | 18351.67 | 18315.87 | 18324.55 | 11107.0 |
| 2024-01-18 04:00:00 | NQ | Futures | 18324.82 | 18372.28 | 18321.84 | 18352.76 | 11113.0 |
| 2024-01-18 05:00:00 | NQ | Futures | 18352.48 | 18385.3 | 18341.91 | 18379.6 | 7696.0 |
| 2024-01-18 06:00:00 | NQ | Futures | 18379.88 | 18440.35 | 18377.43 | 18433.85 | 15148.0 |
| 2024-01-18 07:00:00 | NQ | Futures | 18433.57 | 18469.37 | 18431.4 | 18448.49 | 17159.0 |
| 2024-01-18 08:00:00 | NQ | Futures | 18449.3 | 18490.53 | 18416.22 | 18422.46 | 36359.0 |
| 2024-01-18 09:00:00 | NQ | Futures | 18422.73 | 18500.83 | 18422.73 | 18472.09 | 105593.0 |
| 2024-01-18 10:00:00 | NQ | Futures | 18471.81 | 18528.5 | 18427.07 | 18502.19 | 128330.0 |
| 2024-01-18 11:00:00 | NQ | Futures | 18502.73 | 18552.9 | 18470.73 | 18527.14 | 89750.0 |
| 2024-01-18 12:00:00 | NQ | Futures | 18527.41 | 18532.02 | 18431.68 | 18443.61 | 93053.0 |
| 2024-01-18 13:00:00 | NQ | Futures | 18443.88 | 18466.12 | 18379.6 | 18459.61 | 80707.0 |
| 2024-01-18 14:00:00 | NQ | Futures | 18459.88 | 18563.21 | 18459.61 | 18551.01 | 93515.0 |
| 2024-01-18 15:00:00 | NQ | Futures | 18551.28 | 18578.4 | 18533.65 | 18560.23 | 89599.0 |
| 2024-01-18 16:00:00 | NQ | Futures | 18560.23 | 18575.96 | 18541.24 | 18569.18 | 18209.0 |
| 2024-01-18 18:00:00 | NQ | Futures | 18567.82 | 18606.87 | 18558.33 | 18603.89 | 6659.0 |
| 2024-01-18 19:00:00 | NQ | Futures | 18603.62 | 18615.01 | 18587.89 | 18607.69 | 7490.0 |
| 2024-01-18 20:00:00 | NQ | Futures | 18607.96 | 18614.47 | 18584.36 | 18612.57 | 6831.0 |
| 2024-01-18 21:00:00 | NQ | Futures | 18612.03 | 18628.57 | 18606.06 | 18626.13 | 5757.0 |
| 2024-01-18 22:00:00 | NQ | Futures | 18625.59 | 18635.62 | 18618.81 | 18630.74 | 4260.0 |
| 2024-01-18 23:00:00 | NQ | Futures | 18630.47 | 18633.18 | 18619.89 | 18625.59 | 2395.0 |
| 2024-01-18 00:00:00 | YM | Futures | 40189.8 | 40211.3 | 40183.4 | 40205.9 | 584.0 |
| 2024-01-18 01:00:00 | YM | Futures | 40204.9 | 40229.6 | 40202.7 | 40218.8 | 1184.0 |
| 2024-01-18 02:00:00 | YM | Futures | 40217.8 | 40229.6 | 40195.2 | 40215.6 | 1805.0 |
| 2024-01-18 03:00:00 | YM | Futures | 40214.5 | 40234.9 | 40198.4 | 40223.1 | 2847.0 |
> showing 50 of 2,068 rows — these rows as CSV