PREVIEW / futures_30min / 2008-08-13
file: by_date/futures_30min/2008/2008-08-13.parquet size: 68 KB rows: 2,300
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-08-13 00:00:00 | ES | Futures | 1200.66 | 1201.35 | 1199.96 | 1201.35 | 513.0 |
| 2008-08-13 00:30:00 | ES | Futures | 1201.35 | 1201.59 | 1199.96 | 1200.89 | 623.0 |
| 2008-08-13 01:00:00 | ES | Futures | 1200.89 | 1201.12 | 1200.66 | 1200.89 | 208.0 |
| 2008-08-13 01:30:00 | ES | Futures | 1200.66 | 1200.66 | 1199.26 | 1199.73 | 1630.0 |
| 2008-08-13 02:00:00 | ES | Futures | 1199.96 | 1200.19 | 1199.03 | 1199.5 | 3755.0 |
| 2008-08-13 02:30:00 | ES | Futures | 1199.5 | 1200.66 | 1199.03 | 1199.73 | 1894.0 |
| 2008-08-13 03:00:00 | ES | Futures | 1199.5 | 1201.35 | 1199.26 | 1200.66 | 5102.0 |
| 2008-08-13 03:30:00 | ES | Futures | 1200.43 | 1200.66 | 1198.57 | 1198.8 | 4166.0 |
| 2008-08-13 04:00:00 | ES | Futures | 1198.57 | 1199.96 | 1198.1 | 1199.5 | 4435.0 |
| 2008-08-13 04:30:00 | ES | Futures | 1199.5 | 1201.35 | 1198.8 | 1200.19 | 3653.0 |
| 2008-08-13 05:00:00 | ES | Futures | 1200.19 | 1200.43 | 1198.33 | 1199.03 | 3059.0 |
| 2008-08-13 05:30:00 | ES | Futures | 1199.03 | 1199.96 | 1197.64 | 1198.57 | 4028.0 |
| 2008-08-13 06:00:00 | ES | Futures | 1198.33 | 1200.19 | 1198.33 | 1199.03 | 3954.0 |
| 2008-08-13 06:30:00 | ES | Futures | 1199.03 | 1199.73 | 1198.1 | 1198.57 | 3697.0 |
| 2008-08-13 07:00:00 | ES | Futures | 1198.57 | 1199.26 | 1197.64 | 1197.87 | 3959.0 |
| 2008-08-13 07:30:00 | ES | Futures | 1198.1 | 1198.8 | 1195.78 | 1196.01 | 13839.0 |
| 2008-08-13 08:00:00 | ES | Futures | 1196.01 | 1197.64 | 1192.99 | 1194.15 | 31129.0 |
| 2008-08-13 08:30:00 | ES | Futures | 1194.15 | 1195.78 | 1192.29 | 1194.15 | 35176.0 |
| 2008-08-13 09:00:00 | ES | Futures | 1194.38 | 1195.78 | 1194.38 | 1195.54 | 21228.0 |
| 2008-08-13 09:30:00 | ES | Futures | 1195.31 | 1196.71 | 1190.2 | 1192.76 | 209630.0 |
| 2008-08-13 10:00:00 | ES | Futures | 1192.52 | 1195.31 | 1189.97 | 1190.66 | 163170.0 |
| 2008-08-13 10:30:00 | ES | Futures | 1190.66 | 1191.59 | 1188.11 | 1191.59 | 195475.0 |
| 2008-08-13 11:00:00 | ES | Futures | 1191.59 | 1191.59 | 1186.48 | 1188.8 | 147809.0 |
| 2008-08-13 11:30:00 | ES | Futures | 1188.57 | 1188.8 | 1185.32 | 1186.71 | 121203.0 |
| 2008-08-13 12:00:00 | ES | Futures | 1186.71 | 1188.57 | 1184.85 | 1187.87 | 87054.0 |
| 2008-08-13 12:30:00 | ES | Futures | 1187.64 | 1190.2 | 1186.95 | 1189.73 | 85414.0 |
| 2008-08-13 13:00:00 | ES | Futures | 1189.73 | 1192.06 | 1187.64 | 1191.13 | 96318.0 |
| 2008-08-13 13:30:00 | ES | Futures | 1191.13 | 1197.87 | 1190.9 | 1196.94 | 185810.0 |
| 2008-08-13 14:00:00 | ES | Futures | 1196.94 | 1198.33 | 1194.15 | 1194.38 | 114759.0 |
| 2008-08-13 14:30:00 | ES | Futures | 1194.38 | 1202.98 | 1193.45 | 1201.82 | 165216.0 |
| 2008-08-13 15:00:00 | ES | Futures | 1202.05 | 1203.45 | 1196.47 | 1198.33 | 152817.0 |
| 2008-08-13 15:30:00 | ES | Futures | 1198.33 | 1198.57 | 1190.9 | 1195.78 | 226420.0 |
| 2008-08-13 16:00:00 | ES | Futures | 1195.54 | 1196.01 | 1193.92 | 1194.38 | 66661.0 |
| 2008-08-13 16:30:00 | ES | Futures | 1194.38 | 1195.31 | 1193.45 | 1194.38 | 6589.0 |
| 2008-08-13 17:00:00 | ES | Futures | 1194.15 | 1194.61 | 1193.69 | 1194.15 | 692.0 |
| 2008-08-13 18:00:00 | ES | Futures | 1194.15 | 1195.08 | 1193.92 | 1194.85 | 902.0 |
| 2008-08-13 18:30:00 | ES | Futures | 1194.61 | 1195.31 | 1194.61 | 1195.08 | 394.0 |
| 2008-08-13 19:00:00 | ES | Futures | 1195.08 | 1195.08 | 1194.15 | 1194.15 | 446.0 |
| 2008-08-13 19:30:00 | ES | Futures | 1194.61 | 1195.31 | 1194.15 | 1195.08 | 1115.0 |
| 2008-08-13 20:00:00 | ES | Futures | 1194.85 | 1195.08 | 1193.69 | 1194.61 | 768.0 |
| 2008-08-13 20:30:00 | ES | Futures | 1194.61 | 1196.47 | 1194.38 | 1196.01 | 1560.0 |
| 2008-08-13 21:00:00 | ES | Futures | 1196.24 | 1196.47 | 1195.08 | 1195.54 | 775.0 |
| 2008-08-13 21:30:00 | ES | Futures | 1195.54 | 1196.47 | 1194.85 | 1196.01 | 854.0 |
| 2008-08-13 22:00:00 | ES | Futures | 1196.01 | 1196.94 | 1196.01 | 1196.47 | 805.0 |
| 2008-08-13 22:30:00 | ES | Futures | 1196.47 | 1196.94 | 1196.47 | 1196.47 | 530.0 |
| 2008-08-13 23:00:00 | ES | Futures | 1196.71 | 1196.94 | 1196.01 | 1196.01 | 151.0 |
| 2008-08-13 23:30:00 | ES | Futures | 1196.24 | 1196.94 | 1195.78 | 1196.24 | 771.0 |
| 2008-08-13 00:00:00 | NQ | Futures | 2190.68 | 2190.68 | 2189.55 | 2189.83 | 69.0 |
| 2008-08-13 00:30:00 | NQ | Futures | 2190.4 | 2190.68 | 2188.43 | 2190.11 | 53.0 |
| 2008-08-13 01:00:00 | NQ | Futures | 2190.11 | 2190.68 | 2189.55 | 2190.11 | 24.0 |
> showing 50 of 2,300 rows — these rows as CSV