PREVIEW / futures_30min / 2010-10-19
file: by_date/futures_30min/2010/2010-10-19.parquet size: 79 KB rows: 2,719
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-19 00:00:00 | ES | Futures | 1155.25 | 1155.74 | 1155.0 | 1155.49 | 1984.0 |
| 2010-10-19 00:30:00 | ES | Futures | 1155.49 | 1155.74 | 1154.26 | 1154.26 | 3052.0 |
| 2010-10-19 01:00:00 | ES | Futures | 1154.26 | 1155.0 | 1154.01 | 1154.51 | 2493.0 |
| 2010-10-19 01:30:00 | ES | Futures | 1154.75 | 1155.49 | 1154.26 | 1155.49 | 3222.0 |
| 2010-10-19 02:00:00 | ES | Futures | 1155.49 | 1156.73 | 1155.49 | 1156.48 | 5455.0 |
| 2010-10-19 02:30:00 | ES | Futures | 1156.48 | 1157.22 | 1155.49 | 1155.74 | 4762.0 |
| 2010-10-19 03:00:00 | ES | Futures | 1155.74 | 1157.22 | 1155.0 | 1156.97 | 10755.0 |
| 2010-10-19 03:30:00 | ES | Futures | 1156.97 | 1159.19 | 1156.97 | 1157.71 | 12620.0 |
| 2010-10-19 04:00:00 | ES | Futures | 1157.71 | 1159.19 | 1157.46 | 1158.45 | 7208.0 |
| 2010-10-19 04:30:00 | ES | Futures | 1158.45 | 1158.7 | 1157.46 | 1157.46 | 3443.0 |
| 2010-10-19 05:00:00 | ES | Futures | 1157.46 | 1159.93 | 1157.46 | 1159.44 | 12934.0 |
| 2010-10-19 05:30:00 | ES | Futures | 1159.44 | 1159.93 | 1158.7 | 1159.19 | 8813.0 |
| 2010-10-19 06:00:00 | ES | Futures | 1159.19 | 1159.44 | 1158.2 | 1158.94 | 7757.0 |
| 2010-10-19 06:30:00 | ES | Futures | 1158.94 | 1161.41 | 1158.94 | 1159.44 | 19477.0 |
| 2010-10-19 07:00:00 | ES | Futures | 1159.44 | 1159.93 | 1153.77 | 1156.48 | 70813.0 |
| 2010-10-19 07:30:00 | ES | Futures | 1156.48 | 1156.48 | 1152.54 | 1154.75 | 45517.0 |
| 2010-10-19 08:00:00 | ES | Futures | 1154.75 | 1155.74 | 1152.78 | 1154.26 | 55964.0 |
| 2010-10-19 08:30:00 | ES | Futures | 1154.75 | 1156.23 | 1152.54 | 1153.03 | 39374.0 |
| 2010-10-19 09:00:00 | ES | Futures | 1153.03 | 1153.27 | 1149.08 | 1150.81 | 74114.0 |
| 2010-10-19 09:30:00 | ES | Futures | 1150.81 | 1153.03 | 1146.37 | 1148.59 | 323845.0 |
| 2010-10-19 10:00:00 | ES | Futures | 1148.59 | 1155.0 | 1147.61 | 1154.01 | 254821.0 |
| 2010-10-19 10:30:00 | ES | Futures | 1154.01 | 1155.99 | 1152.29 | 1153.77 | 216931.0 |
| 2010-10-19 11:00:00 | ES | Futures | 1153.77 | 1154.26 | 1151.3 | 1152.29 | 149413.0 |
| 2010-10-19 11:30:00 | ES | Futures | 1152.29 | 1157.22 | 1152.29 | 1156.48 | 117598.0 |
| 2010-10-19 12:00:00 | ES | Futures | 1156.48 | 1157.22 | 1154.51 | 1155.0 | 67408.0 |
| 2010-10-19 12:30:00 | ES | Futures | 1155.0 | 1155.25 | 1153.03 | 1155.0 | 53319.0 |
| 2010-10-19 13:00:00 | ES | Futures | 1155.0 | 1155.0 | 1151.55 | 1151.55 | 73631.0 |
| 2010-10-19 13:30:00 | ES | Futures | 1151.55 | 1152.78 | 1146.62 | 1147.36 | 136596.0 |
| 2010-10-19 14:00:00 | ES | Futures | 1147.36 | 1147.61 | 1140.95 | 1142.92 | 401839.0 |
| 2010-10-19 14:30:00 | ES | Futures | 1142.68 | 1146.62 | 1141.94 | 1144.65 | 160812.0 |
| 2010-10-19 15:00:00 | ES | Futures | 1144.65 | 1145.63 | 1139.96 | 1140.21 | 175812.0 |
| 2010-10-19 15:30:00 | ES | Futures | 1140.21 | 1146.37 | 1139.23 | 1146.13 | 297094.0 |
| 2010-10-19 16:00:00 | ES | Futures | 1146.13 | 1147.61 | 1145.63 | 1147.61 | 132791.0 |
| 2010-10-19 16:30:00 | ES | Futures | 1147.61 | 1147.85 | 1146.13 | 1146.37 | 6712.0 |
| 2010-10-19 17:00:00 | ES | Futures | 1146.37 | 1147.36 | 1146.37 | 1146.62 | 2685.0 |
| 2010-10-19 18:00:00 | ES | Futures | 1146.37 | 1146.87 | 1146.13 | 1146.37 | 3014.0 |
| 2010-10-19 18:30:00 | ES | Futures | 1146.62 | 1146.62 | 1145.39 | 1145.39 | 1665.0 |
| 2010-10-19 19:00:00 | ES | Futures | 1145.39 | 1145.88 | 1144.65 | 1145.63 | 2668.0 |
| 2010-10-19 19:30:00 | ES | Futures | 1145.63 | 1145.63 | 1144.15 | 1144.4 | 2916.0 |
| 2010-10-19 20:00:00 | ES | Futures | 1144.65 | 1145.63 | 1144.15 | 1145.39 | 6056.0 |
| 2010-10-19 20:30:00 | ES | Futures | 1145.39 | 1145.88 | 1144.15 | 1145.39 | 3713.0 |
| 2010-10-19 21:00:00 | ES | Futures | 1145.39 | 1147.11 | 1145.14 | 1146.13 | 4605.0 |
| 2010-10-19 21:30:00 | ES | Futures | 1146.13 | 1149.08 | 1146.13 | 1147.85 | 11146.0 |
| 2010-10-19 22:00:00 | ES | Futures | 1147.85 | 1148.84 | 1147.61 | 1148.59 | 2746.0 |
| 2010-10-19 22:30:00 | ES | Futures | 1148.59 | 1149.82 | 1148.1 | 1149.58 | 4208.0 |
| 2010-10-19 23:00:00 | ES | Futures | 1149.58 | 1149.58 | 1149.08 | 1149.08 | 2137.0 |
| 2010-10-19 23:30:00 | ES | Futures | 1149.33 | 1150.56 | 1148.59 | 1150.32 | 3864.0 |
| 2010-10-19 00:00:00 | NQ | Futures | 2370.39 | 2371.25 | 2369.81 | 2371.25 | 409.0 |
| 2010-10-19 00:30:00 | NQ | Futures | 2370.68 | 2372.4 | 2369.81 | 2371.54 | 346.0 |
| 2010-10-19 01:00:00 | NQ | Futures | 2371.82 | 2372.11 | 2370.68 | 2371.54 | 208.0 |
> showing 50 of 2,719 rows — these rows as CSV