PREVIEW / futures_30min / 2011-08-30
file: by_date/futures_30min/2011/2011-08-30.parquet size: 73 KB rows: 2,589
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-30 00:00:00 | ES | Futures | 1204.38 | 1204.63 | 1203.38 | 1203.63 | 1492.0 |
| 2011-08-30 00:30:00 | ES | Futures | 1203.63 | 1204.63 | 1203.38 | 1204.13 | 1254.0 |
| 2011-08-30 01:00:00 | ES | Futures | 1204.13 | 1205.38 | 1203.88 | 1204.88 | 2237.0 |
| 2011-08-30 01:30:00 | ES | Futures | 1204.88 | 1206.13 | 1203.88 | 1204.38 | 3476.0 |
| 2011-08-30 02:00:00 | ES | Futures | 1204.63 | 1204.88 | 1203.13 | 1203.38 | 6232.0 |
| 2011-08-30 02:30:00 | ES | Futures | 1203.63 | 1203.63 | 1200.64 | 1202.13 | 12248.0 |
| 2011-08-30 03:00:00 | ES | Futures | 1202.13 | 1203.63 | 1200.14 | 1201.39 | 25639.0 |
| 2011-08-30 03:30:00 | ES | Futures | 1201.64 | 1203.38 | 1199.64 | 1199.89 | 17269.0 |
| 2011-08-30 04:00:00 | ES | Futures | 1199.89 | 1201.89 | 1199.64 | 1200.14 | 11189.0 |
| 2011-08-30 04:30:00 | ES | Futures | 1200.14 | 1200.39 | 1199.14 | 1199.89 | 15223.0 |
| 2011-08-30 05:00:00 | ES | Futures | 1200.14 | 1200.89 | 1195.65 | 1196.65 | 22639.0 |
| 2011-08-30 05:30:00 | ES | Futures | 1196.65 | 1199.14 | 1196.15 | 1198.64 | 12249.0 |
| 2011-08-30 06:00:00 | ES | Futures | 1198.64 | 1199.14 | 1196.65 | 1198.14 | 10472.0 |
| 2011-08-30 06:30:00 | ES | Futures | 1198.39 | 1200.39 | 1196.65 | 1200.14 | 11849.0 |
| 2011-08-30 07:00:00 | ES | Futures | 1199.89 | 1200.89 | 1198.14 | 1199.39 | 13444.0 |
| 2011-08-30 07:30:00 | ES | Futures | 1199.39 | 1200.14 | 1197.4 | 1198.14 | 11245.0 |
| 2011-08-30 08:00:00 | ES | Futures | 1198.14 | 1198.14 | 1195.15 | 1196.65 | 27806.0 |
| 2011-08-30 08:30:00 | ES | Futures | 1196.9 | 1197.65 | 1193.41 | 1194.9 | 29287.0 |
| 2011-08-30 09:00:00 | ES | Futures | 1194.9 | 1199.89 | 1194.65 | 1199.64 | 36977.0 |
| 2011-08-30 09:30:00 | ES | Futures | 1199.64 | 1203.38 | 1197.15 | 1197.4 | 212475.0 |
| 2011-08-30 10:00:00 | ES | Futures | 1197.4 | 1197.89 | 1190.66 | 1196.9 | 305971.0 |
| 2011-08-30 10:30:00 | ES | Futures | 1196.9 | 1200.14 | 1194.15 | 1197.15 | 192845.0 |
| 2011-08-30 11:00:00 | ES | Futures | 1197.4 | 1205.38 | 1196.15 | 1203.88 | 171268.0 |
| 2011-08-30 11:30:00 | ES | Futures | 1203.88 | 1210.37 | 1202.88 | 1207.87 | 213124.0 |
| 2011-08-30 12:00:00 | ES | Futures | 1207.87 | 1208.37 | 1204.13 | 1204.88 | 86179.0 |
| 2011-08-30 12:30:00 | ES | Futures | 1205.13 | 1205.63 | 1199.14 | 1200.89 | 101568.0 |
| 2011-08-30 13:00:00 | ES | Futures | 1200.64 | 1204.63 | 1198.89 | 1203.13 | 114167.0 |
| 2011-08-30 13:30:00 | ES | Futures | 1203.13 | 1204.38 | 1199.89 | 1202.63 | 81077.0 |
| 2011-08-30 14:00:00 | ES | Futures | 1202.63 | 1209.37 | 1199.89 | 1209.12 | 171939.0 |
| 2011-08-30 14:30:00 | ES | Futures | 1209.37 | 1210.61 | 1205.38 | 1210.12 | 114573.0 |
| 2011-08-30 15:00:00 | ES | Futures | 1209.87 | 1211.11 | 1207.62 | 1211.11 | 79960.0 |
| 2011-08-30 15:30:00 | ES | Futures | 1211.11 | 1215.85 | 1207.37 | 1207.87 | 282089.0 |
| 2011-08-30 16:00:00 | ES | Futures | 1207.87 | 1207.87 | 1200.89 | 1201.89 | 109722.0 |
| 2011-08-30 16:30:00 | ES | Futures | 1201.39 | 1202.13 | 1200.14 | 1201.39 | 6923.0 |
| 2011-08-30 17:00:00 | ES | Futures | 1201.14 | 1201.39 | 1199.39 | 1199.64 | 2742.0 |
| 2011-08-30 18:00:00 | ES | Futures | 1200.14 | 1202.13 | 1199.64 | 1201.14 | 2564.0 |
| 2011-08-30 18:30:00 | ES | Futures | 1201.39 | 1201.39 | 1198.89 | 1199.64 | 1501.0 |
| 2011-08-30 19:00:00 | ES | Futures | 1199.39 | 1199.89 | 1198.89 | 1198.89 | 1255.0 |
| 2011-08-30 19:30:00 | ES | Futures | 1199.14 | 1200.39 | 1198.39 | 1200.14 | 2460.0 |
| 2011-08-30 20:00:00 | ES | Futures | 1200.14 | 1201.39 | 1200.14 | 1201.39 | 3833.0 |
| 2011-08-30 20:30:00 | ES | Futures | 1201.39 | 1201.64 | 1200.39 | 1201.14 | 1851.0 |
| 2011-08-30 21:00:00 | ES | Futures | 1201.14 | 1203.13 | 1200.89 | 1201.89 | 3558.0 |
| 2011-08-30 21:30:00 | ES | Futures | 1201.39 | 1202.38 | 1199.64 | 1200.39 | 3301.0 |
| 2011-08-30 22:00:00 | ES | Futures | 1200.14 | 1201.14 | 1199.89 | 1200.64 | 1208.0 |
| 2011-08-30 22:30:00 | ES | Futures | 1200.64 | 1202.38 | 1200.39 | 1202.13 | 1457.0 |
| 2011-08-30 23:00:00 | ES | Futures | 1202.13 | 1203.63 | 1201.64 | 1203.38 | 2488.0 |
| 2011-08-30 23:30:00 | ES | Futures | 1203.63 | 1204.63 | 1203.13 | 1203.63 | 2599.0 |
| 2011-08-30 00:00:00 | NQ | Futures | 2554.78 | 2555.36 | 2553.34 | 2553.34 | 86.0 |
| 2011-08-30 00:30:00 | NQ | Futures | 2553.63 | 2554.78 | 2553.34 | 2554.49 | 133.0 |
| 2011-08-30 01:00:00 | NQ | Futures | 2554.49 | 2556.22 | 2554.2 | 2555.93 | 145.0 |
> showing 50 of 2,589 rows — these rows as CSV