PREVIEW / futures_30min / 2023-07-14
file: by_date/futures_30min/2023/2023-07-14.parquet size: 92 KB rows: 3,100
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-14 00:00:00 | ES | Futures | 4987.05 | 4987.32 | 4985.4 | 4985.68 | 1443.0 |
| 2023-07-14 00:30:00 | ES | Futures | 4985.68 | 4986.77 | 4985.13 | 4985.68 | 2338.0 |
| 2023-07-14 01:00:00 | ES | Futures | 4985.68 | 4986.23 | 4984.03 | 4985.13 | 1969.0 |
| 2023-07-14 01:30:00 | ES | Futures | 4985.4 | 4987.87 | 4983.75 | 4987.87 | 4161.0 |
| 2023-07-14 02:00:00 | ES | Futures | 4987.6 | 4988.7 | 4984.58 | 4984.85 | 3840.0 |
| 2023-07-14 02:30:00 | ES | Futures | 4984.85 | 4985.4 | 4981.01 | 4981.56 | 4156.0 |
| 2023-07-14 03:00:00 | ES | Futures | 4981.56 | 4986.77 | 4981.56 | 4984.03 | 6204.0 |
| 2023-07-14 03:30:00 | ES | Futures | 4984.03 | 4987.6 | 4982.38 | 4986.77 | 7222.0 |
| 2023-07-14 04:00:00 | ES | Futures | 4986.77 | 4988.42 | 4985.95 | 4986.5 | 6349.0 |
| 2023-07-14 04:30:00 | ES | Futures | 4986.77 | 4988.42 | 4985.13 | 4985.4 | 4573.0 |
| 2023-07-14 05:00:00 | ES | Futures | 4985.4 | 4987.05 | 4984.58 | 4986.23 | 3246.0 |
| 2023-07-14 05:30:00 | ES | Futures | 4985.95 | 4986.5 | 4982.93 | 4985.13 | 6795.0 |
| 2023-07-14 06:00:00 | ES | Futures | 4985.4 | 4987.87 | 4985.13 | 4987.05 | 5925.0 |
| 2023-07-14 06:30:00 | ES | Futures | 4986.77 | 4992.81 | 4986.5 | 4991.44 | 14165.0 |
| 2023-07-14 07:00:00 | ES | Futures | 4991.72 | 4994.73 | 4991.72 | 4994.19 | 9033.0 |
| 2023-07-14 07:30:00 | ES | Futures | 4994.46 | 4996.38 | 4992.54 | 4993.91 | 9385.0 |
| 2023-07-14 08:00:00 | ES | Futures | 4994.19 | 4998.58 | 4993.91 | 4997.21 | 12002.0 |
| 2023-07-14 08:30:00 | ES | Futures | 4997.21 | 4999.68 | 4994.19 | 4997.75 | 14127.0 |
| 2023-07-14 09:00:00 | ES | Futures | 4997.75 | 4998.3 | 4994.19 | 4997.48 | 18649.0 |
| 2023-07-14 09:30:00 | ES | Futures | 4997.75 | 5004.62 | 4996.11 | 5003.79 | 138151.0 |
| 2023-07-14 10:00:00 | ES | Futures | 5004.07 | 5007.64 | 4993.91 | 4996.93 | 118337.0 |
| 2023-07-14 10:30:00 | ES | Futures | 4996.93 | 5000.23 | 4987.05 | 4994.19 | 132396.0 |
| 2023-07-14 11:00:00 | ES | Futures | 4993.91 | 4998.3 | 4992.81 | 4996.93 | 64291.0 |
| 2023-07-14 11:30:00 | ES | Futures | 4996.93 | 5001.6 | 4993.09 | 4998.03 | 63044.0 |
| 2023-07-14 12:00:00 | ES | Futures | 4998.03 | 4998.3 | 4988.97 | 4989.52 | 55534.0 |
| 2023-07-14 12:30:00 | ES | Futures | 4989.52 | 4993.64 | 4987.32 | 4990.07 | 51559.0 |
| 2023-07-14 13:00:00 | ES | Futures | 4990.34 | 4990.62 | 4983.21 | 4989.52 | 63468.0 |
| 2023-07-14 13:30:00 | ES | Futures | 4989.52 | 4993.91 | 4988.42 | 4990.62 | 47262.0 |
| 2023-07-14 14:00:00 | ES | Futures | 4990.62 | 4995.28 | 4987.05 | 4987.87 | 47036.0 |
| 2023-07-14 14:30:00 | ES | Futures | 4987.87 | 4990.07 | 4983.21 | 4984.03 | 58230.0 |
| 2023-07-14 15:00:00 | ES | Futures | 4984.3 | 4987.32 | 4976.89 | 4982.38 | 95126.0 |
| 2023-07-14 15:30:00 | ES | Futures | 4982.66 | 4985.13 | 4975.24 | 4984.03 | 152319.0 |
| 2023-07-14 16:00:00 | ES | Futures | 4984.03 | 4984.3 | 4979.91 | 4980.19 | 49706.0 |
| 2023-07-14 16:30:00 | ES | Futures | 4979.91 | 4981.01 | 4979.36 | 4979.91 | 5861.0 |
| 2023-07-14 00:00:00 | NQ | Futures | 17493.06 | 17493.89 | 17483.6 | 17486.94 | 1190.0 |
| 2023-07-14 00:30:00 | NQ | Futures | 17486.94 | 17495.28 | 17486.66 | 17491.67 | 1217.0 |
| 2023-07-14 01:00:00 | NQ | Futures | 17491.67 | 17492.5 | 17482.77 | 17487.22 | 1252.0 |
| 2023-07-14 01:30:00 | NQ | Futures | 17488.05 | 17497.79 | 17481.65 | 17497.23 | 1740.0 |
| 2023-07-14 02:00:00 | NQ | Futures | 17496.95 | 17501.68 | 17481.93 | 17483.88 | 1899.0 |
| 2023-07-14 02:30:00 | NQ | Futures | 17484.16 | 17486.38 | 17464.69 | 17467.19 | 2874.0 |
| 2023-07-14 03:00:00 | NQ | Futures | 17467.75 | 17486.66 | 17467.47 | 17474.7 | 2857.0 |
| 2023-07-14 03:30:00 | NQ | Futures | 17474.42 | 17492.78 | 17468.03 | 17486.1 | 2927.0 |
| 2023-07-14 04:00:00 | NQ | Futures | 17485.83 | 17509.47 | 17481.38 | 17483.88 | 4949.0 |
| 2023-07-14 04:30:00 | NQ | Futures | 17483.32 | 17495.01 | 17476.37 | 17477.76 | 2714.0 |
| 2023-07-14 05:00:00 | NQ | Futures | 17477.76 | 17483.05 | 17475.54 | 17479.71 | 1944.0 |
| 2023-07-14 05:30:00 | NQ | Futures | 17479.43 | 17480.82 | 17452.73 | 17456.07 | 4478.0 |
| 2023-07-14 06:00:00 | NQ | Futures | 17456.9 | 17469.7 | 17453.01 | 17467.47 | 3626.0 |
| 2023-07-14 06:30:00 | NQ | Futures | 17467.19 | 17469.97 | 17450.78 | 17456.07 | 5399.0 |
| 2023-07-14 07:00:00 | NQ | Futures | 17456.34 | 17478.04 | 17456.34 | 17473.31 | 4449.0 |
| 2023-07-14 07:30:00 | NQ | Futures | 17473.87 | 17485.83 | 17465.52 | 17478.6 | 5116.0 |
> showing 50 of 3,100 rows — these rows as CSV