PREVIEW / futures_30min / 2023-06-20
file: by_date/futures_30min/2023/2023-06-20.parquet size: 107 KB rows: 3,847
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-06-20 00:00:00 | ES | Futures | 4879.71 | 4880.54 | 4878.62 | 4878.89 | 1157.0 |
| 2023-06-20 00:30:00 | ES | Futures | 4878.62 | 4879.99 | 4877.52 | 4877.79 | 1596.0 |
| 2023-06-20 01:00:00 | ES | Futures | 4877.79 | 4879.44 | 4872.85 | 4875.05 | 4627.0 |
| 2023-06-20 01:30:00 | ES | Futures | 4874.77 | 4877.52 | 4874.22 | 4877.24 | 2288.0 |
| 2023-06-20 02:00:00 | ES | Futures | 4877.24 | 4881.09 | 4875.32 | 4879.44 | 4530.0 |
| 2023-06-20 02:30:00 | ES | Futures | 4879.44 | 4880.26 | 4876.7 | 4877.24 | 2550.0 |
| 2023-06-20 03:00:00 | ES | Futures | 4876.97 | 4881.09 | 4870.66 | 4880.81 | 15083.0 |
| 2023-06-20 03:30:00 | ES | Futures | 4880.54 | 4883.56 | 4879.44 | 4883.01 | 5978.0 |
| 2023-06-20 04:00:00 | ES | Futures | 4883.01 | 4883.83 | 4873.95 | 4874.22 | 9838.0 |
| 2023-06-20 04:30:00 | ES | Futures | 4873.95 | 4874.77 | 4866.54 | 4868.19 | 13016.0 |
| 2023-06-20 05:00:00 | ES | Futures | 4868.19 | 4870.38 | 4867.09 | 4868.19 | 6395.0 |
| 2023-06-20 05:30:00 | ES | Futures | 4868.19 | 4872.58 | 4867.36 | 4870.38 | 5027.0 |
| 2023-06-20 06:00:00 | ES | Futures | 4870.11 | 4873.4 | 4869.56 | 4870.38 | 5004.0 |
| 2023-06-20 06:30:00 | ES | Futures | 4870.11 | 4874.22 | 4869.01 | 4873.95 | 5138.0 |
| 2023-06-20 07:00:00 | ES | Futures | 4873.95 | 4875.6 | 4872.3 | 4875.6 | 6838.0 |
| 2023-06-20 07:30:00 | ES | Futures | 4875.32 | 4877.52 | 4870.93 | 4876.15 | 9282.0 |
| 2023-06-20 08:00:00 | ES | Futures | 4876.15 | 4879.71 | 4875.87 | 4877.24 | 9448.0 |
| 2023-06-20 08:30:00 | ES | Futures | 4877.24 | 4880.26 | 4873.68 | 4879.44 | 13662.0 |
| 2023-06-20 09:00:00 | ES | Futures | 4879.44 | 4880.81 | 4869.56 | 4870.11 | 22535.0 |
| 2023-06-20 09:30:00 | ES | Futures | 4869.83 | 4878.07 | 4865.71 | 4867.91 | 143925.0 |
| 2023-06-20 10:00:00 | ES | Futures | 4867.91 | 4869.56 | 4843.2 | 4845.68 | 155757.0 |
| 2023-06-20 10:30:00 | ES | Futures | 4845.68 | 4853.91 | 4842.93 | 4851.17 | 114224.0 |
| 2023-06-20 11:00:00 | ES | Futures | 4851.44 | 4858.3 | 4850.34 | 4852.54 | 78961.0 |
| 2023-06-20 11:30:00 | ES | Futures | 4852.81 | 4858.58 | 4852.26 | 4854.46 | 57919.0 |
| 2023-06-20 12:00:00 | ES | Futures | 4854.73 | 4869.28 | 4852.26 | 4867.64 | 69334.0 |
| 2023-06-20 12:30:00 | ES | Futures | 4867.36 | 4876.15 | 4865.71 | 4874.22 | 72517.0 |
| 2023-06-20 13:00:00 | ES | Futures | 4874.5 | 4880.54 | 4869.56 | 4876.97 | 61993.0 |
| 2023-06-20 13:30:00 | ES | Futures | 4876.97 | 4879.17 | 4868.73 | 4870.11 | 54090.0 |
| 2023-06-20 14:00:00 | ES | Futures | 4870.38 | 4876.7 | 4869.01 | 4876.15 | 49665.0 |
| 2023-06-20 14:30:00 | ES | Futures | 4876.42 | 4876.7 | 4867.91 | 4872.3 | 46178.0 |
| 2023-06-20 15:00:00 | ES | Futures | 4872.3 | 4873.95 | 4867.64 | 4870.93 | 47214.0 |
| 2023-06-20 15:30:00 | ES | Futures | 4870.93 | 4876.97 | 4866.81 | 4868.73 | 151425.0 |
| 2023-06-20 16:00:00 | ES | Futures | 4868.73 | 4869.56 | 4862.15 | 4866.81 | 59761.0 |
| 2023-06-20 16:30:00 | ES | Futures | 4867.09 | 4867.09 | 4864.89 | 4864.89 | 4988.0 |
| 2023-06-20 18:00:00 | ES | Futures | 4864.62 | 4867.09 | 4864.62 | 4866.81 | 1734.0 |
| 2023-06-20 18:30:00 | ES | Futures | 4867.09 | 4869.28 | 4865.17 | 4865.99 | 2589.0 |
| 2023-06-20 19:00:00 | ES | Futures | 4865.99 | 4868.46 | 4865.99 | 4868.19 | 1093.0 |
| 2023-06-20 19:30:00 | ES | Futures | 4868.46 | 4871.75 | 4868.19 | 4870.66 | 2112.0 |
| 2023-06-20 20:00:00 | ES | Futures | 4870.66 | 4872.3 | 4869.01 | 4871.48 | 2682.0 |
| 2023-06-20 20:30:00 | ES | Futures | 4871.48 | 4873.68 | 4870.38 | 4871.75 | 2354.0 |
| 2023-06-20 21:00:00 | ES | Futures | 4871.75 | 4872.3 | 4869.83 | 4871.75 | 2209.0 |
| 2023-06-20 21:30:00 | ES | Futures | 4871.48 | 4872.3 | 4870.38 | 4872.03 | 2156.0 |
| 2023-06-20 22:00:00 | ES | Futures | 4872.03 | 4872.3 | 4870.66 | 4871.48 | 2179.0 |
| 2023-06-20 22:30:00 | ES | Futures | 4871.75 | 4871.75 | 4867.36 | 4868.46 | 3125.0 |
| 2023-06-20 23:00:00 | ES | Futures | 4868.73 | 4869.56 | 4868.19 | 4868.73 | 1350.0 |
| 2023-06-20 23:30:00 | ES | Futures | 4868.73 | 4869.28 | 4866.81 | 4869.28 | 1748.0 |
| 2023-06-20 00:00:00 | NQ | Futures | 16952.65 | 16953.48 | 16945.42 | 16945.7 | 866.0 |
| 2023-06-20 00:30:00 | NQ | Futures | 16946.25 | 16950.7 | 16944.31 | 16945.14 | 984.0 |
| 2023-06-20 01:00:00 | NQ | Futures | 16944.86 | 16949.59 | 16925.11 | 16929.56 | 2776.0 |
| 2023-06-20 01:30:00 | NQ | Futures | 16929.29 | 16940.97 | 16925.11 | 16940.41 | 1656.0 |
> showing 50 of 3,847 rows — these rows as CSV