PREVIEW / futures_1hour / 2024-07-22
file: by_date/futures_1hour/2024/2024-07-22.parquet size: 67 KB rows: 2,071
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-07-22 00:00:00 | ES | Futures | 5833.93 | 5838.13 | 5827.9 | 5837.34 | 5219.0 |
| 2024-07-22 01:00:00 | ES | Futures | 5837.6 | 5838.65 | 5833.93 | 5835.51 | 4531.0 |
| 2024-07-22 02:00:00 | ES | Futures | 5835.77 | 5843.11 | 5830.79 | 5839.7 | 10391.0 |
| 2024-07-22 03:00:00 | ES | Futures | 5839.96 | 5843.63 | 5832.1 | 5842.06 | 15869.0 |
| 2024-07-22 04:00:00 | ES | Futures | 5841.8 | 5847.57 | 5839.44 | 5843.11 | 15377.0 |
| 2024-07-22 05:00:00 | ES | Futures | 5842.85 | 5849.93 | 5841.54 | 5848.62 | 13189.0 |
| 2024-07-22 06:00:00 | ES | Futures | 5848.35 | 5855.96 | 5847.04 | 5855.69 | 16686.0 |
| 2024-07-22 07:00:00 | ES | Futures | 5855.96 | 5857.27 | 5851.5 | 5857.0 | 15252.0 |
| 2024-07-22 08:00:00 | ES | Futures | 5857.27 | 5864.35 | 5856.48 | 5858.05 | 32228.0 |
| 2024-07-22 09:00:00 | ES | Futures | 5857.79 | 5880.6 | 5857.53 | 5861.99 | 221566.0 |
| 2024-07-22 10:00:00 | ES | Futures | 5861.72 | 5880.6 | 5847.83 | 5873.52 | 297445.0 |
| 2024-07-22 11:00:00 | ES | Futures | 5873.52 | 5881.12 | 5843.9 | 5851.76 | 275785.0 |
| 2024-07-22 12:00:00 | ES | Futures | 5851.76 | 5873.26 | 5846.52 | 5870.64 | 136407.0 |
| 2024-07-22 13:00:00 | ES | Futures | 5870.9 | 5885.06 | 5870.9 | 5881.39 | 120427.0 |
| 2024-07-22 14:00:00 | ES | Futures | 5881.65 | 5889.25 | 5877.45 | 5884.53 | 100205.0 |
| 2024-07-22 15:00:00 | ES | Futures | 5884.79 | 5887.94 | 5877.45 | 5882.43 | 212826.0 |
| 2024-07-22 16:00:00 | ES | Futures | 5882.7 | 5886.1 | 5878.5 | 5881.12 | 57408.0 |
| 2024-07-22 18:00:00 | ES | Futures | 5880.6 | 5885.58 | 5879.29 | 5883.48 | 5023.0 |
| 2024-07-22 19:00:00 | ES | Futures | 5883.48 | 5883.48 | 5877.45 | 5878.24 | 6060.0 |
| 2024-07-22 20:00:00 | ES | Futures | 5878.24 | 5879.03 | 5872.47 | 5874.31 | 6338.0 |
| 2024-07-22 21:00:00 | ES | Futures | 5874.57 | 5879.81 | 5873.52 | 5876.93 | 5761.0 |
| 2024-07-22 22:00:00 | ES | Futures | 5876.93 | 5877.45 | 5873.0 | 5875.88 | 3437.0 |
| 2024-07-22 23:00:00 | ES | Futures | 5875.88 | 5876.4 | 5868.54 | 5872.21 | 6122.0 |
| 2024-07-22 00:00:00 | NQ | Futures | 20884.18 | 20911.9 | 20844.85 | 20908.73 | 4390.0 |
| 2024-07-22 01:00:00 | NQ | Futures | 20907.68 | 20916.13 | 20884.18 | 20895.01 | 3357.0 |
| 2024-07-22 02:00:00 | NQ | Futures | 20894.22 | 20934.6 | 20869.4 | 20924.57 | 6949.0 |
| 2024-07-22 03:00:00 | NQ | Futures | 20924.84 | 20947.54 | 20863.07 | 20932.49 | 9761.0 |
| 2024-07-22 04:00:00 | NQ | Futures | 20931.7 | 20950.71 | 20914.81 | 20923.52 | 7674.0 |
| 2024-07-22 05:00:00 | NQ | Futures | 20923.78 | 20962.85 | 20917.18 | 20956.51 | 6061.0 |
| 2024-07-22 06:00:00 | NQ | Futures | 20956.25 | 21003.5 | 20947.28 | 21002.18 | 10336.0 |
| 2024-07-22 07:00:00 | NQ | Futures | 21002.45 | 21012.22 | 20977.37 | 21010.37 | 9032.0 |
| 2024-07-22 08:00:00 | NQ | Futures | 21010.1 | 21045.74 | 21005.09 | 21026.47 | 13356.0 |
| 2024-07-22 09:00:00 | NQ | Futures | 21025.94 | 21146.85 | 20994.79 | 21087.45 | 105869.0 |
| 2024-07-22 10:00:00 | NQ | Futures | 21087.19 | 21138.4 | 21007.73 | 21070.29 | 107264.0 |
| 2024-07-22 11:00:00 | NQ | Futures | 21070.82 | 21116.49 | 20917.71 | 20976.31 | 93591.0 |
| 2024-07-22 12:00:00 | NQ | Futures | 20976.31 | 21090.35 | 20944.9 | 21077.95 | 53613.0 |
| 2024-07-22 13:00:00 | NQ | Futures | 21077.95 | 21135.76 | 21073.72 | 21118.07 | 44346.0 |
| 2024-07-22 14:00:00 | NQ | Futures | 21118.6 | 21165.85 | 21110.68 | 21130.22 | 37715.0 |
| 2024-07-22 15:00:00 | NQ | Futures | 21130.48 | 21152.92 | 21096.69 | 21116.49 | 66363.0 |
| 2024-07-22 16:00:00 | NQ | Futures | 21115.96 | 21132.06 | 21081.11 | 21098.27 | 16835.0 |
| 2024-07-22 18:00:00 | NQ | Futures | 21099.59 | 21116.75 | 21090.09 | 21104.35 | 4315.0 |
| 2024-07-22 19:00:00 | NQ | Futures | 21104.08 | 21105.93 | 21069.24 | 21070.82 | 4274.0 |
| 2024-07-22 20:00:00 | NQ | Futures | 21071.35 | 21083.23 | 21039.41 | 21052.34 | 5512.0 |
| 2024-07-22 21:00:00 | NQ | Futures | 21053.13 | 21085.6 | 21047.85 | 21071.08 | 4128.0 |
| 2024-07-22 22:00:00 | NQ | Futures | 21070.82 | 21075.31 | 21049.96 | 21063.16 | 2293.0 |
| 2024-07-22 23:00:00 | NQ | Futures | 21064.22 | 21064.75 | 21025.15 | 21047.85 | 4034.0 |
| 2024-07-22 00:00:00 | YM | Futures | 42641.7 | 42656.4 | 42620.7 | 42644.8 | 702.0 |
| 2024-07-22 01:00:00 | YM | Futures | 42645.9 | 42659.5 | 42635.4 | 42649.0 | 739.0 |
| 2024-07-22 02:00:00 | YM | Futures | 42649.0 | 42683.7 | 42620.7 | 42645.9 | 1972.0 |
| 2024-07-22 03:00:00 | YM | Futures | 42648.0 | 42665.9 | 42617.5 | 42655.3 | 1900.0 |
> showing 50 of 2,071 rows — these rows as CSV