PREVIEW / futures_30min / 2023-07-13
file: by_date/futures_30min/2023/2023-07-13.parquet size: 111 KB rows: 3,914
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-13 00:00:00 | ES | Futures | 4962.07 | 4963.17 | 4961.52 | 4962.89 | 5658.0 |
| 2023-07-13 00:30:00 | ES | Futures | 4962.89 | 4962.89 | 4959.32 | 4959.87 | 2558.0 |
| 2023-07-13 01:00:00 | ES | Futures | 4959.6 | 4961.79 | 4958.5 | 4960.7 | 3909.0 |
| 2023-07-13 01:30:00 | ES | Futures | 4960.7 | 4962.07 | 4959.6 | 4959.6 | 3392.0 |
| 2023-07-13 02:00:00 | ES | Futures | 4959.6 | 4962.34 | 4957.68 | 4961.24 | 5174.0 |
| 2023-07-13 02:30:00 | ES | Futures | 4961.52 | 4961.52 | 4958.22 | 4960.42 | 3051.0 |
| 2023-07-13 03:00:00 | ES | Futures | 4960.15 | 4962.89 | 4957.95 | 4962.34 | 8823.0 |
| 2023-07-13 03:30:00 | ES | Futures | 4962.62 | 4965.09 | 4960.42 | 4963.72 | 8646.0 |
| 2023-07-13 04:00:00 | ES | Futures | 4963.72 | 4966.19 | 4962.34 | 4964.81 | 7980.0 |
| 2023-07-13 04:30:00 | ES | Futures | 4964.81 | 4967.28 | 4963.99 | 4966.46 | 6918.0 |
| 2023-07-13 05:00:00 | ES | Futures | 4966.46 | 4969.48 | 4966.19 | 4967.56 | 9659.0 |
| 2023-07-13 05:30:00 | ES | Futures | 4967.56 | 4967.56 | 4962.89 | 4963.44 | 7294.0 |
| 2023-07-13 06:00:00 | ES | Futures | 4963.44 | 4965.36 | 4961.24 | 4964.26 | 5870.0 |
| 2023-07-13 06:30:00 | ES | Futures | 4964.26 | 4967.01 | 4963.99 | 4965.64 | 4575.0 |
| 2023-07-13 07:00:00 | ES | Futures | 4965.64 | 4966.19 | 4962.89 | 4964.26 | 5589.0 |
| 2023-07-13 07:30:00 | ES | Futures | 4964.54 | 4968.11 | 4964.54 | 4967.83 | 11125.0 |
| 2023-07-13 08:00:00 | ES | Futures | 4968.11 | 4968.93 | 4965.91 | 4967.01 | 11825.0 |
| 2023-07-13 08:30:00 | ES | Futures | 4966.46 | 4970.85 | 4960.7 | 4967.83 | 32124.0 |
| 2023-07-13 09:00:00 | ES | Futures | 4967.83 | 4971.13 | 4965.91 | 4969.75 | 23954.0 |
| 2023-07-13 09:30:00 | ES | Futures | 4969.75 | 4976.62 | 4964.54 | 4975.52 | 140382.0 |
| 2023-07-13 10:00:00 | ES | Futures | 4975.52 | 4976.07 | 4968.93 | 4969.48 | 88034.0 |
| 2023-07-13 10:30:00 | ES | Futures | 4969.48 | 4975.79 | 4969.21 | 4974.97 | 61414.0 |
| 2023-07-13 11:00:00 | ES | Futures | 4975.24 | 4976.89 | 4970.03 | 4971.95 | 57188.0 |
| 2023-07-13 11:30:00 | ES | Futures | 4971.95 | 4976.34 | 4969.48 | 4976.07 | 38539.0 |
| 2023-07-13 12:00:00 | ES | Futures | 4976.07 | 4979.36 | 4974.97 | 4977.72 | 45591.0 |
| 2023-07-13 12:30:00 | ES | Futures | 4977.44 | 4981.28 | 4975.52 | 4977.99 | 39673.0 |
| 2023-07-13 13:00:00 | ES | Futures | 4977.99 | 4979.36 | 4972.77 | 4978.26 | 39326.0 |
| 2023-07-13 13:30:00 | ES | Futures | 4978.54 | 4980.46 | 4977.99 | 4978.81 | 29005.0 |
| 2023-07-13 14:00:00 | ES | Futures | 4978.54 | 4985.4 | 4977.99 | 4980.73 | 46736.0 |
| 2023-07-13 14:30:00 | ES | Futures | 4981.01 | 4985.4 | 4979.36 | 4985.4 | 37471.0 |
| 2023-07-13 15:00:00 | ES | Futures | 4985.4 | 4992.26 | 4984.3 | 4990.89 | 65996.0 |
| 2023-07-13 15:30:00 | ES | Futures | 4990.89 | 4997.75 | 4987.87 | 4988.15 | 147044.0 |
| 2023-07-13 16:00:00 | ES | Futures | 4988.15 | 4989.24 | 4983.75 | 4984.03 | 46480.0 |
| 2023-07-13 16:30:00 | ES | Futures | 4984.03 | 4985.13 | 4982.93 | 4984.58 | 5480.0 |
| 2023-07-13 18:00:00 | ES | Futures | 4984.58 | 4987.87 | 4983.48 | 4987.05 | 2804.0 |
| 2023-07-13 18:30:00 | ES | Futures | 4987.05 | 4987.87 | 4985.95 | 4986.5 | 1134.0 |
| 2023-07-13 19:00:00 | ES | Futures | 4986.5 | 4988.42 | 4986.23 | 4987.6 | 1297.0 |
| 2023-07-13 19:30:00 | ES | Futures | 4987.32 | 4987.6 | 4983.75 | 4985.68 | 2184.0 |
| 2023-07-13 20:00:00 | ES | Futures | 4985.95 | 4985.95 | 4979.09 | 4979.64 | 7102.0 |
| 2023-07-13 20:30:00 | ES | Futures | 4979.91 | 4982.11 | 4979.64 | 4980.73 | 3858.0 |
| 2023-07-13 21:00:00 | ES | Futures | 4980.73 | 4982.38 | 4979.91 | 4981.28 | 2856.0 |
| 2023-07-13 21:30:00 | ES | Futures | 4981.01 | 4983.48 | 4979.91 | 4982.93 | 4855.0 |
| 2023-07-13 22:00:00 | ES | Futures | 4983.21 | 4985.13 | 4982.93 | 4984.58 | 3662.0 |
| 2023-07-13 22:30:00 | ES | Futures | 4984.85 | 4986.77 | 4983.75 | 4985.95 | 3224.0 |
| 2023-07-13 23:00:00 | ES | Futures | 4985.95 | 4987.05 | 4985.68 | 4985.68 | 2062.0 |
| 2023-07-13 23:30:00 | ES | Futures | 4985.68 | 4988.15 | 4985.68 | 4987.05 | 2398.0 |
| 2023-07-13 00:00:00 | NQ | Futures | 17245.52 | 17294.19 | 17243.3 | 17259.98 | 3983.0 |
| 2023-07-13 00:30:00 | NQ | Futures | 17259.71 | 17261.37 | 17240.52 | 17241.91 | 2334.0 |
| 2023-07-13 01:00:00 | NQ | Futures | 17241.35 | 17248.58 | 17229.11 | 17244.41 | 2529.0 |
| 2023-07-13 01:30:00 | NQ | Futures | 17244.41 | 17254.14 | 17240.24 | 17243.3 | 1712.0 |
> showing 50 of 3,914 rows — these rows as CSV