PREVIEW / stock_5min / 2016-10-21
file: by_date/stock_5min/2016/2016-10-21.parquet size: 5.1 MB rows: 334,933 symbols: 3,191
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-21 04:00:00 | AAPL | Stock | 29.2925 | 29.2925 | 29.2925 | 29.2925 | 800.0 |
| 2016-10-21 04:05:00 | AAPL | Stock | 29.215 | 29.215 | 29.215 | 29.215 | 1320.0 |
| 2016-10-21 04:35:00 | AAPL | Stock | 29.22 | 29.22 | 29.22 | 29.22 | 1640.0 |
| 2016-10-21 04:40:00 | AAPL | Stock | 29.22 | 29.22 | 29.22 | 29.22 | 1096.0 |
| 2016-10-21 05:35:00 | AAPL | Stock | 29.2325 | 29.2325 | 29.2325 | 29.2325 | 880.0 |
| 2016-10-21 05:45:00 | AAPL | Stock | 29.235 | 29.235 | 29.235 | 29.235 | 800.0 |
| 2016-10-21 06:00:00 | AAPL | Stock | 29.2275 | 29.2275 | 29.2275 | 29.2275 | 1192.0 |
| 2016-10-21 06:10:00 | AAPL | Stock | 29.225 | 29.225 | 29.225 | 29.225 | 800.0 |
| 2016-10-21 06:20:00 | AAPL | Stock | 29.215 | 29.215 | 29.2125 | 29.2125 | 4000.0 |
| 2016-10-21 06:25:00 | AAPL | Stock | 29.24 | 29.24 | 29.24 | 29.24 | 1200.0 |
| 2016-10-21 06:30:00 | AAPL | Stock | 29.2125 | 29.2125 | 29.18 | 29.18 | 2000.0 |
| 2016-10-21 06:55:00 | AAPL | Stock | 29.225 | 29.2325 | 29.225 | 29.2325 | 3400.0 |
| 2016-10-21 07:00:00 | AAPL | Stock | 29.225 | 29.225 | 29.225 | 29.225 | 800.0 |
| 2016-10-21 07:05:00 | AAPL | Stock | 29.235 | 29.235 | 29.235 | 29.235 | 556.0 |
| 2016-10-21 07:10:00 | AAPL | Stock | 29.225 | 29.225 | 29.225 | 29.225 | 1200.0 |
| 2016-10-21 07:15:00 | AAPL | Stock | 29.2225 | 29.2225 | 29.2225 | 29.2225 | 508.0 |
| 2016-10-21 07:20:00 | AAPL | Stock | 29.225 | 29.225 | 29.225 | 29.225 | 800.0 |
| 2016-10-21 07:40:00 | AAPL | Stock | 29.2325 | 29.2375 | 29.2325 | 29.2375 | 2244.0 |
| 2016-10-21 07:45:00 | AAPL | Stock | 29.225 | 29.225 | 29.215 | 29.215 | 7868.0 |
| 2016-10-21 07:55:00 | AAPL | Stock | 29.2225 | 29.2225 | 29.2225 | 29.2225 | 12000.0 |
| 2016-10-21 08:00:00 | AAPL | Stock | 29.235 | 29.25 | 29.2 | 29.2 | 36828.0 |
| 2016-10-21 08:05:00 | AAPL | Stock | 29.2575 | 29.265 | 29.2575 | 29.265 | 15224.0 |
| 2016-10-21 08:10:00 | AAPL | Stock | 29.27 | 29.27 | 29.27 | 29.27 | 400.0 |
| 2016-10-21 08:15:00 | AAPL | Stock | 29.27 | 29.275 | 29.27 | 29.275 | 10240.0 |
| 2016-10-21 08:20:00 | AAPL | Stock | 29.275 | 29.3 | 29.275 | 29.275 | 8984.0 |
| 2016-10-21 08:25:00 | AAPL | Stock | 29.265 | 29.2675 | 29.265 | 29.2675 | 14060.0 |
| 2016-10-21 08:30:00 | AAPL | Stock | 29.2625 | 29.28 | 29.2625 | 29.265 | 20028.0 |
| 2016-10-21 08:35:00 | AAPL | Stock | 29.2675 | 29.27 | 29.2675 | 29.27 | 3140.0 |
| 2016-10-21 08:40:00 | AAPL | Stock | 29.275 | 29.275 | 29.275 | 29.275 | 400.0 |
| 2016-10-21 08:45:00 | AAPL | Stock | 29.265 | 29.265 | 29.265 | 29.265 | 2800.0 |
| 2016-10-21 08:50:00 | AAPL | Stock | 29.265 | 29.265 | 29.245 | 29.245 | 12604.0 |
| 2016-10-21 08:55:00 | AAPL | Stock | 29.245 | 29.2475 | 29.2375 | 29.2425 | 6280.0 |
| 2016-10-21 09:00:00 | AAPL | Stock | 29.26 | 29.2725 | 29.2375 | 29.2375 | 30020.0 |
| 2016-10-21 09:05:00 | AAPL | Stock | 29.2375 | 29.2375 | 29.22 | 29.23 | 42760.0 |
| 2016-10-21 09:10:00 | AAPL | Stock | 29.23 | 29.315 | 29.23 | 29.315 | 32224.0 |
| 2016-10-21 09:15:00 | AAPL | Stock | 29.2875 | 29.2875 | 29.2525 | 29.2775 | 6712.0 |
| 2016-10-21 09:20:00 | AAPL | Stock | 29.27 | 29.29 | 29.2625 | 29.28 | 43228.0 |
| 2016-10-21 09:25:00 | AAPL | Stock | 29.2775 | 29.2875 | 29.205 | 29.205 | 126008.0 |
| 2016-10-21 09:30:00 | AAPL | Stock | 29.2025 | 29.2175 | 29.1 | 29.155 | 9997188.0 |
| 2016-10-21 09:35:00 | AAPL | Stock | 29.155 | 29.165 | 29.0775 | 29.1325 | 2962628.0 |
| 2016-10-21 09:40:00 | AAPL | Stock | 29.1325 | 29.2125 | 29.12 | 29.1628 | 2082696.0 |
| 2016-10-21 09:45:00 | AAPL | Stock | 29.165 | 29.19 | 29.1375 | 29.1775 | 1408880.0 |
| 2016-10-21 09:50:00 | AAPL | Stock | 29.175 | 29.1975 | 29.16 | 29.1775 | 1248644.0 |
| 2016-10-21 09:55:00 | AAPL | Stock | 29.1775 | 29.2275 | 29.1725 | 29.2088 | 1420788.0 |
| 2016-10-21 10:00:00 | AAPL | Stock | 29.2075 | 29.2075 | 29.13 | 29.1425 | 1939092.0 |
| 2016-10-21 10:05:00 | AAPL | Stock | 29.1412 | 29.1712 | 29.125 | 29.14 | 1137124.0 |
| 2016-10-21 10:10:00 | AAPL | Stock | 29.1388 | 29.145 | 29.1025 | 29.105 | 1301676.0 |
| 2016-10-21 10:15:00 | AAPL | Stock | 29.105 | 29.135 | 29.1025 | 29.1225 | 1214620.0 |
| 2016-10-21 10:20:00 | AAPL | Stock | 29.125 | 29.1475 | 29.1175 | 29.1375 | 1093168.0 |
| 2016-10-21 10:25:00 | AAPL | Stock | 29.1388 | 29.1562 | 29.1325 | 29.1475 | 736056.0 |
> showing 50 of 334,933 rows — these rows as CSV