PREVIEW / futures_1hour / 2024-02-23
file: by_date/futures_1hour/2024/2024-02-23.parquet size: 55 KB rows: 1,616
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-02-23 00:00:00 | ES | Futures | 5481.93 | 5483.28 | 5480.59 | 5482.74 | 3189.0 |
| 2024-02-23 01:00:00 | ES | Futures | 5482.47 | 5483.81 | 5478.98 | 5480.86 | 4781.0 |
| 2024-02-23 02:00:00 | ES | Futures | 5480.59 | 5481.13 | 5476.83 | 5479.25 | 7357.0 |
| 2024-02-23 03:00:00 | ES | Futures | 5479.52 | 5479.79 | 5473.61 | 5474.95 | 15148.0 |
| 2024-02-23 04:00:00 | ES | Futures | 5474.95 | 5476.56 | 5470.65 | 5473.61 | 11449.0 |
| 2024-02-23 05:00:00 | ES | Futures | 5473.61 | 5478.71 | 5471.46 | 5475.22 | 11210.0 |
| 2024-02-23 06:00:00 | ES | Futures | 5474.95 | 5478.71 | 5474.41 | 5478.44 | 9391.0 |
| 2024-02-23 07:00:00 | ES | Futures | 5478.44 | 5482.2 | 5476.29 | 5480.59 | 13790.0 |
| 2024-02-23 08:00:00 | ES | Futures | 5480.32 | 5487.84 | 5477.91 | 5487.04 | 31996.0 |
| 2024-02-23 09:00:00 | ES | Futures | 5486.77 | 5504.5 | 5486.5 | 5499.66 | 199996.0 |
| 2024-02-23 10:00:00 | ES | Futures | 5499.66 | 5502.08 | 5485.43 | 5488.38 | 190802.0 |
| 2024-02-23 11:00:00 | ES | Futures | 5488.38 | 5489.72 | 5471.19 | 5486.23 | 187203.0 |
| 2024-02-23 12:00:00 | ES | Futures | 5486.23 | 5491.6 | 5478.44 | 5487.84 | 126367.0 |
| 2024-02-23 13:00:00 | ES | Futures | 5487.57 | 5492.41 | 5484.35 | 5486.5 | 73203.0 |
| 2024-02-23 14:00:00 | ES | Futures | 5486.77 | 5487.31 | 5476.83 | 5484.62 | 96994.0 |
| 2024-02-23 15:00:00 | ES | Futures | 5484.35 | 5489.19 | 5477.64 | 5478.98 | 199506.0 |
| 2024-02-23 16:00:00 | ES | Futures | 5478.98 | 5479.52 | 5473.34 | 5473.61 | 66486.0 |
| 2024-02-23 00:00:00 | NQ | Futures | 19580.77 | 19586.2 | 19572.91 | 19581.05 | 2796.0 |
| 2024-02-23 01:00:00 | NQ | Futures | 19580.77 | 19586.2 | 19565.04 | 19572.1 | 3296.0 |
| 2024-02-23 02:00:00 | NQ | Futures | 19571.82 | 19581.05 | 19557.18 | 19575.35 | 4060.0 |
| 2024-02-23 03:00:00 | NQ | Futures | 19575.62 | 19576.16 | 19541.18 | 19551.21 | 7947.0 |
| 2024-02-23 04:00:00 | NQ | Futures | 19550.67 | 19559.35 | 19525.99 | 19544.98 | 8389.0 |
| 2024-02-23 05:00:00 | NQ | Futures | 19544.7 | 19558.54 | 19529.52 | 19547.69 | 5862.0 |
| 2024-02-23 06:00:00 | NQ | Futures | 19547.42 | 19567.49 | 19542.53 | 19566.67 | 5860.0 |
| 2024-02-23 07:00:00 | NQ | Futures | 19566.4 | 19576.98 | 19550.13 | 19572.37 | 8473.0 |
| 2024-02-23 08:00:00 | NQ | Futures | 19572.64 | 19616.57 | 19561.25 | 19606.54 | 18898.0 |
| 2024-02-23 09:00:00 | NQ | Futures | 19606.54 | 19683.83 | 19592.71 | 19613.32 | 103518.0 |
| 2024-02-23 10:00:00 | NQ | Futures | 19613.59 | 19627.15 | 19541.18 | 19545.79 | 116758.0 |
| 2024-02-23 11:00:00 | NQ | Futures | 19546.33 | 19568.3 | 19468.22 | 19566.94 | 103341.0 |
| 2024-02-23 12:00:00 | NQ | Futures | 19567.21 | 19596.5 | 19519.21 | 19573.45 | 63720.0 |
| 2024-02-23 13:00:00 | NQ | Futures | 19573.18 | 19593.25 | 19556.37 | 19566.4 | 39760.0 |
| 2024-02-23 14:00:00 | NQ | Futures | 19566.94 | 19568.03 | 19514.6 | 19543.08 | 48600.0 |
| 2024-02-23 15:00:00 | NQ | Futures | 19542.53 | 19548.5 | 19487.48 | 19512.16 | 70882.0 |
| 2024-02-23 16:00:00 | NQ | Futures | 19511.62 | 19513.24 | 19478.53 | 19484.23 | 18419.0 |
| 2024-02-23 00:00:00 | YM | Futures | 42071.6 | 42077.0 | 42064.1 | 42073.8 | 374.0 |
| 2024-02-23 01:00:00 | YM | Futures | 42073.8 | 42080.2 | 42054.4 | 42059.8 | 643.0 |
| 2024-02-23 02:00:00 | YM | Futures | 42058.7 | 42058.7 | 42026.5 | 42042.6 | 1203.0 |
| 2024-02-23 03:00:00 | YM | Futures | 42042.6 | 42050.1 | 42007.2 | 42022.2 | 2331.0 |
| 2024-02-23 04:00:00 | YM | Futures | 42021.1 | 42025.4 | 41990.0 | 42011.5 | 1616.0 |
| 2024-02-23 05:00:00 | YM | Futures | 42009.3 | 42045.8 | 41997.5 | 42025.4 | 1630.0 |
| 2024-02-23 06:00:00 | YM | Futures | 42024.4 | 42072.7 | 42022.2 | 42062.0 | 2125.0 |
| 2024-02-23 07:00:00 | YM | Futures | 42062.0 | 42096.3 | 42060.9 | 42074.8 | 2631.0 |
| 2024-02-23 08:00:00 | YM | Futures | 42074.8 | 42092.0 | 42057.7 | 42082.4 | 3982.0 |
| 2024-02-23 09:00:00 | YM | Futures | 42081.3 | 42238.1 | 42079.1 | 42237.0 | 21229.0 |
| 2024-02-23 10:00:00 | YM | Futures | 42236.0 | 42257.4 | 42178.0 | 42232.7 | 18368.0 |
| 2024-02-23 11:00:00 | YM | Futures | 42234.9 | 42239.2 | 42130.7 | 42158.6 | 13856.0 |
| 2024-02-23 12:00:00 | YM | Futures | 42158.6 | 42199.4 | 42103.8 | 42131.8 | 9807.0 |
| 2024-02-23 13:00:00 | YM | Futures | 42130.7 | 42158.6 | 42101.7 | 42110.3 | 5651.0 |
| 2024-02-23 14:00:00 | YM | Futures | 42110.3 | 42116.7 | 42043.7 | 42096.3 | 7037.0 |
| 2024-02-23 15:00:00 | YM | Futures | 42095.3 | 42155.4 | 42079.1 | 42082.4 | 14149.0 |
> showing 50 of 1,616 rows — these rows as CSV