PREVIEW / stock_5min / 2016-06-28
file: by_date/stock_5min/2016/2016-06-28.parquet size: 5.5 MB rows: 365,497 symbols: 3,278
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-06-28 04:00:00 | AAPL | Stock | 23.1375 | 23.25 | 23.1375 | 23.25 | 8200.0 |
| 2016-06-28 04:05:00 | AAPL | Stock | 23.2225 | 23.2225 | 23.2225 | 23.2225 | 1960.0 |
| 2016-06-28 04:35:00 | AAPL | Stock | 23.2425 | 23.2425 | 23.2425 | 23.2425 | 400.0 |
| 2016-06-28 04:40:00 | AAPL | Stock | 23.2625 | 23.2625 | 23.2225 | 23.2225 | 1580.0 |
| 2016-06-28 04:45:00 | AAPL | Stock | 23.2225 | 23.2225 | 23.2225 | 23.2225 | 400.0 |
| 2016-06-28 05:15:00 | AAPL | Stock | 23.2225 | 23.2225 | 23.2125 | 23.2125 | 2000.0 |
| 2016-06-28 05:35:00 | AAPL | Stock | 23.2 | 23.2125 | 23.2 | 23.2 | 2260.0 |
| 2016-06-28 05:45:00 | AAPL | Stock | 23.2325 | 23.2325 | 23.2325 | 23.2325 | 2000.0 |
| 2016-06-28 05:50:00 | AAPL | Stock | 23.2375 | 23.2625 | 23.2375 | 23.2625 | 1480.0 |
| 2016-06-28 05:55:00 | AAPL | Stock | 23.2525 | 23.2525 | 23.25 | 23.25 | 4764.0 |
| 2016-06-28 06:00:00 | AAPL | Stock | 23.2525 | 23.2525 | 23.25 | 23.2525 | 9200.0 |
| 2016-06-28 06:05:00 | AAPL | Stock | 23.31 | 23.31 | 23.31 | 23.31 | 1336.0 |
| 2016-06-28 06:10:00 | AAPL | Stock | 23.3225 | 23.3225 | 23.3 | 23.3 | 6400.0 |
| 2016-06-28 06:15:00 | AAPL | Stock | 23.2525 | 23.2525 | 23.2525 | 23.2525 | 2400.0 |
| 2016-06-28 06:20:00 | AAPL | Stock | 23.2525 | 23.2525 | 23.25 | 23.2525 | 4200.0 |
| 2016-06-28 06:35:00 | AAPL | Stock | 23.255 | 23.255 | 23.24 | 23.24 | 6008.0 |
| 2016-06-28 06:55:00 | AAPL | Stock | 23.25 | 23.25 | 23.2375 | 23.2375 | 8080.0 |
| 2016-06-28 07:00:00 | AAPL | Stock | 23.2475 | 23.2475 | 23.2325 | 23.2325 | 9200.0 |
| 2016-06-28 07:05:00 | AAPL | Stock | 23.225 | 23.25 | 23.2125 | 23.245 | 18000.0 |
| 2016-06-28 07:10:00 | AAPL | Stock | 23.245 | 23.25 | 23.2375 | 23.2375 | 10816.0 |
| 2016-06-28 07:15:00 | AAPL | Stock | 23.2275 | 23.2275 | 23.2025 | 23.22 | 4528.0 |
| 2016-06-28 07:20:00 | AAPL | Stock | 23.22 | 23.22 | 23.22 | 23.22 | 1200.0 |
| 2016-06-28 07:25:00 | AAPL | Stock | 23.225 | 23.225 | 23.2225 | 23.2225 | 1400.0 |
| 2016-06-28 07:30:00 | AAPL | Stock | 23.225 | 23.24 | 23.22 | 23.22 | 7440.0 |
| 2016-06-28 07:35:00 | AAPL | Stock | 23.22 | 23.235 | 23.215 | 23.2225 | 15640.0 |
| 2016-06-28 07:40:00 | AAPL | Stock | 23.2125 | 23.2125 | 23.2125 | 23.2125 | 400.0 |
| 2016-06-28 07:50:00 | AAPL | Stock | 23.2375 | 23.26 | 23.2375 | 23.26 | 18180.0 |
| 2016-06-28 07:55:00 | AAPL | Stock | 23.2575 | 23.2625 | 23.2475 | 23.2475 | 5220.0 |
| 2016-06-28 08:00:00 | AAPL | Stock | 23.25 | 23.31 | 23.2125 | 23.2375 | 162396.0 |
| 2016-06-28 08:05:00 | AAPL | Stock | 23.2375 | 23.26 | 23.2375 | 23.24 | 43312.0 |
| 2016-06-28 08:10:00 | AAPL | Stock | 23.24 | 23.255 | 23.24 | 23.2525 | 57476.0 |
| 2016-06-28 08:15:00 | AAPL | Stock | 23.25 | 23.255 | 23.2375 | 23.2475 | 27672.0 |
| 2016-06-28 08:20:00 | AAPL | Stock | 23.25 | 23.2875 | 23.2475 | 23.2875 | 113320.0 |
| 2016-06-28 08:25:00 | AAPL | Stock | 23.27 | 23.29 | 23.27 | 23.2875 | 67940.0 |
| 2016-06-28 08:30:00 | AAPL | Stock | 23.2825 | 23.2975 | 23.28 | 23.295 | 39460.0 |
| 2016-06-28 08:35:00 | AAPL | Stock | 23.295 | 23.3125 | 23.2875 | 23.3 | 141508.0 |
| 2016-06-28 08:40:00 | AAPL | Stock | 23.3025 | 23.3125 | 23.3 | 23.3125 | 71624.0 |
| 2016-06-28 08:45:00 | AAPL | Stock | 23.315 | 23.33 | 23.315 | 23.325 | 59012.0 |
| 2016-06-28 08:50:00 | AAPL | Stock | 23.325 | 23.325 | 23.2975 | 23.2975 | 52496.0 |
| 2016-06-28 08:55:00 | AAPL | Stock | 23.295 | 23.2975 | 23.28 | 23.2875 | 36544.0 |
| 2016-06-28 09:00:00 | AAPL | Stock | 23.2825 | 23.2825 | 23.25 | 23.2625 | 82900.0 |
| 2016-06-28 09:05:00 | AAPL | Stock | 23.27 | 23.2725 | 23.2525 | 23.27 | 35840.0 |
| 2016-06-28 09:10:00 | AAPL | Stock | 23.27 | 23.28 | 23.2575 | 23.28 | 20544.0 |
| 2016-06-28 09:15:00 | AAPL | Stock | 23.3 | 23.3 | 23.275 | 23.2775 | 27280.0 |
| 2016-06-28 09:20:00 | AAPL | Stock | 23.28 | 23.2975 | 23.25 | 23.2975 | 165280.0 |
| 2016-06-28 09:25:00 | AAPL | Stock | 23.3 | 23.3025 | 23.2025 | 23.2225 | 212192.0 |
| 2016-06-28 09:30:00 | AAPL | Stock | 23.2225 | 23.2675 | 23.155 | 23.2075 | 8872224.0 |
| 2016-06-28 09:35:00 | AAPL | Stock | 23.205 | 23.21 | 23.13 | 23.1725 | 4386344.0 |
| 2016-06-28 09:40:00 | AAPL | Stock | 23.1748 | 23.2475 | 23.165 | 23.205 | 4040100.0 |
| 2016-06-28 09:45:00 | AAPL | Stock | 23.2025 | 23.2225 | 23.1775 | 23.22 | 2549140.0 |
> showing 50 of 365,497 rows — these rows as CSV