PREVIEW / futures_30min / 2023-06-13
file: by_date/futures_30min/2023/2023-06-13.parquet size: 107 KB rows: 3,811
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-13 00:00:00 | ES | Futures | 4828.45 | 4830.11 | 4827.61 | 4827.89 | 839.0 |
| 2023-06-13 00:30:00 | ES | Futures | 4828.17 | 4829.28 | 4827.61 | 4828.17 | 631.0 |
| 2023-06-13 01:00:00 | ES | Futures | 4827.61 | 4829.28 | 4827.34 | 4827.61 | 919.0 |
| 2023-06-13 01:30:00 | ES | Futures | 4827.61 | 4830.39 | 4827.06 | 4829.55 | 1299.0 |
| 2023-06-13 02:00:00 | ES | Futures | 4829.55 | 4834.82 | 4827.89 | 4832.33 | 3347.0 |
| 2023-06-13 02:30:00 | ES | Futures | 4832.33 | 4834.27 | 4831.22 | 4831.77 | 1696.0 |
| 2023-06-13 03:00:00 | ES | Futures | 4831.5 | 4831.5 | 4827.06 | 4829.0 | 4706.0 |
| 2023-06-13 03:30:00 | ES | Futures | 4829.0 | 4834.27 | 4827.06 | 4829.28 | 3542.0 |
| 2023-06-13 04:00:00 | ES | Futures | 4829.0 | 4831.77 | 4827.06 | 4830.94 | 2594.0 |
| 2023-06-13 04:30:00 | ES | Futures | 4830.94 | 4832.61 | 4830.11 | 4830.66 | 2971.0 |
| 2023-06-13 05:00:00 | ES | Futures | 4830.39 | 4833.16 | 4830.11 | 4831.22 | 2275.0 |
| 2023-06-13 05:30:00 | ES | Futures | 4831.22 | 4831.5 | 4825.95 | 4825.95 | 3990.0 |
| 2023-06-13 06:00:00 | ES | Futures | 4826.23 | 4827.06 | 4820.4 | 4821.51 | 6697.0 |
| 2023-06-13 06:30:00 | ES | Futures | 4821.51 | 4824.56 | 4820.96 | 4823.18 | 3586.0 |
| 2023-06-13 07:00:00 | ES | Futures | 4823.18 | 4825.12 | 4820.96 | 4823.45 | 3435.0 |
| 2023-06-13 07:30:00 | ES | Futures | 4823.18 | 4823.73 | 4819.02 | 4820.12 | 4640.0 |
| 2023-06-13 08:00:00 | ES | Futures | 4820.12 | 4829.83 | 4817.91 | 4825.12 | 8889.0 |
| 2023-06-13 08:30:00 | ES | Futures | 4827.06 | 4843.98 | 4810.14 | 4843.98 | 21376.0 |
| 2023-06-13 09:00:00 | ES | Futures | 4843.7 | 4848.41 | 4833.44 | 4834.27 | 17926.0 |
| 2023-06-13 09:30:00 | ES | Futures | 4834.27 | 4855.07 | 4831.77 | 4838.98 | 58919.0 |
| 2023-06-13 10:00:00 | ES | Futures | 4839.26 | 4844.25 | 4826.78 | 4838.43 | 38390.0 |
| 2023-06-13 10:30:00 | ES | Futures | 4838.43 | 4846.2 | 4831.77 | 4842.04 | 22835.0 |
| 2023-06-13 11:00:00 | ES | Futures | 4842.04 | 4856.18 | 4838.15 | 4850.08 | 31326.0 |
| 2023-06-13 11:30:00 | ES | Futures | 4850.08 | 4851.74 | 4842.04 | 4842.59 | 27817.0 |
| 2023-06-13 12:00:00 | ES | Futures | 4842.31 | 4850.08 | 4838.98 | 4848.97 | 20832.0 |
| 2023-06-13 12:30:00 | ES | Futures | 4848.69 | 4853.41 | 4847.03 | 4853.13 | 15179.0 |
| 2023-06-13 13:00:00 | ES | Futures | 4853.13 | 4856.74 | 4846.75 | 4853.41 | 16886.0 |
| 2023-06-13 13:30:00 | ES | Futures | 4853.68 | 4855.63 | 4848.69 | 4851.19 | 14485.0 |
| 2023-06-13 14:00:00 | ES | Futures | 4851.19 | 4852.57 | 4837.88 | 4840.37 | 26346.0 |
| 2023-06-13 14:30:00 | ES | Futures | 4840.65 | 4844.53 | 4834.82 | 4842.59 | 31907.0 |
| 2023-06-13 15:00:00 | ES | Futures | 4842.59 | 4850.08 | 4842.59 | 4845.64 | 24883.0 |
| 2023-06-13 15:30:00 | ES | Futures | 4845.64 | 4850.91 | 4843.14 | 4849.25 | 36220.0 |
| 2023-06-13 16:00:00 | ES | Futures | 4849.52 | 4850.08 | 4846.75 | 4848.97 | 10198.0 |
| 2023-06-13 16:30:00 | ES | Futures | 4849.25 | 4853.96 | 4848.97 | 4850.91 | 3972.0 |
| 2023-06-13 18:00:00 | ES | Futures | 4850.36 | 4850.91 | 4847.58 | 4850.91 | 1075.0 |
| 2023-06-13 18:30:00 | ES | Futures | 4850.91 | 4852.57 | 4850.36 | 4852.3 | 423.0 |
| 2023-06-13 19:00:00 | ES | Futures | 4852.3 | 4852.57 | 4850.08 | 4851.47 | 286.0 |
| 2023-06-13 19:30:00 | ES | Futures | 4851.47 | 4851.74 | 4849.52 | 4850.08 | 321.0 |
| 2023-06-13 20:00:00 | ES | Futures | 4849.8 | 4849.8 | 4845.92 | 4847.31 | 1197.0 |
| 2023-06-13 20:30:00 | ES | Futures | 4847.31 | 4848.14 | 4846.2 | 4846.75 | 589.0 |
| 2023-06-13 21:00:00 | ES | Futures | 4847.03 | 4850.08 | 4847.03 | 4849.52 | 602.0 |
| 2023-06-13 21:30:00 | ES | Futures | 4849.25 | 4851.19 | 4848.69 | 4850.63 | 528.0 |
| 2023-06-13 22:00:00 | ES | Futures | 4850.36 | 4850.63 | 4847.86 | 4848.97 | 478.0 |
| 2023-06-13 22:30:00 | ES | Futures | 4849.25 | 4849.25 | 4847.03 | 4848.69 | 569.0 |
| 2023-06-13 23:00:00 | ES | Futures | 4848.41 | 4848.97 | 4847.86 | 4848.97 | 296.0 |
| 2023-06-13 23:30:00 | ES | Futures | 4848.69 | 4849.52 | 4847.31 | 4848.97 | 420.0 |
| 2023-06-13 00:00:00 | NQ | Futures | 16742.55 | 16744.52 | 16735.51 | 16738.05 | 511.0 |
| 2023-06-13 00:30:00 | NQ | Futures | 16738.33 | 16745.65 | 16737.48 | 16741.99 | 599.0 |
| 2023-06-13 01:00:00 | NQ | Futures | 16740.86 | 16745.65 | 16734.67 | 16738.61 | 656.0 |
| 2023-06-13 01:30:00 | NQ | Futures | 16738.05 | 16743.11 | 16734.67 | 16740.58 | 695.0 |
> showing 50 of 3,811 rows — these rows as CSV