PREVIEW / futures_5min / 2011-09-07
file: by_date/futures_5min/2011/2011-09-07.parquet size: 221 KB rows: 12,401
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-09-07 00:00:00 | ES | Futures | 1167.97 | 1167.97 | 1167.72 | 1167.97 | 79.0 |
| 2011-09-07 00:05:00 | ES | Futures | 1167.97 | 1168.22 | 1167.72 | 1168.22 | 86.0 |
| 2011-09-07 00:10:00 | ES | Futures | 1168.22 | 1168.46 | 1167.97 | 1168.46 | 169.0 |
| 2011-09-07 00:15:00 | ES | Futures | 1168.22 | 1168.71 | 1167.97 | 1167.97 | 126.0 |
| 2011-09-07 00:20:00 | ES | Futures | 1168.22 | 1168.71 | 1168.22 | 1168.46 | 121.0 |
| 2011-09-07 00:25:00 | ES | Futures | 1168.22 | 1168.22 | 1167.97 | 1168.22 | 220.0 |
| 2011-09-07 00:30:00 | ES | Futures | 1167.97 | 1168.46 | 1167.97 | 1167.97 | 92.0 |
| 2011-09-07 00:35:00 | ES | Futures | 1167.97 | 1168.22 | 1167.72 | 1167.97 | 82.0 |
| 2011-09-07 00:40:00 | ES | Futures | 1167.97 | 1168.22 | 1167.97 | 1167.97 | 258.0 |
| 2011-09-07 00:45:00 | ES | Futures | 1167.97 | 1168.22 | 1167.72 | 1167.97 | 127.0 |
| 2011-09-07 00:50:00 | ES | Futures | 1167.97 | 1168.22 | 1167.72 | 1167.97 | 60.0 |
| 2011-09-07 00:55:00 | ES | Futures | 1167.97 | 1168.46 | 1167.97 | 1168.22 | 171.0 |
| 2011-09-07 01:00:00 | ES | Futures | 1168.22 | 1169.71 | 1167.97 | 1169.21 | 767.0 |
| 2011-09-07 01:05:00 | ES | Futures | 1169.21 | 1170.21 | 1168.96 | 1169.71 | 1134.0 |
| 2011-09-07 01:10:00 | ES | Futures | 1169.71 | 1169.96 | 1168.96 | 1168.96 | 331.0 |
| 2011-09-07 01:15:00 | ES | Futures | 1168.71 | 1169.96 | 1168.71 | 1169.96 | 358.0 |
| 2011-09-07 01:20:00 | ES | Futures | 1169.46 | 1169.96 | 1169.21 | 1169.46 | 430.0 |
| 2011-09-07 01:25:00 | ES | Futures | 1169.21 | 1170.21 | 1169.21 | 1169.46 | 510.0 |
| 2011-09-07 01:30:00 | ES | Futures | 1169.46 | 1169.71 | 1169.21 | 1169.21 | 312.0 |
| 2011-09-07 01:35:00 | ES | Futures | 1169.21 | 1169.96 | 1169.21 | 1169.96 | 407.0 |
| 2011-09-07 01:40:00 | ES | Futures | 1169.96 | 1169.96 | 1168.96 | 1168.96 | 483.0 |
| 2011-09-07 01:45:00 | ES | Futures | 1169.21 | 1169.46 | 1168.71 | 1168.96 | 647.0 |
| 2011-09-07 01:50:00 | ES | Futures | 1168.96 | 1169.21 | 1168.22 | 1168.46 | 793.0 |
| 2011-09-07 01:55:00 | ES | Futures | 1168.46 | 1169.21 | 1168.46 | 1168.71 | 467.0 |
| 2011-09-07 02:00:00 | ES | Futures | 1168.96 | 1170.96 | 1168.96 | 1170.46 | 3518.0 |
| 2011-09-07 02:05:00 | ES | Futures | 1170.21 | 1171.96 | 1170.21 | 1171.96 | 3118.0 |
| 2011-09-07 02:10:00 | ES | Futures | 1171.71 | 1173.7 | 1171.46 | 1173.2 | 6620.0 |
| 2011-09-07 02:15:00 | ES | Futures | 1173.45 | 1173.45 | 1171.71 | 1172.7 | 2606.0 |
| 2011-09-07 02:20:00 | ES | Futures | 1172.46 | 1173.45 | 1172.21 | 1172.95 | 2333.0 |
| 2011-09-07 02:25:00 | ES | Futures | 1172.95 | 1173.7 | 1172.46 | 1173.45 | 1562.0 |
| 2011-09-07 02:30:00 | ES | Futures | 1173.2 | 1173.45 | 1172.46 | 1172.7 | 1343.0 |
| 2011-09-07 02:35:00 | ES | Futures | 1172.7 | 1172.95 | 1171.96 | 1172.95 | 1075.0 |
| 2011-09-07 02:40:00 | ES | Futures | 1172.95 | 1173.95 | 1172.7 | 1173.7 | 2128.0 |
| 2011-09-07 02:45:00 | ES | Futures | 1173.7 | 1173.95 | 1173.2 | 1173.45 | 2060.0 |
| 2011-09-07 02:50:00 | ES | Futures | 1173.45 | 1173.7 | 1172.21 | 1172.46 | 2148.0 |
| 2011-09-07 02:55:00 | ES | Futures | 1172.46 | 1173.95 | 1172.21 | 1173.7 | 2094.0 |
| 2011-09-07 03:00:00 | ES | Futures | 1173.45 | 1175.2 | 1172.7 | 1172.95 | 10191.0 |
| 2011-09-07 03:05:00 | ES | Futures | 1172.95 | 1173.45 | 1170.71 | 1171.46 | 5536.0 |
| 2011-09-07 03:10:00 | ES | Futures | 1171.71 | 1171.71 | 1169.21 | 1170.71 | 7534.0 |
| 2011-09-07 03:15:00 | ES | Futures | 1170.71 | 1172.21 | 1170.46 | 1171.46 | 4815.0 |
| 2011-09-07 03:20:00 | ES | Futures | 1171.71 | 1171.71 | 1169.46 | 1170.21 | 4579.0 |
| 2011-09-07 03:25:00 | ES | Futures | 1170.21 | 1171.96 | 1170.21 | 1171.21 | 3893.0 |
| 2011-09-07 03:30:00 | ES | Futures | 1171.21 | 1172.21 | 1169.71 | 1171.96 | 5065.0 |
| 2011-09-07 03:35:00 | ES | Futures | 1171.71 | 1172.46 | 1171.21 | 1172.21 | 2501.0 |
| 2011-09-07 03:40:00 | ES | Futures | 1172.21 | 1173.2 | 1172.21 | 1172.95 | 3139.0 |
| 2011-09-07 03:45:00 | ES | Futures | 1172.7 | 1172.7 | 1170.71 | 1171.46 | 3481.0 |
| 2011-09-07 03:50:00 | ES | Futures | 1171.21 | 1171.96 | 1170.46 | 1170.96 | 4529.0 |
| 2011-09-07 03:55:00 | ES | Futures | 1170.71 | 1171.71 | 1169.96 | 1171.71 | 2177.0 |
| 2011-09-07 04:00:00 | ES | Futures | 1171.71 | 1173.95 | 1171.46 | 1173.2 | 2911.0 |
| 2011-09-07 04:05:00 | ES | Futures | 1173.2 | 1175.2 | 1171.96 | 1171.96 | 10054.0 |
> showing 50 of 12,401 rows — these rows as CSV