PREVIEW / futures_30min / 2023-08-31
file: by_date/futures_30min/2023/2023-08-31.parquet size: 103 KB rows: 3,723
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-31 00:00:00 | ES | Futures | 4971.68 | 4973.6 | 4971.4 | 4972.77 | 1902.0 |
| 2023-08-31 00:30:00 | ES | Futures | 4972.77 | 4973.6 | 4971.4 | 4971.68 | 1622.0 |
| 2023-08-31 01:00:00 | ES | Futures | 4971.4 | 4971.95 | 4967.83 | 4968.93 | 4514.0 |
| 2023-08-31 01:30:00 | ES | Futures | 4968.93 | 4972.22 | 4968.38 | 4971.68 | 3048.0 |
| 2023-08-31 02:00:00 | ES | Futures | 4971.95 | 4972.5 | 4968.38 | 4970.3 | 5936.0 |
| 2023-08-31 02:30:00 | ES | Futures | 4970.3 | 4971.68 | 4968.38 | 4968.93 | 3128.0 |
| 2023-08-31 03:00:00 | ES | Futures | 4968.93 | 4973.32 | 4967.83 | 4972.77 | 12664.0 |
| 2023-08-31 03:30:00 | ES | Futures | 4972.5 | 4976.07 | 4972.22 | 4975.52 | 9082.0 |
| 2023-08-31 04:00:00 | ES | Futures | 4975.52 | 4975.52 | 4971.95 | 4973.32 | 8001.0 |
| 2023-08-31 04:30:00 | ES | Futures | 4973.32 | 4974.97 | 4971.68 | 4974.7 | 4977.0 |
| 2023-08-31 05:00:00 | ES | Futures | 4974.7 | 4975.52 | 4967.01 | 4969.75 | 12192.0 |
| 2023-08-31 05:30:00 | ES | Futures | 4969.75 | 4970.58 | 4966.46 | 4968.93 | 5967.0 |
| 2023-08-31 06:00:00 | ES | Futures | 4968.66 | 4973.32 | 4968.66 | 4972.77 | 5759.0 |
| 2023-08-31 06:30:00 | ES | Futures | 4972.77 | 4973.32 | 4970.3 | 4971.13 | 3581.0 |
| 2023-08-31 07:00:00 | ES | Futures | 4970.85 | 4973.87 | 4968.38 | 4973.32 | 6417.0 |
| 2023-08-31 07:30:00 | ES | Futures | 4973.32 | 4982.11 | 4973.05 | 4980.19 | 14981.0 |
| 2023-08-31 08:00:00 | ES | Futures | 4980.19 | 4984.3 | 4978.26 | 4981.83 | 14254.0 |
| 2023-08-31 08:30:00 | ES | Futures | 4982.11 | 4986.5 | 4975.79 | 4978.54 | 35481.0 |
| 2023-08-31 09:00:00 | ES | Futures | 4978.26 | 4978.54 | 4970.58 | 4971.4 | 23889.0 |
| 2023-08-31 09:30:00 | ES | Futures | 4971.68 | 4981.83 | 4968.66 | 4980.46 | 137214.0 |
| 2023-08-31 10:00:00 | ES | Futures | 4980.46 | 4983.21 | 4973.6 | 4982.93 | 83413.0 |
| 2023-08-31 10:30:00 | ES | Futures | 4983.21 | 4984.85 | 4973.6 | 4979.64 | 68596.0 |
| 2023-08-31 11:00:00 | ES | Futures | 4979.36 | 4979.64 | 4970.85 | 4976.34 | 66738.0 |
| 2023-08-31 11:30:00 | ES | Futures | 4976.34 | 4977.17 | 4969.48 | 4974.7 | 58445.0 |
| 2023-08-31 12:00:00 | ES | Futures | 4974.7 | 4978.54 | 4965.64 | 4968.38 | 59876.0 |
| 2023-08-31 12:30:00 | ES | Futures | 4968.38 | 4970.03 | 4957.68 | 4964.26 | 64693.0 |
| 2023-08-31 13:00:00 | ES | Futures | 4964.26 | 4973.6 | 4962.07 | 4972.77 | 52737.0 |
| 2023-08-31 13:30:00 | ES | Futures | 4973.05 | 4974.42 | 4966.19 | 4970.03 | 41191.0 |
| 2023-08-31 14:00:00 | ES | Futures | 4970.03 | 4977.99 | 4969.48 | 4975.24 | 46117.0 |
| 2023-08-31 14:30:00 | ES | Futures | 4975.52 | 4976.34 | 4962.34 | 4963.17 | 61923.0 |
| 2023-08-31 15:00:00 | ES | Futures | 4963.17 | 4970.3 | 4962.62 | 4966.46 | 56105.0 |
| 2023-08-31 15:30:00 | ES | Futures | 4966.46 | 4972.22 | 4955.21 | 4956.85 | 240501.0 |
| 2023-08-31 16:00:00 | ES | Futures | 4956.85 | 4962.34 | 4956.03 | 4960.7 | 84058.0 |
| 2023-08-31 16:30:00 | ES | Futures | 4960.7 | 4961.79 | 4959.6 | 4960.15 | 6396.0 |
| 2023-08-31 18:00:00 | ES | Futures | 4959.6 | 4960.7 | 4956.58 | 4959.05 | 3278.0 |
| 2023-08-31 18:30:00 | ES | Futures | 4959.32 | 4959.87 | 4957.95 | 4959.6 | 1286.0 |
| 2023-08-31 19:00:00 | ES | Futures | 4959.32 | 4960.7 | 4959.05 | 4960.15 | 1274.0 |
| 2023-08-31 19:30:00 | ES | Futures | 4960.42 | 4962.07 | 4959.87 | 4961.52 | 1883.0 |
| 2023-08-31 20:00:00 | ES | Futures | 4961.52 | 4962.89 | 4960.15 | 4962.34 | 4047.0 |
| 2023-08-31 20:30:00 | ES | Futures | 4962.34 | 4964.26 | 4962.07 | 4962.62 | 3270.0 |
| 2023-08-31 21:00:00 | ES | Futures | 4962.62 | 4964.81 | 4962.62 | 4964.54 | 3944.0 |
| 2023-08-31 21:30:00 | ES | Futures | 4964.54 | 4966.19 | 4961.24 | 4963.99 | 4487.0 |
| 2023-08-31 22:00:00 | ES | Futures | 4963.99 | 4965.09 | 4963.44 | 4964.54 | 1753.0 |
| 2023-08-31 22:30:00 | ES | Futures | 4964.81 | 4965.09 | 4962.34 | 4962.89 | 2013.0 |
| 2023-08-31 23:00:00 | ES | Futures | 4962.62 | 4963.72 | 4962.34 | 4962.62 | 1404.0 |
| 2023-08-31 23:30:00 | ES | Futures | 4962.62 | 4963.72 | 4962.07 | 4963.72 | 1757.0 |
| 2023-08-31 00:00:00 | NQ | Futures | 17256.92 | 17263.6 | 17255.81 | 17258.32 | 1443.0 |
| 2023-08-31 00:30:00 | NQ | Futures | 17258.04 | 17264.71 | 17251.36 | 17252.47 | 1544.0 |
| 2023-08-31 01:00:00 | NQ | Futures | 17252.2 | 17253.31 | 17229.11 | 17235.51 | 4377.0 |
| 2023-08-31 01:30:00 | NQ | Futures | 17235.23 | 17251.92 | 17233.28 | 17251.36 | 2478.0 |
> showing 50 of 3,723 rows — these rows as CSV