PREVIEW / futures_1hour / 2024-07-15
file: by_date/futures_1hour/2024/2024-07-15.parquet size: 66 KB rows: 2,050
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-07-15 00:00:00 | ES | Futures | 5951.65 | 5953.48 | 5950.86 | 5952.69 | 2036.0 |
| 2024-07-15 01:00:00 | ES | Futures | 5952.69 | 5956.63 | 5952.17 | 5955.58 | 4124.0 |
| 2024-07-15 02:00:00 | ES | Futures | 5955.58 | 5957.94 | 5954.01 | 5957.68 | 6878.0 |
| 2024-07-15 03:00:00 | ES | Futures | 5957.68 | 5960.82 | 5956.36 | 5960.3 | 14823.0 |
| 2024-07-15 04:00:00 | ES | Futures | 5960.56 | 5965.8 | 5960.3 | 5965.54 | 12252.0 |
| 2024-07-15 05:00:00 | ES | Futures | 5965.54 | 5967.11 | 5964.49 | 5965.28 | 8124.0 |
| 2024-07-15 06:00:00 | ES | Futures | 5965.02 | 5966.33 | 5962.66 | 5966.07 | 7186.0 |
| 2024-07-15 07:00:00 | ES | Futures | 5966.07 | 5971.83 | 5963.97 | 5964.75 | 23165.0 |
| 2024-07-15 08:00:00 | ES | Futures | 5965.02 | 5967.64 | 5960.56 | 5962.92 | 25731.0 |
| 2024-07-15 09:00:00 | ES | Futures | 5963.18 | 5975.24 | 5959.77 | 5965.54 | 205208.0 |
| 2024-07-15 10:00:00 | ES | Futures | 5965.54 | 5985.73 | 5965.54 | 5984.42 | 189028.0 |
| 2024-07-15 11:00:00 | ES | Futures | 5984.42 | 5997.0 | 5978.91 | 5985.73 | 217219.0 |
| 2024-07-15 12:00:00 | ES | Futures | 5985.47 | 5985.73 | 5968.16 | 5972.88 | 211848.0 |
| 2024-07-15 13:00:00 | ES | Futures | 5972.88 | 5972.88 | 5952.96 | 5956.89 | 208994.0 |
| 2024-07-15 14:00:00 | ES | Futures | 5956.89 | 5972.36 | 5952.69 | 5969.74 | 134353.0 |
| 2024-07-15 15:00:00 | ES | Futures | 5969.74 | 5972.88 | 5941.68 | 5962.13 | 266914.0 |
| 2024-07-15 16:00:00 | ES | Futures | 5961.87 | 5966.33 | 5958.72 | 5965.02 | 56268.0 |
| 2024-07-15 18:00:00 | ES | Futures | 5965.54 | 5971.83 | 5964.75 | 5969.47 | 5514.0 |
| 2024-07-15 19:00:00 | ES | Futures | 5969.47 | 5971.05 | 5968.95 | 5969.21 | 2393.0 |
| 2024-07-15 20:00:00 | ES | Futures | 5969.21 | 5970.0 | 5966.33 | 5967.64 | 4934.0 |
| 2024-07-15 21:00:00 | ES | Futures | 5967.64 | 5968.95 | 5965.8 | 5967.9 | 5096.0 |
| 2024-07-15 22:00:00 | ES | Futures | 5967.9 | 5970.78 | 5967.9 | 5970.52 | 3460.0 |
| 2024-07-15 23:00:00 | ES | Futures | 5970.52 | 5971.57 | 5968.69 | 5969.74 | 2923.0 |
| 2024-07-15 00:00:00 | NQ | Futures | 21726.29 | 21743.18 | 21723.65 | 21740.54 | 1940.0 |
| 2024-07-15 01:00:00 | NQ | Futures | 21739.49 | 21766.41 | 21737.9 | 21761.66 | 3149.0 |
| 2024-07-15 02:00:00 | NQ | Futures | 21760.87 | 21774.07 | 21748.99 | 21772.22 | 4297.0 |
| 2024-07-15 03:00:00 | NQ | Futures | 21772.48 | 21786.48 | 21764.3 | 21769.32 | 5783.0 |
| 2024-07-15 04:00:00 | NQ | Futures | 21769.05 | 21785.42 | 21768.0 | 21780.93 | 5403.0 |
| 2024-07-15 05:00:00 | NQ | Futures | 21780.14 | 21785.68 | 21774.6 | 21778.29 | 3416.0 |
| 2024-07-15 06:00:00 | NQ | Futures | 21778.03 | 21789.91 | 21760.34 | 21781.72 | 4570.0 |
| 2024-07-15 07:00:00 | NQ | Futures | 21781.46 | 21807.59 | 21769.32 | 21774.07 | 10023.0 |
| 2024-07-15 08:00:00 | NQ | Futures | 21774.6 | 21791.76 | 21745.56 | 21754.27 | 14535.0 |
| 2024-07-15 09:00:00 | NQ | Futures | 21754.53 | 21822.11 | 21732.89 | 21781.46 | 107487.0 |
| 2024-07-15 10:00:00 | NQ | Futures | 21781.2 | 21898.4 | 21776.71 | 21887.05 | 87876.0 |
| 2024-07-15 11:00:00 | NQ | Futures | 21887.05 | 21960.18 | 21819.74 | 21859.07 | 93268.0 |
| 2024-07-15 12:00:00 | NQ | Futures | 21858.54 | 21862.77 | 21755.59 | 21806.54 | 81457.0 |
| 2024-07-15 13:00:00 | NQ | Futures | 21807.33 | 21808.12 | 21706.23 | 21719.95 | 78245.0 |
| 2024-07-15 14:00:00 | NQ | Futures | 21720.22 | 21787.0 | 21696.72 | 21770.9 | 54049.0 |
| 2024-07-15 15:00:00 | NQ | Futures | 21770.64 | 21797.83 | 21653.16 | 21745.03 | 92105.0 |
| 2024-07-15 16:00:00 | NQ | Futures | 21745.56 | 21784.89 | 21736.06 | 21778.82 | 17566.0 |
| 2024-07-15 18:00:00 | NQ | Futures | 21781.72 | 21801.79 | 21777.76 | 21788.85 | 3791.0 |
| 2024-07-15 19:00:00 | NQ | Futures | 21788.32 | 21798.09 | 21784.1 | 21785.68 | 2177.0 |
| 2024-07-15 20:00:00 | NQ | Futures | 21785.95 | 21794.66 | 21772.22 | 21781.2 | 3238.0 |
| 2024-07-15 21:00:00 | NQ | Futures | 21781.99 | 21791.23 | 21773.28 | 21786.74 | 5307.0 |
| 2024-07-15 22:00:00 | NQ | Futures | 21786.74 | 21810.23 | 21786.74 | 21808.65 | 3494.0 |
| 2024-07-15 23:00:00 | NQ | Futures | 21808.12 | 21809.18 | 21794.4 | 21802.31 | 1826.0 |
| 2024-07-15 00:00:00 | YM | Futures | 42417.9 | 42434.7 | 42412.6 | 42430.5 | 534.0 |
| 2024-07-15 01:00:00 | YM | Futures | 42429.4 | 42453.6 | 42423.1 | 42447.3 | 1404.0 |
| 2024-07-15 02:00:00 | YM | Futures | 42446.3 | 42473.6 | 42437.8 | 42469.4 | 1579.0 |
| 2024-07-15 03:00:00 | YM | Futures | 42468.3 | 42495.6 | 42437.8 | 42495.6 | 2077.0 |
> showing 50 of 2,050 rows — these rows as CSV