PREVIEW / futures_30min / 2023-08-07
file: by_date/futures_30min/2023/2023-08-07.parquet size: 106 KB rows: 3,810
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-07 00:00:00 | ES | Futures | 4958.22 | 4958.22 | 4954.66 | 4955.75 | 2685.0 |
| 2023-08-07 00:30:00 | ES | Futures | 4955.75 | 4957.68 | 4955.75 | 4956.3 | 1618.0 |
| 2023-08-07 01:00:00 | ES | Futures | 4956.03 | 4958.22 | 4953.83 | 4957.95 | 2664.0 |
| 2023-08-07 01:30:00 | ES | Futures | 4957.68 | 4959.05 | 4953.83 | 4957.68 | 4536.0 |
| 2023-08-07 02:00:00 | ES | Futures | 4957.68 | 4959.32 | 4953.01 | 4953.01 | 5707.0 |
| 2023-08-07 02:30:00 | ES | Futures | 4953.28 | 4955.75 | 4951.64 | 4954.11 | 4777.0 |
| 2023-08-07 03:00:00 | ES | Futures | 4954.11 | 4963.99 | 4952.73 | 4961.79 | 15203.0 |
| 2023-08-07 03:30:00 | ES | Futures | 4961.79 | 4965.36 | 4960.97 | 4964.81 | 9413.0 |
| 2023-08-07 04:00:00 | ES | Futures | 4964.81 | 4964.81 | 4958.22 | 4958.77 | 8935.0 |
| 2023-08-07 04:30:00 | ES | Futures | 4958.5 | 4959.6 | 4950.26 | 4954.66 | 10588.0 |
| 2023-08-07 05:00:00 | ES | Futures | 4954.66 | 4955.48 | 4951.09 | 4953.83 | 6976.0 |
| 2023-08-07 05:30:00 | ES | Futures | 4953.83 | 4958.5 | 4953.83 | 4956.58 | 6082.0 |
| 2023-08-07 06:00:00 | ES | Futures | 4956.3 | 4957.95 | 4947.79 | 4947.79 | 6940.0 |
| 2023-08-07 06:30:00 | ES | Futures | 4947.79 | 4952.73 | 4946.42 | 4951.09 | 9346.0 |
| 2023-08-07 07:00:00 | ES | Futures | 4951.36 | 4953.83 | 4949.17 | 4951.09 | 11650.0 |
| 2023-08-07 07:30:00 | ES | Futures | 4950.81 | 4953.28 | 4949.44 | 4951.64 | 8404.0 |
| 2023-08-07 08:00:00 | ES | Futures | 4951.64 | 4953.28 | 4946.7 | 4948.07 | 11631.0 |
| 2023-08-07 08:30:00 | ES | Futures | 4948.34 | 4961.52 | 4947.52 | 4960.97 | 16859.0 |
| 2023-08-07 09:00:00 | ES | Futures | 4960.97 | 4962.34 | 4957.68 | 4961.52 | 23154.0 |
| 2023-08-07 09:30:00 | ES | Futures | 4961.24 | 4971.68 | 4956.03 | 4958.5 | 202580.0 |
| 2023-08-07 10:00:00 | ES | Futures | 4958.77 | 4973.05 | 4952.73 | 4971.13 | 125351.0 |
| 2023-08-07 10:30:00 | ES | Futures | 4970.85 | 4974.15 | 4962.62 | 4965.09 | 89153.0 |
| 2023-08-07 11:00:00 | ES | Futures | 4964.81 | 4967.56 | 4956.85 | 4960.42 | 80456.0 |
| 2023-08-07 11:30:00 | ES | Futures | 4960.42 | 4971.13 | 4955.75 | 4970.03 | 73367.0 |
| 2023-08-07 12:00:00 | ES | Futures | 4970.03 | 4971.68 | 4965.09 | 4970.58 | 54924.0 |
| 2023-08-07 12:30:00 | ES | Futures | 4970.58 | 4973.05 | 4963.72 | 4971.4 | 50817.0 |
| 2023-08-07 13:00:00 | ES | Futures | 4971.4 | 4974.7 | 4970.03 | 4971.4 | 45984.0 |
| 2023-08-07 13:30:00 | ES | Futures | 4971.4 | 4977.72 | 4969.48 | 4977.44 | 48798.0 |
| 2023-08-07 14:00:00 | ES | Futures | 4977.72 | 4981.01 | 4969.48 | 4970.85 | 61029.0 |
| 2023-08-07 14:30:00 | ES | Futures | 4971.13 | 4978.54 | 4970.85 | 4976.34 | 46643.0 |
| 2023-08-07 15:00:00 | ES | Futures | 4976.34 | 4979.91 | 4971.68 | 4972.22 | 48548.0 |
| 2023-08-07 15:30:00 | ES | Futures | 4972.22 | 4984.85 | 4970.85 | 4983.21 | 151508.0 |
| 2023-08-07 16:00:00 | ES | Futures | 4982.93 | 4986.5 | 4981.56 | 4985.95 | 46204.0 |
| 2023-08-07 16:30:00 | ES | Futures | 4985.95 | 4987.05 | 4984.85 | 4985.13 | 7947.0 |
| 2023-08-07 18:00:00 | ES | Futures | 4984.58 | 4986.23 | 4982.38 | 4982.66 | 2674.0 |
| 2023-08-07 18:30:00 | ES | Futures | 4982.66 | 4984.3 | 4982.38 | 4982.93 | 869.0 |
| 2023-08-07 19:00:00 | ES | Futures | 4983.21 | 4983.75 | 4982.11 | 4983.21 | 898.0 |
| 2023-08-07 19:30:00 | ES | Futures | 4982.93 | 4984.3 | 4982.11 | 4983.48 | 1423.0 |
| 2023-08-07 20:00:00 | ES | Futures | 4983.75 | 4984.58 | 4981.01 | 4982.11 | 3661.0 |
| 2023-08-07 20:30:00 | ES | Futures | 4982.11 | 4983.21 | 4981.01 | 4982.11 | 1973.0 |
| 2023-08-07 21:00:00 | ES | Futures | 4981.83 | 4982.11 | 4973.32 | 4974.15 | 7824.0 |
| 2023-08-07 21:30:00 | ES | Futures | 4974.15 | 4976.07 | 4970.85 | 4971.4 | 9990.0 |
| 2023-08-07 22:00:00 | ES | Futures | 4971.4 | 4975.24 | 4970.03 | 4974.15 | 6562.0 |
| 2023-08-07 22:30:00 | ES | Futures | 4973.87 | 4976.62 | 4973.6 | 4974.7 | 2685.0 |
| 2023-08-07 23:00:00 | ES | Futures | 4974.97 | 4976.07 | 4970.85 | 4971.68 | 3253.0 |
| 2023-08-07 23:30:00 | ES | Futures | 4971.95 | 4973.05 | 4970.85 | 4971.68 | 2812.0 |
| 2023-08-07 00:00:00 | NQ | Futures | 17171.82 | 17172.37 | 17160.14 | 17164.31 | 2182.0 |
| 2023-08-07 00:30:00 | NQ | Futures | 17164.31 | 17175.99 | 17164.31 | 17170.98 | 1632.0 |
| 2023-08-07 01:00:00 | NQ | Futures | 17170.98 | 17178.21 | 17157.63 | 17174.6 | 2008.0 |
| 2023-08-07 01:30:00 | NQ | Futures | 17174.6 | 17177.1 | 17152.9 | 17172.37 | 2770.0 |
> showing 50 of 3,810 rows — these rows as CSV