PREVIEW / futures_1hour / 2024-05-24
file: by_date/futures_1hour/2024/2024-05-24.parquet size: 55 KB rows: 1,653
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-05-24 00:00:00 | ES | Futures | 5616.58 | 5618.17 | 5615.51 | 5617.37 | 2705.0 |
| 2024-05-24 01:00:00 | ES | Futures | 5617.11 | 5617.37 | 5614.19 | 5616.04 | 5160.0 |
| 2024-05-24 02:00:00 | ES | Futures | 5616.04 | 5616.31 | 5610.21 | 5611.0 | 9846.0 |
| 2024-05-24 03:00:00 | ES | Futures | 5611.27 | 5617.11 | 5609.41 | 5616.58 | 14524.0 |
| 2024-05-24 04:00:00 | ES | Futures | 5616.58 | 5623.74 | 5616.04 | 5621.88 | 14329.0 |
| 2024-05-24 05:00:00 | ES | Futures | 5622.15 | 5622.94 | 5619.23 | 5621.62 | 10560.0 |
| 2024-05-24 06:00:00 | ES | Futures | 5621.62 | 5625.33 | 5620.55 | 5623.74 | 9800.0 |
| 2024-05-24 07:00:00 | ES | Futures | 5624.0 | 5626.66 | 5621.35 | 5626.13 | 13438.0 |
| 2024-05-24 08:00:00 | ES | Futures | 5626.13 | 5629.84 | 5618.43 | 5624.8 | 34935.0 |
| 2024-05-24 09:00:00 | ES | Futures | 5624.53 | 5631.7 | 5618.7 | 5622.68 | 161212.0 |
| 2024-05-24 10:00:00 | ES | Futures | 5622.15 | 5642.84 | 5622.15 | 5642.04 | 196491.0 |
| 2024-05-24 11:00:00 | ES | Futures | 5642.04 | 5655.31 | 5640.19 | 5646.29 | 184288.0 |
| 2024-05-24 12:00:00 | ES | Futures | 5646.29 | 5652.66 | 5644.17 | 5644.17 | 91960.0 |
| 2024-05-24 13:00:00 | ES | Futures | 5644.43 | 5651.33 | 5642.31 | 5647.88 | 78318.0 |
| 2024-05-24 14:00:00 | ES | Futures | 5647.62 | 5653.72 | 5642.31 | 5643.1 | 88764.0 |
| 2024-05-24 15:00:00 | ES | Futures | 5642.84 | 5648.15 | 5634.08 | 5647.35 | 192167.0 |
| 2024-05-24 16:00:00 | ES | Futures | 5647.08 | 5649.47 | 5645.49 | 5646.29 | 52371.0 |
| 2024-05-24 00:00:00 | NQ | Futures | 20021.34 | 20027.49 | 20016.52 | 20023.21 | 1786.0 |
| 2024-05-24 01:00:00 | NQ | Futures | 20022.94 | 20026.42 | 20013.05 | 20019.47 | 2208.0 |
| 2024-05-24 02:00:00 | NQ | Futures | 20019.47 | 20021.87 | 19998.07 | 20001.81 | 5144.0 |
| 2024-05-24 03:00:00 | NQ | Futures | 20002.35 | 20018.93 | 19990.84 | 20014.92 | 6923.0 |
| 2024-05-24 04:00:00 | NQ | Futures | 20014.92 | 20057.99 | 20011.44 | 20047.82 | 7569.0 |
| 2024-05-24 05:00:00 | NQ | Futures | 20048.09 | 20056.92 | 20033.64 | 20043.81 | 5268.0 |
| 2024-05-24 06:00:00 | NQ | Futures | 20043.27 | 20066.55 | 20041.4 | 20057.99 | 5297.0 |
| 2024-05-24 07:00:00 | NQ | Futures | 20058.79 | 20075.64 | 20047.82 | 20072.97 | 7063.0 |
| 2024-05-24 08:00:00 | NQ | Futures | 20072.97 | 20087.14 | 20034.45 | 20066.01 | 18780.0 |
| 2024-05-24 09:00:00 | NQ | Futures | 20065.48 | 20102.66 | 20044.08 | 20062.53 | 83318.0 |
| 2024-05-24 10:00:00 | NQ | Futures | 20062.8 | 20187.73 | 20062.53 | 20182.64 | 101336.0 |
| 2024-05-24 11:00:00 | NQ | Futures | 20182.91 | 20243.63 | 20179.17 | 20219.83 | 83059.0 |
| 2024-05-24 12:00:00 | NQ | Futures | 20219.56 | 20240.16 | 20205.65 | 20207.25 | 41479.0 |
| 2024-05-24 13:00:00 | NQ | Futures | 20207.52 | 20235.07 | 20195.75 | 20227.05 | 34670.0 |
| 2024-05-24 14:00:00 | NQ | Futures | 20226.78 | 20251.12 | 20191.2 | 20192.01 | 37145.0 |
| 2024-05-24 15:00:00 | NQ | Futures | 20191.74 | 20205.38 | 20154.29 | 20195.75 | 66789.0 |
| 2024-05-24 16:00:00 | NQ | Futures | 20195.75 | 20202.71 | 20186.92 | 20192.01 | 12640.0 |
| 2024-05-24 00:00:00 | YM | Futures | 41604.9 | 41615.5 | 41595.4 | 41601.7 | 567.0 |
| 2024-05-24 01:00:00 | YM | Futures | 41602.8 | 41602.8 | 41584.8 | 41597.5 | 1156.0 |
| 2024-05-24 02:00:00 | YM | Futures | 41597.5 | 41599.6 | 41552.9 | 41559.3 | 1279.0 |
| 2024-05-24 03:00:00 | YM | Futures | 41561.4 | 41619.8 | 41556.1 | 41615.5 | 1621.0 |
| 2024-05-24 04:00:00 | YM | Futures | 41617.7 | 41635.7 | 41602.8 | 41631.5 | 1946.0 |
| 2024-05-24 05:00:00 | YM | Futures | 41631.5 | 41636.8 | 41610.2 | 41621.9 | 1207.0 |
| 2024-05-24 06:00:00 | YM | Futures | 41623.0 | 41643.2 | 41616.6 | 41626.2 | 906.0 |
| 2024-05-24 07:00:00 | YM | Futures | 41627.2 | 41640.0 | 41599.6 | 41626.2 | 1613.0 |
| 2024-05-24 08:00:00 | YM | Futures | 41627.2 | 41665.4 | 41583.7 | 41627.2 | 3379.0 |
| 2024-05-24 09:00:00 | YM | Futures | 41625.1 | 41704.7 | 41582.6 | 41591.1 | 16293.0 |
| 2024-05-24 10:00:00 | YM | Futures | 41591.1 | 41666.5 | 41541.2 | 41637.8 | 19601.0 |
| 2024-05-24 11:00:00 | YM | Futures | 41638.9 | 41740.8 | 41620.9 | 41676.1 | 16348.0 |
| 2024-05-24 12:00:00 | YM | Futures | 41676.1 | 41710.0 | 41632.5 | 41633.6 | 7012.0 |
| 2024-05-24 13:00:00 | YM | Futures | 41635.7 | 41684.6 | 41623.0 | 41636.8 | 6039.0 |
| 2024-05-24 14:00:00 | YM | Futures | 41634.7 | 41664.4 | 41568.8 | 41568.8 | 6433.0 |
| 2024-05-24 15:00:00 | YM | Futures | 41567.8 | 41600.7 | 41517.9 | 41569.9 | 13749.0 |
> showing 50 of 1,653 rows — these rows as CSV