PREVIEW / futures_1hour / 2024-05-29
file: by_date/futures_1hour/2024/2024-05-29.parquet size: 68 KB rows: 2,088
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-29 00:00:00 | ES | Futures | 5632.23 | 5634.88 | 5631.17 | 5634.62 | 3775.0 |
| 2024-05-29 01:00:00 | ES | Futures | 5634.62 | 5635.15 | 5624.53 | 5625.06 | 8309.0 |
| 2024-05-29 02:00:00 | ES | Futures | 5625.33 | 5631.17 | 5622.41 | 5629.31 | 11559.0 |
| 2024-05-29 03:00:00 | ES | Futures | 5629.31 | 5631.96 | 5620.29 | 5621.09 | 20825.0 |
| 2024-05-29 04:00:00 | ES | Futures | 5621.35 | 5627.19 | 5616.04 | 5619.76 | 24024.0 |
| 2024-05-29 05:00:00 | ES | Futures | 5619.76 | 5621.09 | 5612.33 | 5616.31 | 16844.0 |
| 2024-05-29 06:00:00 | ES | Futures | 5616.31 | 5619.49 | 5614.72 | 5615.78 | 12209.0 |
| 2024-05-29 07:00:00 | ES | Futures | 5615.78 | 5620.02 | 5611.27 | 5616.31 | 21246.0 |
| 2024-05-29 08:00:00 | ES | Futures | 5616.31 | 5620.82 | 5607.56 | 5608.62 | 37069.0 |
| 2024-05-29 09:00:00 | ES | Futures | 5608.35 | 5612.86 | 5601.72 | 5610.47 | 206029.0 |
| 2024-05-29 10:00:00 | ES | Futures | 5610.21 | 5622.41 | 5607.02 | 5619.49 | 223439.0 |
| 2024-05-29 11:00:00 | ES | Futures | 5619.49 | 5620.02 | 5608.88 | 5614.72 | 127331.0 |
| 2024-05-29 12:00:00 | ES | Futures | 5614.98 | 5622.41 | 5608.35 | 5620.55 | 101451.0 |
| 2024-05-29 13:00:00 | ES | Futures | 5620.29 | 5621.62 | 5610.21 | 5619.23 | 121588.0 |
| 2024-05-29 14:00:00 | ES | Futures | 5619.23 | 5621.09 | 5609.15 | 5610.47 | 101645.0 |
| 2024-05-29 15:00:00 | ES | Futures | 5610.74 | 5621.88 | 5604.64 | 5611.0 | 224229.0 |
| 2024-05-29 16:00:00 | ES | Futures | 5611.0 | 5612.86 | 5590.58 | 5592.43 | 79006.0 |
| 2024-05-29 18:00:00 | ES | Futures | 5592.96 | 5596.41 | 5587.66 | 5589.52 | 13004.0 |
| 2024-05-29 19:00:00 | ES | Futures | 5589.52 | 5590.31 | 5584.74 | 5588.98 | 7565.0 |
| 2024-05-29 20:00:00 | ES | Futures | 5588.98 | 5589.78 | 5585.54 | 5586.07 | 9973.0 |
| 2024-05-29 21:00:00 | ES | Futures | 5586.07 | 5588.72 | 5584.21 | 5586.33 | 9111.0 |
| 2024-05-29 22:00:00 | ES | Futures | 5586.6 | 5587.92 | 5579.96 | 5582.09 | 8767.0 |
| 2024-05-29 23:00:00 | ES | Futures | 5581.82 | 5582.09 | 5577.58 | 5579.96 | 8590.0 |
| 2024-05-29 00:00:00 | NQ | Futures | 20209.13 | 20220.9 | 20205.38 | 20220.36 | 2545.0 |
| 2024-05-29 01:00:00 | NQ | Futures | 20220.63 | 20223.84 | 20177.03 | 20179.7 | 5518.0 |
| 2024-05-29 02:00:00 | NQ | Futures | 20180.77 | 20197.89 | 20170.34 | 20190.67 | 5172.0 |
| 2024-05-29 03:00:00 | NQ | Futures | 20190.67 | 20211.27 | 20164.72 | 20170.34 | 9530.0 |
| 2024-05-29 04:00:00 | NQ | Futures | 20170.87 | 20196.82 | 20118.71 | 20141.18 | 16126.0 |
| 2024-05-29 05:00:00 | NQ | Futures | 20141.45 | 20146.26 | 20113.09 | 20134.49 | 8900.0 |
| 2024-05-29 06:00:00 | NQ | Futures | 20133.96 | 20151.08 | 20124.06 | 20126.2 | 6346.0 |
| 2024-05-29 07:00:00 | NQ | Futures | 20126.47 | 20145.46 | 20111.22 | 20135.56 | 8905.0 |
| 2024-05-29 08:00:00 | NQ | Futures | 20135.56 | 20154.02 | 20087.14 | 20095.17 | 17337.0 |
| 2024-05-29 09:00:00 | NQ | Futures | 20095.44 | 20169.0 | 20068.42 | 20150.01 | 95717.0 |
| 2024-05-29 10:00:00 | NQ | Futures | 20149.74 | 20201.64 | 20127.54 | 20189.06 | 88460.0 |
| 2024-05-29 11:00:00 | NQ | Futures | 20188.8 | 20196.29 | 20140.65 | 20170.34 | 50777.0 |
| 2024-05-29 12:00:00 | NQ | Futures | 20170.87 | 20199.76 | 20138.77 | 20192.54 | 39729.0 |
| 2024-05-29 13:00:00 | NQ | Futures | 20192.81 | 20196.02 | 20133.96 | 20179.97 | 50773.0 |
| 2024-05-29 14:00:00 | NQ | Futures | 20179.7 | 20186.39 | 20131.28 | 20143.32 | 44550.0 |
| 2024-05-29 15:00:00 | NQ | Futures | 20143.32 | 20183.45 | 20100.25 | 20128.34 | 73547.0 |
| 2024-05-29 16:00:00 | NQ | Futures | 20127.81 | 20133.16 | 20052.1 | 20059.32 | 22145.0 |
| 2024-05-29 18:00:00 | NQ | Futures | 20066.01 | 20078.32 | 20030.7 | 20037.66 | 6530.0 |
| 2024-05-29 19:00:00 | NQ | Futures | 20037.12 | 20040.06 | 20014.65 | 20034.45 | 5846.0 |
| 2024-05-29 20:00:00 | NQ | Futures | 20034.45 | 20043.54 | 20021.34 | 20024.55 | 4610.0 |
| 2024-05-29 21:00:00 | NQ | Futures | 20025.08 | 20033.11 | 20014.12 | 20023.48 | 3732.0 |
| 2024-05-29 22:00:00 | NQ | Futures | 20023.75 | 20029.1 | 19993.25 | 20001.01 | 4773.0 |
| 2024-05-29 23:00:00 | NQ | Futures | 20000.47 | 20001.54 | 19984.42 | 19994.32 | 3909.0 |
| 2024-05-29 00:00:00 | YM | Futures | 41211.0 | 41231.2 | 41205.7 | 41229.1 | 865.0 |
| 2024-05-29 01:00:00 | YM | Futures | 41229.1 | 41233.3 | 41168.6 | 41173.9 | 1326.0 |
| 2024-05-29 02:00:00 | YM | Futures | 41174.9 | 41211.0 | 41145.2 | 41188.7 | 2096.0 |
| 2024-05-29 03:00:00 | YM | Futures | 41188.7 | 41206.8 | 41132.5 | 41133.5 | 2621.0 |
> showing 50 of 2,088 rows — these rows as CSV