PREVIEW / futures_1hour / 2024-08-01
file: by_date/futures_1hour/2024/2024-08-01.parquet size: 71 KB rows: 2,130
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-01 00:00:00 | ES | Futures | 5864.35 | 5865.39 | 5860.68 | 5863.03 | 4699.0 |
| 2024-08-01 01:00:00 | ES | Futures | 5863.03 | 5868.8 | 5859.63 | 5868.54 | 6030.0 |
| 2024-08-01 02:00:00 | ES | Futures | 5868.28 | 5868.54 | 5847.04 | 5848.09 | 18668.0 |
| 2024-08-01 03:00:00 | ES | Futures | 5848.35 | 5858.58 | 5843.9 | 5845.99 | 23583.0 |
| 2024-08-01 04:00:00 | ES | Futures | 5845.99 | 5847.3 | 5828.95 | 5832.89 | 35365.0 |
| 2024-08-01 05:00:00 | ES | Futures | 5833.15 | 5849.66 | 5831.31 | 5848.09 | 18437.0 |
| 2024-08-01 06:00:00 | ES | Futures | 5847.83 | 5852.55 | 5845.73 | 5851.76 | 13071.0 |
| 2024-08-01 07:00:00 | ES | Futures | 5851.76 | 5858.84 | 5847.57 | 5848.35 | 24849.0 |
| 2024-08-01 08:00:00 | ES | Futures | 5848.62 | 5865.92 | 5846.52 | 5858.84 | 44395.0 |
| 2024-08-01 09:00:00 | ES | Futures | 5858.84 | 5873.26 | 5843.9 | 5864.61 | 237566.0 |
| 2024-08-01 10:00:00 | ES | Futures | 5864.35 | 5868.02 | 5792.77 | 5795.13 | 448482.0 |
| 2024-08-01 11:00:00 | ES | Futures | 5795.13 | 5797.49 | 5760.27 | 5766.03 | 358858.0 |
| 2024-08-01 12:00:00 | ES | Futures | 5766.3 | 5783.86 | 5749.26 | 5755.29 | 258096.0 |
| 2024-08-01 13:00:00 | ES | Futures | 5755.55 | 5757.91 | 5720.68 | 5743.23 | 267587.0 |
| 2024-08-01 14:00:00 | ES | Futures | 5743.23 | 5746.11 | 5709.67 | 5715.44 | 263039.0 |
| 2024-08-01 15:00:00 | ES | Futures | 5715.44 | 5752.66 | 5712.03 | 5747.42 | 449110.0 |
| 2024-08-01 16:00:00 | ES | Futures | 5747.42 | 5752.4 | 5715.17 | 5737.46 | 127550.0 |
| 2024-08-01 18:00:00 | ES | Futures | 5730.12 | 5739.56 | 5710.98 | 5717.27 | 21799.0 |
| 2024-08-01 19:00:00 | ES | Futures | 5717.01 | 5734.05 | 5714.39 | 5726.71 | 10044.0 |
| 2024-08-01 20:00:00 | ES | Futures | 5726.71 | 5730.38 | 5714.39 | 5723.04 | 14983.0 |
| 2024-08-01 21:00:00 | ES | Futures | 5723.3 | 5727.5 | 5716.22 | 5721.73 | 10724.0 |
| 2024-08-01 22:00:00 | ES | Futures | 5721.73 | 5722.51 | 5684.76 | 5700.23 | 38707.0 |
| 2024-08-01 23:00:00 | ES | Futures | 5700.49 | 5709.14 | 5699.97 | 5707.31 | 11627.0 |
| 2024-08-01 00:00:00 | NQ | Futures | 20785.45 | 20789.68 | 20757.74 | 20769.62 | 2648.0 |
| 2024-08-01 01:00:00 | NQ | Futures | 20769.62 | 20794.17 | 20751.14 | 20792.05 | 3554.0 |
| 2024-08-01 02:00:00 | NQ | Futures | 20792.32 | 20794.17 | 20680.65 | 20690.42 | 12042.0 |
| 2024-08-01 03:00:00 | NQ | Futures | 20692.0 | 20761.96 | 20684.61 | 20715.23 | 12268.0 |
| 2024-08-01 04:00:00 | NQ | Futures | 20715.76 | 20722.1 | 20595.65 | 20615.19 | 19698.0 |
| 2024-08-01 05:00:00 | NQ | Futures | 20616.24 | 20698.08 | 20607.79 | 20684.61 | 10561.0 |
| 2024-08-01 06:00:00 | NQ | Futures | 20685.14 | 20702.56 | 20652.14 | 20687.78 | 7943.0 |
| 2024-08-01 07:00:00 | NQ | Futures | 20688.04 | 20730.02 | 20664.81 | 20669.04 | 14195.0 |
| 2024-08-01 08:00:00 | NQ | Futures | 20670.09 | 20746.12 | 20661.38 | 20692.53 | 18782.0 |
| 2024-08-01 09:00:00 | NQ | Futures | 20692.0 | 20782.81 | 20595.91 | 20744.8 | 115383.0 |
| 2024-08-01 10:00:00 | NQ | Futures | 20739.79 | 20767.24 | 20410.6 | 20424.33 | 138468.0 |
| 2024-08-01 11:00:00 | NQ | Futures | 20424.06 | 20439.9 | 20217.1 | 20233.73 | 112955.0 |
| 2024-08-01 12:00:00 | NQ | Futures | 20234.26 | 20312.13 | 20141.34 | 20157.97 | 82707.0 |
| 2024-08-01 13:00:00 | NQ | Futures | 20158.76 | 20176.97 | 19969.22 | 20082.47 | 82796.0 |
| 2024-08-01 14:00:00 | NQ | Futures | 20082.73 | 20098.84 | 19923.55 | 19947.57 | 76389.0 |
| 2024-08-01 15:00:00 | NQ | Futures | 19948.1 | 20130.51 | 19939.13 | 20091.44 | 107543.0 |
| 2024-08-01 16:00:00 | NQ | Futures | 20091.97 | 20115.47 | 19908.5 | 20028.62 | 37311.0 |
| 2024-08-01 18:00:00 | NQ | Futures | 20016.74 | 20041.29 | 19895.57 | 19921.97 | 12953.0 |
| 2024-08-01 19:00:00 | NQ | Futures | 19920.38 | 20011.99 | 19909.03 | 19971.33 | 8714.0 |
| 2024-08-01 20:00:00 | NQ | Futures | 19970.8 | 19992.98 | 19921.97 | 19967.37 | 6982.0 |
| 2024-08-01 21:00:00 | NQ | Futures | 19967.37 | 19980.31 | 19924.34 | 19954.44 | 4308.0 |
| 2024-08-01 22:00:00 | NQ | Futures | 19954.7 | 19958.13 | 19731.11 | 19809.51 | 14661.0 |
| 2024-08-01 23:00:00 | NQ | Futures | 19812.15 | 19855.71 | 19805.02 | 19838.02 | 4247.0 |
| 2024-08-01 00:00:00 | YM | Futures | 43238.5 | 43253.2 | 43222.7 | 43243.8 | 1045.0 |
| 2024-08-01 01:00:00 | YM | Futures | 43243.8 | 43278.4 | 43234.3 | 43274.2 | 831.0 |
| 2024-08-01 02:00:00 | YM | Futures | 43273.2 | 43273.2 | 43145.0 | 43149.2 | 2254.0 |
| 2024-08-01 03:00:00 | YM | Futures | 43150.2 | 43188.1 | 43068.3 | 43074.6 | 2400.0 |
> showing 50 of 2,130 rows — these rows as CSV