PREVIEW / futures_30min / 2008-07-22
file: by_date/futures_30min/2008/2008-07-22.parquet size: 67 KB rows: 2,258
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-22 00:00:00 | ES | Futures | 1162.31 | 1163.01 | 1162.31 | 1162.31 | 661.0 |
| 2008-07-22 00:30:00 | ES | Futures | 1162.54 | 1163.94 | 1162.54 | 1163.47 | 636.0 |
| 2008-07-22 01:00:00 | ES | Futures | 1163.47 | 1164.17 | 1163.24 | 1164.17 | 770.0 |
| 2008-07-22 01:30:00 | ES | Futures | 1164.17 | 1165.1 | 1163.01 | 1164.63 | 1814.0 |
| 2008-07-22 02:00:00 | ES | Futures | 1164.87 | 1165.56 | 1163.94 | 1165.56 | 5366.0 |
| 2008-07-22 02:30:00 | ES | Futures | 1165.56 | 1165.56 | 1163.94 | 1165.1 | 3155.0 |
| 2008-07-22 03:00:00 | ES | Futures | 1165.1 | 1165.8 | 1164.63 | 1165.1 | 9485.0 |
| 2008-07-22 03:30:00 | ES | Futures | 1165.33 | 1166.03 | 1163.7 | 1163.94 | 6172.0 |
| 2008-07-22 04:00:00 | ES | Futures | 1163.94 | 1164.17 | 1161.38 | 1162.77 | 7294.0 |
| 2008-07-22 04:30:00 | ES | Futures | 1162.54 | 1163.94 | 1162.31 | 1163.47 | 3608.0 |
| 2008-07-22 05:00:00 | ES | Futures | 1163.47 | 1165.8 | 1163.01 | 1164.63 | 4452.0 |
| 2008-07-22 05:30:00 | ES | Futures | 1164.63 | 1164.87 | 1163.94 | 1164.4 | 2017.0 |
| 2008-07-22 06:00:00 | ES | Futures | 1164.4 | 1165.33 | 1162.31 | 1163.47 | 3874.0 |
| 2008-07-22 06:30:00 | ES | Futures | 1163.01 | 1164.17 | 1160.45 | 1162.31 | 12181.0 |
| 2008-07-22 07:00:00 | ES | Futures | 1162.54 | 1162.77 | 1159.52 | 1161.84 | 26554.0 |
| 2008-07-22 07:30:00 | ES | Futures | 1161.61 | 1163.7 | 1161.38 | 1163.01 | 20895.0 |
| 2008-07-22 08:00:00 | ES | Futures | 1163.01 | 1164.87 | 1161.15 | 1163.24 | 17403.0 |
| 2008-07-22 08:30:00 | ES | Futures | 1163.24 | 1165.33 | 1162.54 | 1164.4 | 20641.0 |
| 2008-07-22 09:00:00 | ES | Futures | 1164.63 | 1164.87 | 1162.77 | 1163.24 | 21098.0 |
| 2008-07-22 09:30:00 | ES | Futures | 1163.24 | 1166.03 | 1160.91 | 1165.56 | 198779.0 |
| 2008-07-22 10:00:00 | ES | Futures | 1165.56 | 1171.61 | 1164.87 | 1168.12 | 229270.0 |
| 2008-07-22 10:30:00 | ES | Futures | 1168.12 | 1170.21 | 1166.49 | 1168.12 | 129587.0 |
| 2008-07-22 11:00:00 | ES | Futures | 1167.89 | 1174.39 | 1167.89 | 1173.7 | 194897.0 |
| 2008-07-22 11:30:00 | ES | Futures | 1173.7 | 1174.39 | 1169.98 | 1171.14 | 101035.0 |
| 2008-07-22 12:00:00 | ES | Futures | 1170.91 | 1174.39 | 1169.75 | 1171.14 | 83751.0 |
| 2008-07-22 12:30:00 | ES | Futures | 1171.14 | 1172.07 | 1169.05 | 1171.61 | 81784.0 |
| 2008-07-22 13:00:00 | ES | Futures | 1171.61 | 1173.0 | 1169.98 | 1171.84 | 56852.0 |
| 2008-07-22 13:30:00 | ES | Futures | 1171.84 | 1173.93 | 1170.44 | 1172.54 | 64016.0 |
| 2008-07-22 14:00:00 | ES | Futures | 1172.77 | 1173.0 | 1168.58 | 1172.3 | 104035.0 |
| 2008-07-22 14:30:00 | ES | Futures | 1172.07 | 1176.02 | 1170.44 | 1175.09 | 128880.0 |
| 2008-07-22 15:00:00 | ES | Futures | 1174.86 | 1178.58 | 1174.39 | 1178.35 | 108018.0 |
| 2008-07-22 15:30:00 | ES | Futures | 1178.35 | 1188.11 | 1177.42 | 1186.95 | 282031.0 |
| 2008-07-22 16:00:00 | ES | Futures | 1186.95 | 1187.41 | 1183.92 | 1184.85 | 104509.0 |
| 2008-07-22 16:30:00 | ES | Futures | 1185.32 | 1187.18 | 1184.39 | 1184.39 | 13087.0 |
| 2008-07-22 17:00:00 | ES | Futures | 1184.16 | 1185.09 | 1183.23 | 1184.39 | 3607.0 |
| 2008-07-22 18:00:00 | ES | Futures | 1184.62 | 1185.09 | 1183.69 | 1184.62 | 1604.0 |
| 2008-07-22 18:30:00 | ES | Futures | 1184.62 | 1184.85 | 1184.39 | 1184.39 | 415.0 |
| 2008-07-22 19:00:00 | ES | Futures | 1184.39 | 1184.85 | 1184.16 | 1184.85 | 767.0 |
| 2008-07-22 19:30:00 | ES | Futures | 1184.85 | 1185.09 | 1184.62 | 1184.85 | 709.0 |
| 2008-07-22 20:00:00 | ES | Futures | 1184.62 | 1184.85 | 1183.69 | 1184.85 | 1866.0 |
| 2008-07-22 20:30:00 | ES | Futures | 1184.85 | 1185.55 | 1184.62 | 1185.55 | 925.0 |
| 2008-07-22 21:00:00 | ES | Futures | 1185.32 | 1185.55 | 1185.09 | 1185.09 | 261.0 |
| 2008-07-22 21:30:00 | ES | Futures | 1185.09 | 1185.32 | 1184.62 | 1185.09 | 599.0 |
| 2008-07-22 22:00:00 | ES | Futures | 1185.09 | 1185.55 | 1184.85 | 1185.09 | 618.0 |
| 2008-07-22 22:30:00 | ES | Futures | 1184.85 | 1185.09 | 1183.69 | 1184.16 | 793.0 |
| 2008-07-22 23:00:00 | ES | Futures | 1184.16 | 1185.09 | 1183.92 | 1184.85 | 360.0 |
| 2008-07-22 23:30:00 | ES | Futures | 1184.85 | 1185.55 | 1184.62 | 1185.32 | 758.0 |
| 2008-07-22 00:00:00 | NQ | Futures | 2021.9 | 2023.03 | 2021.62 | 2022.75 | 11.0 |
| 2008-07-22 00:30:00 | NQ | Futures | 2022.47 | 2024.15 | 2021.34 | 2023.87 | 32.0 |
| 2008-07-22 01:00:00 | NQ | Futures | 2023.59 | 2023.59 | 2022.47 | 2023.03 | 78.0 |
> showing 50 of 2,258 rows — these rows as CSV