PREVIEW / futures_30min / 2014-06-09
file: by_date/futures_30min/2014/2014-06-09.parquet size: 70 KB rows: 2,785
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-09 00:00:00 | ES | Futures | 2023.88 | 2024.14 | 2023.62 | 2023.88 | 936.0 |
| 2014-06-09 00:30:00 | ES | Futures | 2024.14 | 2024.14 | 2023.88 | 2024.14 | 384.0 |
| 2014-06-09 01:00:00 | ES | Futures | 2023.88 | 2024.14 | 2023.62 | 2023.62 | 803.0 |
| 2014-06-09 01:30:00 | ES | Futures | 2023.62 | 2023.88 | 2023.36 | 2023.36 | 1108.0 |
| 2014-06-09 02:00:00 | ES | Futures | 2023.62 | 2023.62 | 2022.84 | 2023.1 | 3093.0 |
| 2014-06-09 02:30:00 | ES | Futures | 2023.1 | 2023.62 | 2022.84 | 2023.1 | 1696.0 |
| 2014-06-09 03:00:00 | ES | Futures | 2022.84 | 2023.1 | 2021.8 | 2022.06 | 8154.0 |
| 2014-06-09 03:30:00 | ES | Futures | 2022.06 | 2022.84 | 2021.54 | 2021.8 | 3749.0 |
| 2014-06-09 04:00:00 | ES | Futures | 2021.8 | 2022.84 | 2021.8 | 2022.58 | 3409.0 |
| 2014-06-09 04:30:00 | ES | Futures | 2022.58 | 2023.1 | 2022.32 | 2022.84 | 2694.0 |
| 2014-06-09 05:00:00 | ES | Futures | 2022.58 | 2022.84 | 2022.32 | 2022.58 | 1959.0 |
| 2014-06-09 05:30:00 | ES | Futures | 2022.58 | 2023.36 | 2022.58 | 2022.84 | 2483.0 |
| 2014-06-09 06:00:00 | ES | Futures | 2022.84 | 2023.1 | 2022.32 | 2022.84 | 1828.0 |
| 2014-06-09 06:30:00 | ES | Futures | 2023.1 | 2023.36 | 2022.58 | 2023.1 | 4406.0 |
| 2014-06-09 07:00:00 | ES | Futures | 2023.1 | 2023.1 | 2022.06 | 2022.06 | 4590.0 |
| 2014-06-09 07:30:00 | ES | Futures | 2022.32 | 2023.1 | 2022.32 | 2023.1 | 3053.0 |
| 2014-06-09 08:00:00 | ES | Futures | 2023.1 | 2023.1 | 2022.06 | 2022.58 | 5664.0 |
| 2014-06-09 08:30:00 | ES | Futures | 2022.32 | 2022.58 | 2021.54 | 2022.06 | 9007.0 |
| 2014-06-09 09:00:00 | ES | Futures | 2022.32 | 2023.1 | 2021.28 | 2022.84 | 14536.0 |
| 2014-06-09 09:30:00 | ES | Futures | 2022.84 | 2026.73 | 2022.06 | 2025.18 | 138064.0 |
| 2014-06-09 10:00:00 | ES | Futures | 2025.18 | 2026.21 | 2024.14 | 2025.95 | 56079.0 |
| 2014-06-09 10:30:00 | ES | Futures | 2025.69 | 2027.25 | 2024.66 | 2026.47 | 59183.0 |
| 2014-06-09 11:00:00 | ES | Futures | 2026.73 | 2028.55 | 2025.95 | 2028.55 | 57212.0 |
| 2014-06-09 11:30:00 | ES | Futures | 2028.55 | 2030.37 | 2028.03 | 2029.07 | 58357.0 |
| 2014-06-09 12:00:00 | ES | Futures | 2029.07 | 2029.33 | 2027.25 | 2027.25 | 29919.0 |
| 2014-06-09 12:30:00 | ES | Futures | 2027.25 | 2028.29 | 2026.73 | 2027.25 | 32734.0 |
| 2014-06-09 13:00:00 | ES | Futures | 2026.99 | 2027.51 | 2024.92 | 2025.18 | 33075.0 |
| 2014-06-09 13:30:00 | ES | Futures | 2025.18 | 2026.47 | 2024.66 | 2025.18 | 36181.0 |
| 2014-06-09 14:00:00 | ES | Futures | 2025.18 | 2025.44 | 2021.28 | 2022.06 | 89278.0 |
| 2014-06-09 14:30:00 | ES | Futures | 2022.06 | 2024.4 | 2021.02 | 2023.88 | 68304.0 |
| 2014-06-09 15:00:00 | ES | Futures | 2024.14 | 2026.21 | 2023.62 | 2025.18 | 51354.0 |
| 2014-06-09 15:30:00 | ES | Futures | 2025.44 | 2025.44 | 2023.62 | 2025.44 | 79218.0 |
| 2014-06-09 16:00:00 | ES | Futures | 2025.18 | 2026.47 | 2025.18 | 2025.69 | 66873.0 |
| 2014-06-09 16:30:00 | ES | Futures | 2025.44 | 2025.69 | 2024.4 | 2024.66 | 11082.0 |
| 2014-06-09 17:00:00 | ES | Futures | 2024.4 | 2025.18 | 2024.4 | 2024.92 | 2148.0 |
| 2014-06-09 18:00:00 | ES | Futures | 2024.66 | 2024.92 | 2023.88 | 2024.4 | 2165.0 |
| 2014-06-09 18:30:00 | ES | Futures | 2024.14 | 2024.4 | 2023.88 | 2024.14 | 474.0 |
| 2014-06-09 19:00:00 | ES | Futures | 2023.88 | 2024.92 | 2023.88 | 2024.92 | 1322.0 |
| 2014-06-09 19:30:00 | ES | Futures | 2024.92 | 2024.92 | 2024.4 | 2024.66 | 645.0 |
| 2014-06-09 20:00:00 | ES | Futures | 2024.92 | 2024.92 | 2024.14 | 2024.92 | 2133.0 |
| 2014-06-09 20:30:00 | ES | Futures | 2024.66 | 2024.66 | 2024.14 | 2024.14 | 1024.0 |
| 2014-06-09 21:00:00 | ES | Futures | 2024.4 | 2024.4 | 2023.36 | 2023.62 | 1780.0 |
| 2014-06-09 21:30:00 | ES | Futures | 2023.62 | 2024.14 | 2023.36 | 2023.62 | 1143.0 |
| 2014-06-09 22:00:00 | ES | Futures | 2023.62 | 2024.14 | 2023.36 | 2023.88 | 823.0 |
| 2014-06-09 22:30:00 | ES | Futures | 2023.88 | 2024.14 | 2023.36 | 2023.88 | 677.0 |
| 2014-06-09 23:00:00 | ES | Futures | 2023.88 | 2024.4 | 2023.62 | 2023.88 | 644.0 |
| 2014-06-09 23:30:00 | ES | Futures | 2023.88 | 2024.14 | 2022.84 | 2023.36 | 1059.0 |
| 2014-06-09 00:00:00 | NQ | Futures | 4423.08 | 4423.38 | 4422.21 | 4423.08 | 169.0 |
| 2014-06-09 00:30:00 | NQ | Futures | 4423.38 | 4423.67 | 4422.79 | 4423.38 | 36.0 |
| 2014-06-09 01:00:00 | NQ | Futures | 4423.08 | 4423.38 | 4422.21 | 4422.5 | 108.0 |
> showing 50 of 2,785 rows — these rows as CSV