PREVIEW / futures_30min / 2010-10-18
file: by_date/futures_30min/2010/2010-10-18.parquet size: 73 KB rows: 2,619
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-18 00:00:00 | ES | Futures | 1152.29 | 1152.54 | 1151.3 | 1151.55 | 1750.0 |
| 2010-10-18 00:30:00 | ES | Futures | 1151.8 | 1152.78 | 1151.55 | 1152.78 | 1357.0 |
| 2010-10-18 01:00:00 | ES | Futures | 1152.54 | 1152.78 | 1151.06 | 1151.3 | 3639.0 |
| 2010-10-18 01:30:00 | ES | Futures | 1151.06 | 1151.3 | 1150.07 | 1150.32 | 4130.0 |
| 2010-10-18 02:00:00 | ES | Futures | 1150.32 | 1152.29 | 1149.58 | 1151.8 | 7297.0 |
| 2010-10-18 02:30:00 | ES | Futures | 1151.8 | 1152.78 | 1151.06 | 1151.3 | 5845.0 |
| 2010-10-18 03:00:00 | ES | Futures | 1151.3 | 1151.8 | 1149.82 | 1150.56 | 13149.0 |
| 2010-10-18 03:30:00 | ES | Futures | 1150.56 | 1151.55 | 1149.33 | 1149.82 | 13988.0 |
| 2010-10-18 04:00:00 | ES | Futures | 1150.07 | 1150.56 | 1148.35 | 1150.32 | 16595.0 |
| 2010-10-18 04:30:00 | ES | Futures | 1150.32 | 1152.29 | 1149.33 | 1151.3 | 7647.0 |
| 2010-10-18 05:00:00 | ES | Futures | 1151.3 | 1153.52 | 1151.06 | 1152.54 | 9712.0 |
| 2010-10-18 05:30:00 | ES | Futures | 1152.78 | 1154.75 | 1152.29 | 1153.77 | 9425.0 |
| 2010-10-18 06:00:00 | ES | Futures | 1153.52 | 1155.25 | 1152.78 | 1155.25 | 9295.0 |
| 2010-10-18 06:30:00 | ES | Futures | 1155.0 | 1155.49 | 1154.26 | 1154.51 | 5678.0 |
| 2010-10-18 07:00:00 | ES | Futures | 1154.51 | 1154.51 | 1153.03 | 1153.52 | 7196.0 |
| 2010-10-18 07:30:00 | ES | Futures | 1153.52 | 1154.75 | 1152.78 | 1153.27 | 8305.0 |
| 2010-10-18 08:00:00 | ES | Futures | 1153.52 | 1156.73 | 1151.55 | 1155.99 | 37901.0 |
| 2010-10-18 08:30:00 | ES | Futures | 1155.99 | 1156.97 | 1155.25 | 1156.73 | 23462.0 |
| 2010-10-18 09:00:00 | ES | Futures | 1156.73 | 1157.22 | 1153.77 | 1156.23 | 37614.0 |
| 2010-10-18 09:30:00 | ES | Futures | 1156.23 | 1159.93 | 1154.01 | 1158.94 | 175974.0 |
| 2010-10-18 10:00:00 | ES | Futures | 1158.94 | 1161.65 | 1157.46 | 1158.94 | 174051.0 |
| 2010-10-18 10:30:00 | ES | Futures | 1158.94 | 1161.41 | 1158.2 | 1161.16 | 84887.0 |
| 2010-10-18 11:00:00 | ES | Futures | 1161.16 | 1161.41 | 1157.22 | 1158.94 | 95608.0 |
| 2010-10-18 11:30:00 | ES | Futures | 1158.7 | 1159.19 | 1156.97 | 1158.94 | 49951.0 |
| 2010-10-18 12:00:00 | ES | Futures | 1159.19 | 1159.93 | 1158.45 | 1158.94 | 38391.0 |
| 2010-10-18 12:30:00 | ES | Futures | 1158.7 | 1159.68 | 1157.96 | 1158.45 | 29218.0 |
| 2010-10-18 13:00:00 | ES | Futures | 1158.45 | 1160.18 | 1158.45 | 1158.94 | 31778.0 |
| 2010-10-18 13:30:00 | ES | Futures | 1159.19 | 1160.18 | 1158.7 | 1159.19 | 32167.0 |
| 2010-10-18 14:00:00 | ES | Futures | 1159.44 | 1162.15 | 1158.7 | 1161.65 | 72887.0 |
| 2010-10-18 14:30:00 | ES | Futures | 1161.65 | 1162.39 | 1161.16 | 1162.15 | 48941.0 |
| 2010-10-18 15:00:00 | ES | Futures | 1161.9 | 1165.6 | 1161.9 | 1163.87 | 137787.0 |
| 2010-10-18 15:30:00 | ES | Futures | 1164.12 | 1165.35 | 1163.38 | 1164.12 | 125181.0 |
| 2010-10-18 16:00:00 | ES | Futures | 1164.12 | 1165.35 | 1161.41 | 1162.15 | 94561.0 |
| 2010-10-18 16:30:00 | ES | Futures | 1162.15 | 1162.89 | 1154.75 | 1155.49 | 46487.0 |
| 2010-10-18 17:00:00 | ES | Futures | 1155.49 | 1157.96 | 1155.0 | 1155.99 | 13154.0 |
| 2010-10-18 18:00:00 | ES | Futures | 1156.23 | 1156.97 | 1155.0 | 1155.49 | 6968.0 |
| 2010-10-18 18:30:00 | ES | Futures | 1155.25 | 1156.23 | 1154.75 | 1155.99 | 3545.0 |
| 2010-10-18 19:00:00 | ES | Futures | 1155.99 | 1157.46 | 1155.99 | 1156.97 | 3060.0 |
| 2010-10-18 19:30:00 | ES | Futures | 1156.73 | 1157.46 | 1156.73 | 1157.22 | 1953.0 |
| 2010-10-18 20:00:00 | ES | Futures | 1157.22 | 1159.19 | 1157.22 | 1158.94 | 8073.0 |
| 2010-10-18 20:30:00 | ES | Futures | 1158.94 | 1159.44 | 1157.22 | 1158.2 | 4258.0 |
| 2010-10-18 21:00:00 | ES | Futures | 1157.96 | 1158.2 | 1156.23 | 1156.48 | 3954.0 |
| 2010-10-18 21:30:00 | ES | Futures | 1156.73 | 1157.46 | 1155.99 | 1156.23 | 4529.0 |
| 2010-10-18 22:00:00 | ES | Futures | 1156.23 | 1157.22 | 1155.74 | 1156.48 | 2700.0 |
| 2010-10-18 22:30:00 | ES | Futures | 1156.48 | 1157.46 | 1155.99 | 1156.97 | 1934.0 |
| 2010-10-18 23:00:00 | ES | Futures | 1157.22 | 1157.46 | 1156.73 | 1157.22 | 1019.0 |
| 2010-10-18 23:30:00 | ES | Futures | 1157.46 | 1157.46 | 1155.25 | 1155.25 | 2266.0 |
| 2010-10-18 00:00:00 | NQ | Futures | 2394.49 | 2394.49 | 2391.91 | 2393.05 | 60.0 |
| 2010-10-18 00:30:00 | NQ | Futures | 2393.05 | 2395.92 | 2393.05 | 2395.92 | 97.0 |
| 2010-10-18 01:00:00 | NQ | Futures | 2395.92 | 2395.92 | 2393.05 | 2393.05 | 347.0 |
> showing 50 of 2,619 rows — these rows as CSV