PREVIEW / futures_30min / 2023-08-30
file: by_date/futures_30min/2023/2023-08-30.parquet size: 103 KB rows: 3,787
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-30 00:00:00 | ES | Futures | 4956.58 | 4957.68 | 4955.48 | 4957.13 | 2242.0 |
| 2023-08-30 00:30:00 | ES | Futures | 4957.13 | 4957.4 | 4954.11 | 4954.11 | 1810.0 |
| 2023-08-30 01:00:00 | ES | Futures | 4954.11 | 4956.58 | 4953.01 | 4953.28 | 2875.0 |
| 2023-08-30 01:30:00 | ES | Futures | 4953.28 | 4954.11 | 4949.72 | 4951.64 | 4992.0 |
| 2023-08-30 02:00:00 | ES | Futures | 4951.91 | 4951.91 | 4948.62 | 4950.26 | 5349.0 |
| 2023-08-30 02:30:00 | ES | Futures | 4950.26 | 4950.54 | 4946.15 | 4947.52 | 4629.0 |
| 2023-08-30 03:00:00 | ES | Futures | 4947.52 | 4950.26 | 4940.38 | 4942.3 | 14597.0 |
| 2023-08-30 03:30:00 | ES | Futures | 4942.3 | 4949.72 | 4942.03 | 4949.17 | 8459.0 |
| 2023-08-30 04:00:00 | ES | Futures | 4949.17 | 4949.99 | 4940.38 | 4940.66 | 9716.0 |
| 2023-08-30 04:30:00 | ES | Futures | 4940.66 | 4943.13 | 4940.11 | 4940.66 | 7474.0 |
| 2023-08-30 05:00:00 | ES | Futures | 4940.66 | 4942.3 | 4938.46 | 4940.38 | 8184.0 |
| 2023-08-30 05:30:00 | ES | Futures | 4940.66 | 4942.03 | 4937.09 | 4939.83 | 7772.0 |
| 2023-08-30 06:00:00 | ES | Futures | 4939.83 | 4944.5 | 4939.56 | 4944.22 | 7188.0 |
| 2023-08-30 06:30:00 | ES | Futures | 4944.22 | 4946.97 | 4943.13 | 4945.32 | 5704.0 |
| 2023-08-30 07:00:00 | ES | Futures | 4945.05 | 4945.87 | 4942.03 | 4945.6 | 7188.0 |
| 2023-08-30 07:30:00 | ES | Futures | 4945.32 | 4945.87 | 4942.85 | 4943.13 | 7738.0 |
| 2023-08-30 08:00:00 | ES | Futures | 4943.13 | 4951.91 | 4941.48 | 4950.26 | 22921.0 |
| 2023-08-30 08:30:00 | ES | Futures | 4950.26 | 4956.58 | 4947.52 | 4952.19 | 31475.0 |
| 2023-08-30 09:00:00 | ES | Futures | 4951.91 | 4953.83 | 4947.79 | 4951.09 | 22310.0 |
| 2023-08-30 09:30:00 | ES | Futures | 4951.36 | 4971.13 | 4950.26 | 4970.03 | 149438.0 |
| 2023-08-30 10:00:00 | ES | Futures | 4970.03 | 4974.15 | 4942.3 | 4948.34 | 176078.0 |
| 2023-08-30 10:30:00 | ES | Futures | 4948.34 | 4963.72 | 4947.79 | 4962.89 | 110576.0 |
| 2023-08-30 11:00:00 | ES | Futures | 4962.89 | 4963.44 | 4953.56 | 4961.79 | 67885.0 |
| 2023-08-30 11:30:00 | ES | Futures | 4961.79 | 4969.21 | 4960.42 | 4968.38 | 65052.0 |
| 2023-08-30 12:00:00 | ES | Futures | 4968.11 | 4972.5 | 4964.81 | 4971.13 | 47316.0 |
| 2023-08-30 12:30:00 | ES | Futures | 4971.13 | 4974.97 | 4967.01 | 4972.22 | 51177.0 |
| 2023-08-30 13:00:00 | ES | Futures | 4972.22 | 4972.5 | 4966.46 | 4966.73 | 32410.0 |
| 2023-08-30 13:30:00 | ES | Futures | 4966.73 | 4971.95 | 4960.15 | 4964.81 | 51935.0 |
| 2023-08-30 14:00:00 | ES | Futures | 4964.81 | 4965.91 | 4956.3 | 4957.95 | 64580.0 |
| 2023-08-30 14:30:00 | ES | Futures | 4957.68 | 4970.3 | 4957.4 | 4969.21 | 56814.0 |
| 2023-08-30 15:00:00 | ES | Futures | 4969.21 | 4971.95 | 4964.81 | 4966.46 | 51461.0 |
| 2023-08-30 15:30:00 | ES | Futures | 4966.46 | 4969.48 | 4962.62 | 4967.56 | 136259.0 |
| 2023-08-30 16:00:00 | ES | Futures | 4967.83 | 4970.85 | 4966.46 | 4970.58 | 45892.0 |
| 2023-08-30 16:30:00 | ES | Futures | 4970.58 | 4971.4 | 4969.75 | 4970.85 | 18887.0 |
| 2023-08-30 18:00:00 | ES | Futures | 4970.85 | 4971.4 | 4968.93 | 4969.75 | 1478.0 |
| 2023-08-30 18:30:00 | ES | Futures | 4969.75 | 4970.03 | 4968.38 | 4968.93 | 1174.0 |
| 2023-08-30 19:00:00 | ES | Futures | 4968.93 | 4969.21 | 4968.38 | 4968.93 | 756.0 |
| 2023-08-30 19:30:00 | ES | Futures | 4968.93 | 4968.93 | 4967.56 | 4968.11 | 1627.0 |
| 2023-08-30 20:00:00 | ES | Futures | 4968.38 | 4971.95 | 4968.38 | 4971.4 | 3278.0 |
| 2023-08-30 20:30:00 | ES | Futures | 4971.4 | 4971.68 | 4968.93 | 4969.21 | 2387.0 |
| 2023-08-30 21:00:00 | ES | Futures | 4969.21 | 4971.13 | 4968.66 | 4969.75 | 1559.0 |
| 2023-08-30 21:30:00 | ES | Futures | 4969.75 | 4972.22 | 4969.75 | 4970.58 | 4862.0 |
| 2023-08-30 22:00:00 | ES | Futures | 4970.58 | 4975.79 | 4970.3 | 4973.05 | 5011.0 |
| 2023-08-30 22:30:00 | ES | Futures | 4973.05 | 4973.87 | 4970.58 | 4970.58 | 1764.0 |
| 2023-08-30 23:00:00 | ES | Futures | 4970.85 | 4971.95 | 4969.48 | 4970.85 | 2422.0 |
| 2023-08-30 23:30:00 | ES | Futures | 4970.85 | 4972.77 | 4970.85 | 4971.68 | 2045.0 |
| 2023-08-30 00:00:00 | NQ | Futures | 17194.9 | 17196.85 | 17188.23 | 17194.9 | 1267.0 |
| 2023-08-30 00:30:00 | NQ | Futures | 17194.07 | 17196.01 | 17177.66 | 17177.94 | 1484.0 |
| 2023-08-30 01:00:00 | NQ | Futures | 17177.94 | 17186.56 | 17168.76 | 17170.7 | 1681.0 |
| 2023-08-30 01:30:00 | NQ | Futures | 17170.15 | 17174.6 | 17152.07 | 17160.69 | 3042.0 |
> showing 50 of 3,787 rows — these rows as CSV