PREVIEW / futures_30min / 2011-08-29
file: by_date/futures_30min/2011/2011-08-29.parquet size: 68 KB rows: 2,393
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-29 00:00:00 | ES | Futures | 1182.18 | 1185.67 | 1182.18 | 1185.18 | 6120.0 |
| 2011-08-29 00:30:00 | ES | Futures | 1185.18 | 1185.42 | 1183.18 | 1183.43 | 3836.0 |
| 2011-08-29 01:00:00 | ES | Futures | 1183.43 | 1185.18 | 1182.93 | 1184.93 | 2764.0 |
| 2011-08-29 01:30:00 | ES | Futures | 1185.18 | 1185.18 | 1182.43 | 1183.18 | 2948.0 |
| 2011-08-29 02:00:00 | ES | Futures | 1182.93 | 1184.93 | 1182.68 | 1182.93 | 5912.0 |
| 2011-08-29 02:30:00 | ES | Futures | 1182.93 | 1183.68 | 1182.18 | 1183.18 | 4945.0 |
| 2011-08-29 03:00:00 | ES | Futures | 1183.18 | 1185.18 | 1182.18 | 1183.93 | 13510.0 |
| 2011-08-29 03:30:00 | ES | Futures | 1184.18 | 1185.18 | 1182.93 | 1183.93 | 11354.0 |
| 2011-08-29 04:00:00 | ES | Futures | 1183.93 | 1184.93 | 1183.18 | 1184.68 | 7501.0 |
| 2011-08-29 04:30:00 | ES | Futures | 1184.68 | 1185.18 | 1183.18 | 1184.18 | 6287.0 |
| 2011-08-29 05:00:00 | ES | Futures | 1184.18 | 1185.67 | 1184.18 | 1185.42 | 5390.0 |
| 2011-08-29 05:30:00 | ES | Futures | 1185.18 | 1185.42 | 1183.93 | 1184.43 | 5513.0 |
| 2011-08-29 06:00:00 | ES | Futures | 1184.43 | 1184.93 | 1182.68 | 1183.18 | 6273.0 |
| 2011-08-29 06:30:00 | ES | Futures | 1183.18 | 1185.18 | 1182.68 | 1184.68 | 6073.0 |
| 2011-08-29 07:00:00 | ES | Futures | 1184.68 | 1188.17 | 1184.68 | 1185.92 | 19055.0 |
| 2011-08-29 07:30:00 | ES | Futures | 1185.67 | 1186.92 | 1183.93 | 1184.43 | 11821.0 |
| 2011-08-29 08:00:00 | ES | Futures | 1184.43 | 1185.92 | 1183.68 | 1185.18 | 13526.0 |
| 2011-08-29 08:30:00 | ES | Futures | 1185.18 | 1187.42 | 1184.93 | 1185.67 | 30939.0 |
| 2011-08-29 09:00:00 | ES | Futures | 1185.92 | 1187.92 | 1185.18 | 1186.92 | 32089.0 |
| 2011-08-29 09:30:00 | ES | Futures | 1186.92 | 1193.9 | 1186.17 | 1192.41 | 211772.0 |
| 2011-08-29 10:00:00 | ES | Futures | 1192.41 | 1195.9 | 1190.41 | 1193.16 | 139559.0 |
| 2011-08-29 10:30:00 | ES | Futures | 1193.41 | 1194.9 | 1191.16 | 1192.41 | 130971.0 |
| 2011-08-29 11:00:00 | ES | Futures | 1192.16 | 1192.66 | 1189.17 | 1191.41 | 118916.0 |
| 2011-08-29 11:30:00 | ES | Futures | 1191.41 | 1195.65 | 1190.91 | 1193.9 | 111639.0 |
| 2011-08-29 12:00:00 | ES | Futures | 1194.15 | 1197.15 | 1193.9 | 1195.9 | 74630.0 |
| 2011-08-29 12:30:00 | ES | Futures | 1196.15 | 1199.14 | 1195.15 | 1197.89 | 93214.0 |
| 2011-08-29 13:00:00 | ES | Futures | 1197.89 | 1200.89 | 1197.65 | 1198.89 | 68997.0 |
| 2011-08-29 13:30:00 | ES | Futures | 1199.14 | 1199.39 | 1196.9 | 1198.14 | 60124.0 |
| 2011-08-29 14:00:00 | ES | Futures | 1198.14 | 1201.89 | 1197.89 | 1201.64 | 69888.0 |
| 2011-08-29 14:30:00 | ES | Futures | 1201.64 | 1203.13 | 1200.14 | 1201.14 | 98307.0 |
| 2011-08-29 15:00:00 | ES | Futures | 1201.14 | 1203.63 | 1200.39 | 1203.13 | 82438.0 |
| 2011-08-29 15:30:00 | ES | Futures | 1203.38 | 1205.63 | 1202.38 | 1205.13 | 218257.0 |
| 2011-08-29 16:00:00 | ES | Futures | 1204.88 | 1205.88 | 1203.63 | 1205.38 | 100496.0 |
| 2011-08-29 16:30:00 | ES | Futures | 1205.13 | 1205.88 | 1204.38 | 1204.63 | 6276.0 |
| 2011-08-29 17:00:00 | ES | Futures | 1204.63 | 1205.38 | 1204.13 | 1204.63 | 2584.0 |
| 2011-08-29 18:00:00 | ES | Futures | 1204.38 | 1204.63 | 1203.88 | 1204.13 | 2315.0 |
| 2011-08-29 18:30:00 | ES | Futures | 1204.13 | 1204.38 | 1203.63 | 1203.88 | 1364.0 |
| 2011-08-29 19:00:00 | ES | Futures | 1204.13 | 1204.38 | 1203.88 | 1204.13 | 694.0 |
| 2011-08-29 19:30:00 | ES | Futures | 1204.13 | 1204.88 | 1203.88 | 1204.63 | 1982.0 |
| 2011-08-29 20:00:00 | ES | Futures | 1204.63 | 1206.87 | 1203.88 | 1206.37 | 5274.0 |
| 2011-08-29 20:30:00 | ES | Futures | 1206.37 | 1207.12 | 1204.63 | 1205.13 | 4554.0 |
| 2011-08-29 21:00:00 | ES | Futures | 1205.38 | 1205.88 | 1203.63 | 1204.13 | 3786.0 |
| 2011-08-29 21:30:00 | ES | Futures | 1203.88 | 1205.38 | 1203.88 | 1204.63 | 2247.0 |
| 2011-08-29 22:00:00 | ES | Futures | 1204.88 | 1206.13 | 1204.63 | 1206.13 | 2307.0 |
| 2011-08-29 22:30:00 | ES | Futures | 1205.88 | 1206.62 | 1205.63 | 1205.88 | 1830.0 |
| 2011-08-29 23:00:00 | ES | Futures | 1205.63 | 1205.88 | 1204.13 | 1204.88 | 2479.0 |
| 2011-08-29 23:30:00 | ES | Futures | 1204.88 | 1205.63 | 1203.88 | 1204.38 | 1422.0 |
| 2011-08-29 00:00:00 | NQ | Futures | 2506.44 | 2515.07 | 2506.15 | 2513.92 | 867.0 |
| 2011-08-29 00:30:00 | NQ | Futures | 2513.63 | 2514.49 | 2511.04 | 2512.19 | 516.0 |
| 2011-08-29 01:00:00 | NQ | Futures | 2511.62 | 2516.51 | 2511.62 | 2514.21 | 196.0 |
> showing 50 of 2,393 rows — these rows as CSV