PREVIEW / futures_30min / 2021-07-01
file: by_date/futures_30min/2021/2021-07-01.parquet size: 100 KB rows: 3,667
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-01 00:00:00 | ES | Futures | 4838.71 | 4839.84 | 4838.15 | 4838.99 | 1266.0 |
| 2021-07-01 00:30:00 | ES | Futures | 4838.71 | 4838.99 | 4836.74 | 4837.86 | 1991.0 |
| 2021-07-01 01:00:00 | ES | Futures | 4837.58 | 4838.71 | 4837.02 | 4837.58 | 1409.0 |
| 2021-07-01 01:30:00 | ES | Futures | 4837.86 | 4839.55 | 4837.58 | 4838.71 | 1605.0 |
| 2021-07-01 02:00:00 | ES | Futures | 4838.99 | 4839.84 | 4837.3 | 4838.15 | 4057.0 |
| 2021-07-01 02:30:00 | ES | Futures | 4838.15 | 4839.27 | 4837.3 | 4838.43 | 2814.0 |
| 2021-07-01 03:00:00 | ES | Futures | 4838.71 | 4844.62 | 4837.3 | 4843.5 | 17615.0 |
| 2021-07-01 03:30:00 | ES | Futures | 4843.5 | 4849.41 | 4843.5 | 4846.87 | 16793.0 |
| 2021-07-01 04:00:00 | ES | Futures | 4847.16 | 4849.69 | 4842.93 | 4844.34 | 15174.0 |
| 2021-07-01 04:30:00 | ES | Futures | 4844.06 | 4844.62 | 4841.52 | 4841.81 | 9073.0 |
| 2021-07-01 05:00:00 | ES | Futures | 4842.09 | 4842.09 | 4836.17 | 4838.99 | 9240.0 |
| 2021-07-01 05:30:00 | ES | Futures | 4838.99 | 4839.27 | 4833.36 | 4837.02 | 9010.0 |
| 2021-07-01 06:00:00 | ES | Futures | 4837.02 | 4837.02 | 4830.26 | 4831.67 | 12160.0 |
| 2021-07-01 06:30:00 | ES | Futures | 4831.67 | 4833.08 | 4827.45 | 4829.42 | 16188.0 |
| 2021-07-01 07:00:00 | ES | Futures | 4829.7 | 4831.95 | 4827.73 | 4831.39 | 13540.0 |
| 2021-07-01 07:30:00 | ES | Futures | 4831.11 | 4838.15 | 4831.11 | 4837.86 | 16243.0 |
| 2021-07-01 08:00:00 | ES | Futures | 4837.86 | 4839.84 | 4835.61 | 4835.61 | 10993.0 |
| 2021-07-01 08:30:00 | ES | Futures | 4835.89 | 4838.15 | 4834.2 | 4835.89 | 13130.0 |
| 2021-07-01 09:00:00 | ES | Futures | 4835.61 | 4838.15 | 4834.49 | 4836.46 | 17178.0 |
| 2021-07-01 09:30:00 | ES | Futures | 4836.46 | 4843.5 | 4835.61 | 4841.81 | 102959.0 |
| 2021-07-01 10:00:00 | ES | Futures | 4842.09 | 4845.47 | 4838.99 | 4842.37 | 73753.0 |
| 2021-07-01 10:30:00 | ES | Futures | 4842.37 | 4846.59 | 4840.68 | 4843.5 | 58185.0 |
| 2021-07-01 11:00:00 | ES | Futures | 4843.5 | 4846.31 | 4836.46 | 4842.09 | 73522.0 |
| 2021-07-01 11:30:00 | ES | Futures | 4841.81 | 4845.75 | 4841.24 | 4844.06 | 38006.0 |
| 2021-07-01 12:00:00 | ES | Futures | 4844.34 | 4845.47 | 4842.65 | 4844.62 | 25654.0 |
| 2021-07-01 12:30:00 | ES | Futures | 4844.62 | 4845.19 | 4842.65 | 4843.78 | 25339.0 |
| 2021-07-01 13:00:00 | ES | Futures | 4843.78 | 4846.87 | 4842.93 | 4846.59 | 23995.0 |
| 2021-07-01 13:30:00 | ES | Futures | 4846.59 | 4851.94 | 4846.03 | 4848.56 | 46500.0 |
| 2021-07-01 14:00:00 | ES | Futures | 4848.85 | 4851.94 | 4847.44 | 4851.66 | 31428.0 |
| 2021-07-01 14:30:00 | ES | Futures | 4851.38 | 4854.2 | 4851.38 | 4853.91 | 36876.0 |
| 2021-07-01 15:00:00 | ES | Futures | 4853.91 | 4855.32 | 4852.22 | 4852.51 | 46646.0 |
| 2021-07-01 15:30:00 | ES | Futures | 4852.79 | 4856.73 | 4850.25 | 4855.04 | 117777.0 |
| 2021-07-01 16:00:00 | ES | Futures | 4855.32 | 4856.17 | 4851.94 | 4852.51 | 34111.0 |
| 2021-07-01 16:30:00 | ES | Futures | 4852.22 | 4855.32 | 4852.22 | 4853.91 | 4769.0 |
| 2021-07-01 18:00:00 | ES | Futures | 4854.2 | 4855.32 | 4852.22 | 4855.04 | 3380.0 |
| 2021-07-01 18:30:00 | ES | Futures | 4854.76 | 4855.6 | 4854.48 | 4855.32 | 1393.0 |
| 2021-07-01 19:00:00 | ES | Futures | 4855.32 | 4856.45 | 4855.04 | 4856.17 | 1199.0 |
| 2021-07-01 19:30:00 | ES | Futures | 4855.89 | 4856.17 | 4853.63 | 4853.91 | 1831.0 |
| 2021-07-01 20:00:00 | ES | Futures | 4853.91 | 4858.98 | 4853.63 | 4857.57 | 4181.0 |
| 2021-07-01 20:30:00 | ES | Futures | 4857.86 | 4859.55 | 4857.01 | 4858.98 | 2549.0 |
| 2021-07-01 21:00:00 | ES | Futures | 4859.26 | 4860.11 | 4857.57 | 4857.86 | 3626.0 |
| 2021-07-01 21:30:00 | ES | Futures | 4858.14 | 4858.14 | 4855.32 | 4855.6 | 4556.0 |
| 2021-07-01 22:00:00 | ES | Futures | 4855.6 | 4857.86 | 4855.04 | 4856.45 | 1945.0 |
| 2021-07-01 22:30:00 | ES | Futures | 4856.45 | 4858.14 | 4855.6 | 4856.17 | 2551.0 |
| 2021-07-01 23:00:00 | ES | Futures | 4856.17 | 4858.42 | 4855.6 | 4857.86 | 2366.0 |
| 2021-07-01 23:30:00 | ES | Futures | 4857.57 | 4858.14 | 4856.45 | 4857.29 | 1496.0 |
| 2021-07-01 00:00:00 | NQ | Futures | 16869.88 | 16872.77 | 16867.85 | 16869.3 | 565.0 |
| 2021-07-01 00:30:00 | NQ | Futures | 16869.01 | 16870.46 | 16851.92 | 16858.29 | 1609.0 |
| 2021-07-01 01:00:00 | NQ | Futures | 16858.29 | 16868.14 | 16858.0 | 16866.4 | 783.0 |
| 2021-07-01 01:30:00 | NQ | Futures | 16866.11 | 16870.46 | 16863.79 | 16867.27 | 1000.0 |
> showing 50 of 3,667 rows — these rows as CSV