PREVIEW / futures_30min / 2023-06-22
file: by_date/futures_30min/2023/2023-06-22.parquet size: 110 KB rows: 3,868
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-22 00:00:00 | ES | Futures | 4840.46 | 4840.73 | 4836.89 | 4837.17 | 1451.0 |
| 2023-06-22 00:30:00 | ES | Futures | 4837.17 | 4838.81 | 4835.79 | 4836.07 | 1971.0 |
| 2023-06-22 01:00:00 | ES | Futures | 4836.34 | 4836.34 | 4831.95 | 4833.05 | 4424.0 |
| 2023-06-22 01:30:00 | ES | Futures | 4833.05 | 4834.42 | 4831.95 | 4833.87 | 3821.0 |
| 2023-06-22 02:00:00 | ES | Futures | 4834.15 | 4834.15 | 4826.46 | 4829.75 | 10890.0 |
| 2023-06-22 02:30:00 | ES | Futures | 4829.75 | 4831.13 | 4827.83 | 4829.75 | 5678.0 |
| 2023-06-22 03:00:00 | ES | Futures | 4829.75 | 4830.03 | 4824.54 | 4827.01 | 22618.0 |
| 2023-06-22 03:30:00 | ES | Futures | 4827.01 | 4832.77 | 4825.91 | 4827.56 | 16210.0 |
| 2023-06-22 04:00:00 | ES | Futures | 4827.83 | 4834.15 | 4826.46 | 4831.95 | 12300.0 |
| 2023-06-22 04:30:00 | ES | Futures | 4832.22 | 4832.77 | 4828.93 | 4830.3 | 7686.0 |
| 2023-06-22 05:00:00 | ES | Futures | 4830.58 | 4833.6 | 4830.03 | 4830.58 | 7202.0 |
| 2023-06-22 05:30:00 | ES | Futures | 4830.58 | 4835.79 | 4830.58 | 4833.6 | 5982.0 |
| 2023-06-22 06:00:00 | ES | Futures | 4833.32 | 4834.15 | 4828.38 | 4830.58 | 7607.0 |
| 2023-06-22 06:30:00 | ES | Futures | 4830.85 | 4831.4 | 4825.36 | 4828.11 | 8392.0 |
| 2023-06-22 07:00:00 | ES | Futures | 4827.83 | 4829.75 | 4823.71 | 4825.09 | 16276.0 |
| 2023-06-22 07:30:00 | ES | Futures | 4825.36 | 4830.3 | 4824.26 | 4830.03 | 9595.0 |
| 2023-06-22 08:00:00 | ES | Futures | 4830.03 | 4831.4 | 4828.38 | 4828.93 | 11040.0 |
| 2023-06-22 08:30:00 | ES | Futures | 4829.2 | 4836.07 | 4827.83 | 4828.93 | 24220.0 |
| 2023-06-22 09:00:00 | ES | Futures | 4828.93 | 4831.13 | 4825.91 | 4829.2 | 25183.0 |
| 2023-06-22 09:30:00 | ES | Futures | 4829.2 | 4841.83 | 4824.54 | 4838.26 | 146861.0 |
| 2023-06-22 10:00:00 | ES | Futures | 4837.71 | 4851.71 | 4835.24 | 4847.32 | 103187.0 |
| 2023-06-22 10:30:00 | ES | Futures | 4847.32 | 4850.34 | 4829.75 | 4834.97 | 106446.0 |
| 2023-06-22 11:00:00 | ES | Futures | 4834.97 | 4845.13 | 4834.69 | 4838.81 | 77505.0 |
| 2023-06-22 11:30:00 | ES | Futures | 4838.81 | 4850.07 | 4837.71 | 4846.77 | 72453.0 |
| 2023-06-22 12:00:00 | ES | Futures | 4847.05 | 4847.32 | 4839.36 | 4843.48 | 57754.0 |
| 2023-06-22 12:30:00 | ES | Futures | 4843.48 | 4848.15 | 4840.73 | 4843.2 | 49253.0 |
| 2023-06-22 13:00:00 | ES | Futures | 4842.93 | 4843.48 | 4833.87 | 4840.73 | 59932.0 |
| 2023-06-22 13:30:00 | ES | Futures | 4841.01 | 4848.42 | 4838.26 | 4847.87 | 48712.0 |
| 2023-06-22 14:00:00 | ES | Futures | 4848.15 | 4851.71 | 4845.95 | 4851.17 | 44230.0 |
| 2023-06-22 14:30:00 | ES | Futures | 4851.17 | 4856.66 | 4848.15 | 4856.11 | 66269.0 |
| 2023-06-22 15:00:00 | ES | Futures | 4856.11 | 4856.93 | 4846.5 | 4847.05 | 60545.0 |
| 2023-06-22 15:30:00 | ES | Futures | 4846.77 | 4858.3 | 4844.03 | 4857.48 | 147945.0 |
| 2023-06-22 16:00:00 | ES | Futures | 4857.48 | 4859.4 | 4853.64 | 4856.66 | 41913.0 |
| 2023-06-22 16:30:00 | ES | Futures | 4856.66 | 4861.05 | 4856.38 | 4859.13 | 7998.0 |
| 2023-06-22 18:00:00 | ES | Futures | 4859.68 | 4860.22 | 4857.75 | 4859.95 | 2322.0 |
| 2023-06-22 18:30:00 | ES | Futures | 4859.68 | 4859.95 | 4858.85 | 4859.4 | 784.0 |
| 2023-06-22 19:00:00 | ES | Futures | 4859.4 | 4859.95 | 4858.3 | 4858.85 | 806.0 |
| 2023-06-22 19:30:00 | ES | Futures | 4858.85 | 4859.68 | 4857.2 | 4857.48 | 1537.0 |
| 2023-06-22 20:00:00 | ES | Futures | 4857.48 | 4857.48 | 4854.46 | 4854.73 | 3155.0 |
| 2023-06-22 20:30:00 | ES | Futures | 4854.73 | 4855.28 | 4853.36 | 4854.19 | 2835.0 |
| 2023-06-22 21:00:00 | ES | Futures | 4854.19 | 4854.46 | 4851.71 | 4852.54 | 3195.0 |
| 2023-06-22 21:30:00 | ES | Futures | 4852.26 | 4852.26 | 4843.48 | 4845.4 | 8342.0 |
| 2023-06-22 22:00:00 | ES | Futures | 4845.13 | 4845.68 | 4842.66 | 4842.93 | 3932.0 |
| 2023-06-22 22:30:00 | ES | Futures | 4842.66 | 4842.93 | 4839.09 | 4840.73 | 4814.0 |
| 2023-06-22 23:00:00 | ES | Futures | 4840.46 | 4841.83 | 4840.46 | 4841.56 | 2300.0 |
| 2023-06-22 23:30:00 | ES | Futures | 4841.28 | 4842.93 | 4837.17 | 4837.71 | 5899.0 |
| 2023-06-22 00:00:00 | NQ | Futures | 16719.85 | 16721.8 | 16708.17 | 16709.84 | 1226.0 |
| 2023-06-22 00:30:00 | NQ | Futures | 16709.84 | 16715.4 | 16699.55 | 16703.72 | 1884.0 |
| 2023-06-22 01:00:00 | NQ | Futures | 16704.0 | 16704.28 | 16674.8 | 16683.7 | 4824.0 |
| 2023-06-22 01:30:00 | NQ | Futures | 16683.7 | 16692.6 | 16676.19 | 16688.15 | 2556.0 |
> showing 50 of 3,868 rows — these rows as CSV