PREVIEW / futures_1hour / 2024-01-17
file: by_date/futures_1hour/2024/2024-01-17.parquet size: 68 KB rows: 2,106
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-17 00:00:00 | ES | Futures | 5145.66 | 5145.66 | 5140.02 | 5140.02 | 6051.0 |
| 2024-01-17 01:00:00 | ES | Futures | 5140.02 | 5141.09 | 5130.08 | 5131.15 | 21511.0 |
| 2024-01-17 02:00:00 | ES | Futures | 5131.15 | 5132.5 | 5125.51 | 5130.89 | 21548.0 |
| 2024-01-17 03:00:00 | ES | Futures | 5130.89 | 5133.84 | 5127.39 | 5128.47 | 31265.0 |
| 2024-01-17 04:00:00 | ES | Futures | 5128.47 | 5133.84 | 5123.37 | 5132.77 | 25318.0 |
| 2024-01-17 05:00:00 | ES | Futures | 5133.03 | 5135.18 | 5127.93 | 5131.69 | 15755.0 |
| 2024-01-17 06:00:00 | ES | Futures | 5131.96 | 5136.26 | 5127.13 | 5134.65 | 16206.0 |
| 2024-01-17 07:00:00 | ES | Futures | 5134.65 | 5141.09 | 5133.57 | 5136.26 | 25204.0 |
| 2024-01-17 08:00:00 | ES | Futures | 5136.53 | 5136.53 | 5120.14 | 5122.56 | 75343.0 |
| 2024-01-17 09:00:00 | ES | Futures | 5122.56 | 5126.59 | 5111.82 | 5115.31 | 239596.0 |
| 2024-01-17 10:00:00 | ES | Futures | 5115.04 | 5126.32 | 5112.08 | 5122.56 | 249637.0 |
| 2024-01-17 11:00:00 | ES | Futures | 5122.83 | 5130.89 | 5122.29 | 5124.44 | 165849.0 |
| 2024-01-17 12:00:00 | ES | Futures | 5124.44 | 5125.78 | 5112.89 | 5118.8 | 125340.0 |
| 2024-01-17 13:00:00 | ES | Futures | 5118.8 | 5123.1 | 5099.19 | 5107.79 | 153342.0 |
| 2024-01-17 14:00:00 | ES | Futures | 5107.79 | 5119.87 | 5106.44 | 5116.65 | 118225.0 |
| 2024-01-17 15:00:00 | ES | Futures | 5116.92 | 5129.27 | 5108.06 | 5125.78 | 215413.0 |
| 2024-01-17 16:00:00 | ES | Futures | 5125.51 | 5126.86 | 5123.1 | 5123.9 | 50768.0 |
| 2024-01-17 18:00:00 | ES | Futures | 5122.56 | 5126.05 | 5119.34 | 5124.44 | 8334.0 |
| 2024-01-17 19:00:00 | ES | Futures | 5124.44 | 5126.32 | 5121.75 | 5126.05 | 6610.0 |
| 2024-01-17 20:00:00 | ES | Futures | 5126.32 | 5126.59 | 5121.49 | 5124.98 | 7787.0 |
| 2024-01-17 21:00:00 | ES | Futures | 5124.71 | 5126.32 | 5122.02 | 5122.83 | 4018.0 |
| 2024-01-17 22:00:00 | ES | Futures | 5123.1 | 5124.98 | 5120.41 | 5120.68 | 5358.0 |
| 2024-01-17 23:00:00 | ES | Futures | 5120.68 | 5121.49 | 5117.73 | 5120.14 | 5240.0 |
| 2024-01-17 00:00:00 | NQ | Futures | 18356.82 | 18357.09 | 18325.09 | 18326.18 | 4883.0 |
| 2024-01-17 01:00:00 | NQ | Futures | 18326.18 | 18326.18 | 18261.9 | 18271.94 | 12342.0 |
| 2024-01-17 02:00:00 | NQ | Futures | 18271.66 | 18278.17 | 18242.37 | 18270.04 | 12643.0 |
| 2024-01-17 03:00:00 | NQ | Futures | 18270.04 | 18292.55 | 18255.39 | 18265.16 | 11117.0 |
| 2024-01-17 04:00:00 | NQ | Futures | 18265.43 | 18305.57 | 18244.27 | 18303.4 | 11626.0 |
| 2024-01-17 05:00:00 | NQ | Futures | 18303.12 | 18314.52 | 18281.7 | 18302.85 | 9016.0 |
| 2024-01-17 06:00:00 | NQ | Futures | 18302.85 | 18331.33 | 18282.51 | 18324.28 | 9678.0 |
| 2024-01-17 07:00:00 | NQ | Futures | 18324.28 | 18342.18 | 18314.24 | 18322.65 | 10808.0 |
| 2024-01-17 08:00:00 | NQ | Futures | 18322.11 | 18323.19 | 18230.71 | 18247.26 | 33718.0 |
| 2024-01-17 09:00:00 | NQ | Futures | 18246.99 | 18272.48 | 18120.6 | 18124.13 | 111673.0 |
| 2024-01-17 10:00:00 | NQ | Futures | 18124.67 | 18210.64 | 18104.87 | 18191.93 | 121906.0 |
| 2024-01-17 11:00:00 | NQ | Futures | 18192.2 | 18269.77 | 18190.57 | 18236.41 | 78116.0 |
| 2024-01-17 12:00:00 | NQ | Futures | 18236.14 | 18250.78 | 18194.91 | 18234.51 | 52318.0 |
| 2024-01-17 13:00:00 | NQ | Futures | 18233.97 | 18252.14 | 18152.61 | 18182.71 | 60924.0 |
| 2024-01-17 14:00:00 | NQ | Futures | 18182.71 | 18271.66 | 18176.2 | 18255.93 | 52726.0 |
| 2024-01-17 15:00:00 | NQ | Futures | 18255.93 | 18317.23 | 18222.31 | 18299.6 | 75981.0 |
| 2024-01-17 16:00:00 | NQ | Futures | 18299.6 | 18300.68 | 18284.14 | 18290.38 | 11645.0 |
| 2024-01-17 18:00:00 | NQ | Futures | 18284.14 | 18291.19 | 18262.17 | 18283.33 | 4823.0 |
| 2024-01-17 19:00:00 | NQ | Futures | 18283.87 | 18296.89 | 18271.94 | 18295.26 | 3884.0 |
| 2024-01-17 20:00:00 | NQ | Futures | 18296.62 | 18303.67 | 18273.29 | 18288.48 | 5705.0 |
| 2024-01-17 21:00:00 | NQ | Futures | 18289.02 | 18298.51 | 18281.43 | 18283.87 | 3037.0 |
| 2024-01-17 22:00:00 | NQ | Futures | 18284.14 | 18297.7 | 18280.34 | 18281.7 | 2965.0 |
| 2024-01-17 23:00:00 | NQ | Futures | 18281.97 | 18284.68 | 18267.6 | 18277.09 | 2637.0 |
| 2024-01-17 00:00:00 | YM | Futures | 40271.5 | 40271.5 | 40236.0 | 40238.2 | 788.0 |
| 2024-01-17 01:00:00 | YM | Futures | 40239.2 | 40247.8 | 40181.2 | 40195.2 | 2402.0 |
| 2024-01-17 02:00:00 | YM | Futures | 40193.1 | 40207.0 | 40160.8 | 40195.2 | 2923.0 |
| 2024-01-17 03:00:00 | YM | Futures | 40195.2 | 40229.6 | 40175.9 | 40185.5 | 4318.0 |
> showing 50 of 2,106 rows — these rows as CSV