PREVIEW / futures_30min / 2014-06-24
file: by_date/futures_30min/2014/2014-06-24.parquet size: 73 KB rows: 2,843
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-24 00:00:00 | ES | Futures | 2033.05 | 2033.83 | 2033.05 | 2033.57 | 921.0 |
| 2014-06-24 00:30:00 | ES | Futures | 2033.83 | 2034.09 | 2033.57 | 2033.83 | 1006.0 |
| 2014-06-24 01:00:00 | ES | Futures | 2034.09 | 2034.35 | 2033.31 | 2034.09 | 1255.0 |
| 2014-06-24 01:30:00 | ES | Futures | 2033.83 | 2034.09 | 2033.31 | 2033.57 | 1523.0 |
| 2014-06-24 02:00:00 | ES | Futures | 2033.57 | 2035.4 | 2033.31 | 2035.13 | 4746.0 |
| 2014-06-24 02:30:00 | ES | Futures | 2035.13 | 2035.92 | 2034.87 | 2035.92 | 2891.0 |
| 2014-06-24 03:00:00 | ES | Futures | 2035.66 | 2036.18 | 2034.87 | 2034.87 | 11916.0 |
| 2014-06-24 03:30:00 | ES | Futures | 2035.13 | 2035.4 | 2034.09 | 2034.61 | 7449.0 |
| 2014-06-24 04:00:00 | ES | Futures | 2034.61 | 2035.4 | 2033.57 | 2033.83 | 10818.0 |
| 2014-06-24 04:30:00 | ES | Futures | 2034.09 | 2034.09 | 2032.53 | 2033.05 | 9050.0 |
| 2014-06-24 05:00:00 | ES | Futures | 2033.31 | 2033.57 | 2029.66 | 2030.44 | 17939.0 |
| 2014-06-24 05:30:00 | ES | Futures | 2030.44 | 2031.23 | 2029.92 | 2030.44 | 5078.0 |
| 2014-06-24 06:00:00 | ES | Futures | 2030.44 | 2031.75 | 2030.18 | 2030.96 | 6894.0 |
| 2014-06-24 06:30:00 | ES | Futures | 2031.23 | 2032.53 | 2030.96 | 2032.27 | 4842.0 |
| 2014-06-24 07:00:00 | ES | Futures | 2032.53 | 2032.79 | 2031.49 | 2032.27 | 10313.0 |
| 2014-06-24 07:30:00 | ES | Futures | 2032.01 | 2032.79 | 2031.23 | 2032.27 | 8535.0 |
| 2014-06-24 08:00:00 | ES | Futures | 2032.01 | 2034.09 | 2032.01 | 2033.31 | 10043.0 |
| 2014-06-24 08:30:00 | ES | Futures | 2033.57 | 2034.35 | 2033.05 | 2033.57 | 11134.0 |
| 2014-06-24 09:00:00 | ES | Futures | 2033.83 | 2033.83 | 2032.79 | 2033.31 | 16018.0 |
| 2014-06-24 09:30:00 | ES | Futures | 2033.05 | 2036.7 | 2032.79 | 2034.09 | 126503.0 |
| 2014-06-24 10:00:00 | ES | Futures | 2034.35 | 2040.87 | 2034.09 | 2040.61 | 164887.0 |
| 2014-06-24 10:30:00 | ES | Futures | 2040.87 | 2042.43 | 2040.61 | 2041.91 | 75375.0 |
| 2014-06-24 11:00:00 | ES | Futures | 2042.17 | 2043.21 | 2041.65 | 2041.91 | 69201.0 |
| 2014-06-24 11:30:00 | ES | Futures | 2041.91 | 2042.17 | 2041.13 | 2041.65 | 41944.0 |
| 2014-06-24 12:00:00 | ES | Futures | 2041.91 | 2041.91 | 2040.61 | 2041.39 | 27801.0 |
| 2014-06-24 12:30:00 | ES | Futures | 2041.13 | 2041.39 | 2039.04 | 2039.57 | 38144.0 |
| 2014-06-24 13:00:00 | ES | Futures | 2039.3 | 2039.57 | 2033.83 | 2035.92 | 121150.0 |
| 2014-06-24 13:30:00 | ES | Futures | 2035.66 | 2036.96 | 2033.31 | 2033.83 | 63241.0 |
| 2014-06-24 14:00:00 | ES | Futures | 2033.83 | 2035.92 | 2031.23 | 2032.01 | 76443.0 |
| 2014-06-24 14:30:00 | ES | Futures | 2032.01 | 2032.53 | 2030.18 | 2031.23 | 76351.0 |
| 2014-06-24 15:00:00 | ES | Futures | 2030.96 | 2031.23 | 2022.89 | 2024.19 | 196686.0 |
| 2014-06-24 15:30:00 | ES | Futures | 2023.93 | 2026.53 | 2022.1 | 2024.19 | 192755.0 |
| 2014-06-24 16:00:00 | ES | Futures | 2024.19 | 2026.27 | 2024.19 | 2025.75 | 78829.0 |
| 2014-06-24 16:30:00 | ES | Futures | 2025.49 | 2026.27 | 2024.71 | 2024.97 | 6177.0 |
| 2014-06-24 17:00:00 | ES | Futures | 2024.71 | 2025.49 | 2024.45 | 2024.45 | 2670.0 |
| 2014-06-24 18:00:00 | ES | Futures | 2024.71 | 2025.49 | 2023.41 | 2023.93 | 3133.0 |
| 2014-06-24 18:30:00 | ES | Futures | 2023.93 | 2024.97 | 2023.93 | 2024.19 | 1152.0 |
| 2014-06-24 19:00:00 | ES | Futures | 2024.45 | 2024.45 | 2023.67 | 2023.67 | 597.0 |
| 2014-06-24 19:30:00 | ES | Futures | 2023.67 | 2024.97 | 2023.67 | 2024.71 | 1096.0 |
| 2014-06-24 20:00:00 | ES | Futures | 2024.97 | 2025.49 | 2024.45 | 2024.97 | 1952.0 |
| 2014-06-24 20:30:00 | ES | Futures | 2024.71 | 2025.23 | 2024.45 | 2025.23 | 1144.0 |
| 2014-06-24 21:00:00 | ES | Futures | 2025.23 | 2025.23 | 2024.19 | 2024.71 | 2007.0 |
| 2014-06-24 21:30:00 | ES | Futures | 2024.71 | 2025.75 | 2024.45 | 2025.49 | 1984.0 |
| 2014-06-24 22:00:00 | ES | Futures | 2025.49 | 2025.49 | 2023.93 | 2024.45 | 3188.0 |
| 2014-06-24 22:30:00 | ES | Futures | 2024.45 | 2024.97 | 2023.93 | 2024.45 | 1470.0 |
| 2014-06-24 23:00:00 | ES | Futures | 2024.45 | 2024.45 | 2022.36 | 2022.63 | 3745.0 |
| 2014-06-24 23:30:00 | ES | Futures | 2022.89 | 2023.15 | 2022.63 | 2022.89 | 1422.0 |
| 2014-06-24 00:00:00 | NQ | Futures | 4428.11 | 4428.99 | 4428.11 | 4428.69 | 115.0 |
| 2014-06-24 00:30:00 | NQ | Futures | 4428.69 | 4428.99 | 4428.4 | 4428.99 | 104.0 |
| 2014-06-24 01:00:00 | NQ | Futures | 4428.99 | 4430.45 | 4428.11 | 4429.86 | 258.0 |
> showing 50 of 2,843 rows — these rows as CSV