PREVIEW / futures_1hour / 2024-08-05
file: by_date/futures_1hour/2024/2024-08-05.parquet size: 76 KB rows: 2,159
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-08-05 00:00:00 | ES | Futures | 5549.22 | 5553.68 | 5537.95 | 5538.21 | 32171.0 |
| 2024-08-05 01:00:00 | ES | Futures | 5538.21 | 5540.57 | 5458.25 | 5475.29 | 74225.0 |
| 2024-08-05 02:00:00 | ES | Futures | 5475.56 | 5495.22 | 5454.06 | 5481.85 | 60403.0 |
| 2024-08-05 03:00:00 | ES | Futures | 5481.32 | 5514.62 | 5471.1 | 5511.47 | 60548.0 |
| 2024-08-05 04:00:00 | ES | Futures | 5511.47 | 5534.54 | 5493.65 | 5499.15 | 55293.0 |
| 2024-08-05 05:00:00 | ES | Futures | 5499.15 | 5510.16 | 5471.89 | 5499.68 | 39428.0 |
| 2024-08-05 06:00:00 | ES | Futures | 5499.15 | 5500.72 | 5457.99 | 5481.06 | 54414.0 |
| 2024-08-05 07:00:00 | ES | Futures | 5481.06 | 5489.71 | 5437.8 | 5447.5 | 84983.0 |
| 2024-08-05 08:00:00 | ES | Futures | 5447.5 | 5459.83 | 5369.12 | 5401.89 | 222377.0 |
| 2024-08-05 09:00:00 | ES | Futures | 5401.63 | 5479.23 | 5396.12 | 5448.03 | 406653.0 |
| 2024-08-05 10:00:00 | ES | Futures | 5449.34 | 5510.16 | 5441.47 | 5460.88 | 480361.0 |
| 2024-08-05 11:00:00 | ES | Futures | 5460.88 | 5520.12 | 5449.6 | 5502.82 | 313928.0 |
| 2024-08-05 12:00:00 | ES | Futures | 5502.82 | 5536.38 | 5482.11 | 5487.35 | 254206.0 |
| 2024-08-05 13:00:00 | ES | Futures | 5487.35 | 5507.8 | 5480.28 | 5488.66 | 188057.0 |
| 2024-08-05 14:00:00 | ES | Futures | 5488.93 | 5492.33 | 5452.75 | 5454.06 | 217735.0 |
| 2024-08-05 15:00:00 | ES | Futures | 5454.06 | 5477.13 | 5444.88 | 5472.93 | 411492.0 |
| 2024-08-05 16:00:00 | ES | Futures | 5472.67 | 5506.23 | 5467.17 | 5503.61 | 126995.0 |
| 2024-08-05 18:00:00 | ES | Futures | 5505.44 | 5530.09 | 5505.44 | 5517.5 | 18989.0 |
| 2024-08-05 19:00:00 | ES | Futures | 5517.24 | 5530.61 | 5512.52 | 5530.35 | 12378.0 |
| 2024-08-05 20:00:00 | ES | Futures | 5530.61 | 5543.46 | 5513.05 | 5543.46 | 26368.0 |
| 2024-08-05 21:00:00 | ES | Futures | 5543.19 | 5563.64 | 5532.45 | 5548.96 | 24416.0 |
| 2024-08-05 22:00:00 | ES | Futures | 5548.7 | 5551.06 | 5536.64 | 5543.46 | 9727.0 |
| 2024-08-05 23:00:00 | ES | Futures | 5543.19 | 5560.5 | 5542.67 | 5554.21 | 9940.0 |
| 2024-08-05 00:00:00 | NQ | Futures | 19033.93 | 19053.99 | 18888.48 | 18900.36 | 13009.0 |
| 2024-08-05 01:00:00 | NQ | Futures | 18902.47 | 18918.57 | 18321.44 | 18536.06 | 32139.0 |
| 2024-08-05 02:00:00 | NQ | Futures | 18522.6 | 18670.95 | 18438.39 | 18609.97 | 23731.0 |
| 2024-08-05 03:00:00 | NQ | Futures | 18606.54 | 18867.36 | 18600.21 | 18850.46 | 24773.0 |
| 2024-08-05 04:00:00 | NQ | Futures | 18853.37 | 18996.71 | 18789.48 | 18826.97 | 27006.0 |
| 2024-08-05 05:00:00 | NQ | Futures | 18828.29 | 18890.06 | 18659.6 | 18811.13 | 17091.0 |
| 2024-08-05 06:00:00 | NQ | Futures | 18810.87 | 18814.56 | 18624.76 | 18766.25 | 16108.0 |
| 2024-08-05 07:00:00 | NQ | Futures | 18768.89 | 18817.46 | 18572.49 | 18635.05 | 20123.0 |
| 2024-08-05 08:00:00 | NQ | Futures | 18635.05 | 18701.84 | 18333.58 | 18515.73 | 49678.0 |
| 2024-08-05 09:00:00 | NQ | Futures | 18514.68 | 18956.06 | 18488.54 | 18890.06 | 111235.0 |
| 2024-08-05 10:00:00 | NQ | Futures | 18889.8 | 19125.53 | 18849.14 | 18947.34 | 135087.0 |
| 2024-08-05 11:00:00 | NQ | Futures | 18945.5 | 19206.57 | 18888.74 | 19118.14 | 87464.0 |
| 2024-08-05 12:00:00 | NQ | Futures | 19118.14 | 19311.9 | 19027.86 | 19048.98 | 64486.0 |
| 2024-08-05 13:00:00 | NQ | Futures | 19051.35 | 19184.4 | 19029.44 | 19088.57 | 45972.0 |
| 2024-08-05 14:00:00 | NQ | Futures | 19090.69 | 19100.19 | 18892.96 | 18908.8 | 55722.0 |
| 2024-08-05 15:00:00 | NQ | Futures | 18908.54 | 19042.11 | 18908.54 | 19029.44 | 90632.0 |
| 2024-08-05 16:00:00 | NQ | Futures | 19029.18 | 19186.25 | 19004.89 | 19161.7 | 32766.0 |
| 2024-08-05 18:00:00 | NQ | Futures | 19181.76 | 19281.28 | 19177.8 | 19225.85 | 8588.0 |
| 2024-08-05 19:00:00 | NQ | Futures | 19226.11 | 19310.32 | 19211.85 | 19307.15 | 6257.0 |
| 2024-08-05 20:00:00 | NQ | Futures | 19310.58 | 19365.49 | 19247.49 | 19361.53 | 11441.0 |
| 2024-08-05 21:00:00 | NQ | Futures | 19359.68 | 19468.18 | 19331.97 | 19396.64 | 14132.0 |
| 2024-08-05 22:00:00 | NQ | Futures | 19396.11 | 19416.97 | 19335.66 | 19366.55 | 5033.0 |
| 2024-08-05 23:00:00 | NQ | Futures | 19364.7 | 19455.25 | 19363.64 | 19420.93 | 4321.0 |
| 2024-08-05 00:00:00 | YM | Futures | 41600.4 | 41624.6 | 41551.0 | 41559.4 | 3091.0 |
| 2024-08-05 01:00:00 | YM | Futures | 41559.4 | 41655.1 | 41360.8 | 41422.8 | 8829.0 |
| 2024-08-05 02:00:00 | YM | Futures | 41420.7 | 41512.2 | 41265.2 | 41340.9 | 5909.0 |
| 2024-08-05 03:00:00 | YM | Futures | 41336.7 | 41396.6 | 41160.2 | 41246.3 | 8154.0 |
> showing 50 of 2,159 rows — these rows as CSV