PREVIEW / futures_30min / 2023-07-12
file: by_date/futures_30min/2023/2023-07-12.parquet size: 109 KB rows: 3,839
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-07-12 00:00:00 | ES | Futures | 4913.48 | 4916.77 | 4913.48 | 4916.5 | 1608.0 |
| 2023-07-12 00:30:00 | ES | Futures | 4916.77 | 4916.77 | 4914.58 | 4915.4 | 966.0 |
| 2023-07-12 01:00:00 | ES | Futures | 4915.13 | 4916.77 | 4914.58 | 4915.95 | 1850.0 |
| 2023-07-12 01:30:00 | ES | Futures | 4916.22 | 4916.22 | 4914.03 | 4914.85 | 1833.0 |
| 2023-07-12 02:00:00 | ES | Futures | 4914.85 | 4918.15 | 4914.58 | 4915.68 | 4189.0 |
| 2023-07-12 02:30:00 | ES | Futures | 4915.4 | 4915.95 | 4913.21 | 4914.3 | 2535.0 |
| 2023-07-12 03:00:00 | ES | Futures | 4914.58 | 4916.5 | 4913.21 | 4916.22 | 8222.0 |
| 2023-07-12 03:30:00 | ES | Futures | 4916.22 | 4919.79 | 4915.4 | 4918.7 | 7972.0 |
| 2023-07-12 04:00:00 | ES | Futures | 4918.97 | 4920.89 | 4917.32 | 4919.24 | 7914.0 |
| 2023-07-12 04:30:00 | ES | Futures | 4918.97 | 4920.34 | 4918.7 | 4920.34 | 4517.0 |
| 2023-07-12 05:00:00 | ES | Futures | 4920.07 | 4922.81 | 4919.79 | 4921.71 | 6362.0 |
| 2023-07-12 05:30:00 | ES | Futures | 4921.99 | 4923.64 | 4921.44 | 4921.99 | 7012.0 |
| 2023-07-12 06:00:00 | ES | Futures | 4921.99 | 4922.26 | 4919.52 | 4920.07 | 4149.0 |
| 2023-07-12 06:30:00 | ES | Futures | 4920.34 | 4921.71 | 4919.24 | 4919.52 | 3854.0 |
| 2023-07-12 07:00:00 | ES | Futures | 4919.52 | 4925.01 | 4919.24 | 4924.19 | 8505.0 |
| 2023-07-12 07:30:00 | ES | Futures | 4924.19 | 4926.38 | 4923.91 | 4924.73 | 8072.0 |
| 2023-07-12 08:00:00 | ES | Futures | 4924.73 | 4926.66 | 4921.44 | 4923.36 | 19470.0 |
| 2023-07-12 08:30:00 | ES | Futures | 4923.09 | 4953.01 | 4923.09 | 4946.7 | 107153.0 |
| 2023-07-12 09:00:00 | ES | Futures | 4946.7 | 4957.95 | 4946.15 | 4954.93 | 56846.0 |
| 2023-07-12 09:30:00 | ES | Futures | 4954.93 | 4962.34 | 4948.62 | 4960.97 | 200247.0 |
| 2023-07-12 10:00:00 | ES | Futures | 4960.97 | 4965.36 | 4956.03 | 4963.99 | 129155.0 |
| 2023-07-12 10:30:00 | ES | Futures | 4963.72 | 4967.28 | 4959.05 | 4961.24 | 92468.0 |
| 2023-07-12 11:00:00 | ES | Futures | 4961.52 | 4963.17 | 4956.58 | 4957.4 | 73774.0 |
| 2023-07-12 11:30:00 | ES | Futures | 4957.4 | 4958.5 | 4939.28 | 4941.21 | 179002.0 |
| 2023-07-12 12:00:00 | ES | Futures | 4940.93 | 4947.79 | 4937.91 | 4942.85 | 100448.0 |
| 2023-07-12 12:30:00 | ES | Futures | 4942.85 | 4952.46 | 4941.75 | 4948.62 | 80827.0 |
| 2023-07-12 13:00:00 | ES | Futures | 4948.62 | 4953.01 | 4946.42 | 4951.91 | 51246.0 |
| 2023-07-12 13:30:00 | ES | Futures | 4951.91 | 4955.75 | 4951.09 | 4954.38 | 45573.0 |
| 2023-07-12 14:00:00 | ES | Futures | 4954.38 | 4958.77 | 4950.54 | 4957.95 | 50979.0 |
| 2023-07-12 14:30:00 | ES | Futures | 4957.95 | 4958.77 | 4950.81 | 4953.56 | 58220.0 |
| 2023-07-12 15:00:00 | ES | Futures | 4953.28 | 4954.66 | 4941.21 | 4946.42 | 89109.0 |
| 2023-07-12 15:30:00 | ES | Futures | 4946.7 | 4953.01 | 4945.87 | 4951.36 | 175296.0 |
| 2023-07-12 16:00:00 | ES | Futures | 4951.36 | 4954.66 | 4949.72 | 4953.01 | 64504.0 |
| 2023-07-12 16:30:00 | ES | Futures | 4953.28 | 4954.11 | 4951.36 | 4951.64 | 8983.0 |
| 2023-07-12 18:00:00 | ES | Futures | 4952.73 | 4957.13 | 4951.36 | 4955.75 | 3788.0 |
| 2023-07-12 18:30:00 | ES | Futures | 4956.03 | 4958.22 | 4954.93 | 4955.75 | 2056.0 |
| 2023-07-12 19:00:00 | ES | Futures | 4955.75 | 4956.03 | 4954.38 | 4954.93 | 1281.0 |
| 2023-07-12 19:30:00 | ES | Futures | 4954.93 | 4956.85 | 4954.66 | 4954.93 | 1310.0 |
| 2023-07-12 20:00:00 | ES | Futures | 4954.93 | 4958.22 | 4954.11 | 4958.22 | 3778.0 |
| 2023-07-12 20:30:00 | ES | Futures | 4958.22 | 4958.5 | 4957.13 | 4957.13 | 2360.0 |
| 2023-07-12 21:00:00 | ES | Futures | 4957.4 | 4957.4 | 4954.66 | 4955.21 | 2617.0 |
| 2023-07-12 21:30:00 | ES | Futures | 4955.21 | 4956.85 | 4954.11 | 4956.58 | 3024.0 |
| 2023-07-12 22:00:00 | ES | Futures | 4956.58 | 4958.5 | 4955.75 | 4957.95 | 2512.0 |
| 2023-07-12 22:30:00 | ES | Futures | 4957.95 | 4958.22 | 4956.58 | 4958.22 | 1642.0 |
| 2023-07-12 23:00:00 | ES | Futures | 4957.95 | 4960.97 | 4957.68 | 4960.7 | 3947.0 |
| 2023-07-12 23:30:00 | ES | Futures | 4960.7 | 4962.34 | 4959.87 | 4962.07 | 3737.0 |
| 2023-07-12 00:00:00 | NQ | Futures | 16995.2 | 17010.22 | 16993.53 | 17010.22 | 1225.0 |
| 2023-07-12 00:30:00 | NQ | Futures | 17010.5 | 17011.33 | 16998.82 | 17000.49 | 1043.0 |
| 2023-07-12 01:00:00 | NQ | Futures | 17000.21 | 17004.94 | 16996.04 | 17001.32 | 1025.0 |
| 2023-07-12 01:30:00 | NQ | Futures | 17002.43 | 17003.27 | 16989.36 | 16994.09 | 1325.0 |
> showing 50 of 3,839 rows — these rows as CSV