PREVIEW / futures_30min / 2022-04-18
file: by_date/futures_30min/2022/2022-04-18.parquet size: 90 KB rows: 3,076
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 |
|---|---|---|---|---|---|---|---|
| 2022-04-18 00:00:00 | ES | Futures | 4950.28 | 4951.13 | 4949.15 | 4949.72 | 1365.0 |
| 2022-04-18 00:30:00 | ES | Futures | 4950.0 | 4950.0 | 4944.9 | 4945.75 | 2675.0 |
| 2022-04-18 01:00:00 | ES | Futures | 4946.03 | 4950.0 | 4945.75 | 4946.6 | 1874.0 |
| 2022-04-18 01:30:00 | ES | Futures | 4946.6 | 4953.12 | 4946.03 | 4951.98 | 2544.0 |
| 2022-04-18 02:00:00 | ES | Futures | 4952.27 | 4955.1 | 4950.85 | 4952.55 | 2355.0 |
| 2022-04-18 02:30:00 | ES | Futures | 4952.27 | 4955.39 | 4948.87 | 4951.7 | 3378.0 |
| 2022-04-18 03:00:00 | ES | Futures | 4951.42 | 4952.27 | 4948.58 | 4950.57 | 1511.0 |
| 2022-04-18 03:30:00 | ES | Futures | 4950.0 | 4951.42 | 4944.9 | 4949.72 | 2332.0 |
| 2022-04-18 04:00:00 | ES | Futures | 4949.72 | 4958.79 | 4949.43 | 4956.8 | 3250.0 |
| 2022-04-18 04:30:00 | ES | Futures | 4956.52 | 4957.09 | 4953.4 | 4953.68 | 1124.0 |
| 2022-04-18 05:00:00 | ES | Futures | 4953.97 | 4954.25 | 4944.33 | 4946.6 | 2609.0 |
| 2022-04-18 05:30:00 | ES | Futures | 4946.6 | 4948.87 | 4946.32 | 4948.87 | 1254.0 |
| 2022-04-18 06:00:00 | ES | Futures | 4948.58 | 4955.95 | 4948.02 | 4955.1 | 2256.0 |
| 2022-04-18 06:30:00 | ES | Futures | 4955.39 | 4955.39 | 4952.83 | 4953.12 | 1695.0 |
| 2022-04-18 07:00:00 | ES | Futures | 4953.4 | 4968.14 | 4953.4 | 4965.02 | 8337.0 |
| 2022-04-18 07:30:00 | ES | Futures | 4965.31 | 4965.87 | 4958.5 | 4959.64 | 4385.0 |
| 2022-04-18 08:00:00 | ES | Futures | 4959.64 | 4962.47 | 4955.39 | 4961.05 | 6244.0 |
| 2022-04-18 08:30:00 | ES | Futures | 4960.77 | 4965.31 | 4958.5 | 4959.07 | 7782.0 |
| 2022-04-18 09:00:00 | ES | Futures | 4959.07 | 4967.29 | 4957.37 | 4961.9 | 10919.0 |
| 2022-04-18 09:30:00 | ES | Futures | 4961.62 | 4992.23 | 4961.62 | 4972.96 | 138317.0 |
| 2022-04-18 10:00:00 | ES | Futures | 4972.96 | 4992.8 | 4965.02 | 4984.3 | 96143.0 |
| 2022-04-18 10:30:00 | ES | Futures | 4984.01 | 4992.8 | 4977.21 | 4981.75 | 56597.0 |
| 2022-04-18 11:00:00 | ES | Futures | 4982.03 | 4986.56 | 4964.17 | 4967.86 | 51832.0 |
| 2022-04-18 11:30:00 | ES | Futures | 4967.86 | 4968.71 | 4955.1 | 4965.87 | 48159.0 |
| 2022-04-18 12:00:00 | ES | Futures | 4965.87 | 4966.72 | 4950.28 | 4951.98 | 47705.0 |
| 2022-04-18 12:30:00 | ES | Futures | 4951.7 | 4961.62 | 4948.3 | 4958.79 | 37242.0 |
| 2022-04-18 13:00:00 | ES | Futures | 4959.07 | 4970.41 | 4956.8 | 4967.29 | 45354.0 |
| 2022-04-18 13:30:00 | ES | Futures | 4967.01 | 4995.35 | 4966.44 | 4988.83 | 70597.0 |
| 2022-04-18 14:00:00 | ES | Futures | 4988.83 | 4995.63 | 4978.63 | 4986.0 | 70100.0 |
| 2022-04-18 14:30:00 | ES | Futures | 4986.28 | 4992.8 | 4979.48 | 4980.04 | 47289.0 |
| 2022-04-18 15:00:00 | ES | Futures | 4979.76 | 4982.03 | 4964.46 | 4965.02 | 65384.0 |
| 2022-04-18 15:30:00 | ES | Futures | 4965.02 | 4976.08 | 4948.87 | 4976.08 | 142646.0 |
| 2022-04-18 16:00:00 | ES | Futures | 4976.08 | 4993.65 | 4974.09 | 4989.96 | 71100.0 |
| 2022-04-18 16:30:00 | ES | Futures | 4989.96 | 4990.53 | 4987.13 | 4987.98 | 6178.0 |
| 2022-04-18 18:00:00 | ES | Futures | 4987.41 | 4990.53 | 4986.28 | 4990.25 | 2650.0 |
| 2022-04-18 18:30:00 | ES | Futures | 4990.25 | 4993.37 | 4988.83 | 4988.83 | 1710.0 |
| 2022-04-18 19:00:00 | ES | Futures | 4989.11 | 4991.67 | 4987.7 | 4987.98 | 1292.0 |
| 2022-04-18 19:30:00 | ES | Futures | 4987.98 | 5001.02 | 4986.85 | 5000.74 | 6418.0 |
| 2022-04-18 20:00:00 | ES | Futures | 5000.74 | 5000.74 | 4995.63 | 4996.77 | 4855.0 |
| 2022-04-18 20:30:00 | ES | Futures | 4996.48 | 4997.33 | 4981.46 | 4984.58 | 6561.0 |
| 2022-04-18 21:00:00 | ES | Futures | 4984.3 | 4987.98 | 4979.76 | 4987.98 | 6119.0 |
| 2022-04-18 21:30:00 | ES | Futures | 4987.7 | 4990.53 | 4985.43 | 4987.41 | 4339.0 |
| 2022-04-18 22:00:00 | ES | Futures | 4986.85 | 4987.7 | 4982.88 | 4983.16 | 2858.0 |
| 2022-04-18 22:30:00 | ES | Futures | 4983.16 | 4987.7 | 4982.6 | 4986.28 | 1854.0 |
| 2022-04-18 23:00:00 | ES | Futures | 4986.56 | 4995.35 | 4986.0 | 4994.78 | 3218.0 |
| 2022-04-18 23:30:00 | ES | Futures | 4994.78 | 4996.48 | 4991.67 | 4993.08 | 3375.0 |
| 2022-04-18 00:00:00 | NQ | Futures | 15968.93 | 15974.44 | 15960.52 | 15966.32 | 1127.0 |
| 2022-04-18 00:30:00 | NQ | Futures | 15965.16 | 15965.74 | 15946.02 | 15949.79 | 1545.0 |
| 2022-04-18 01:00:00 | NQ | Futures | 15952.11 | 15966.03 | 15949.5 | 15959.07 | 1536.0 |
| 2022-04-18 01:30:00 | NQ | Futures | 15959.07 | 15998.21 | 15959.07 | 15990.09 | 2697.0 |
> showing 50 of 3,076 rows — these rows as CSV