PREVIEW / stock_5min / 2016-05-20
file: by_date/stock_5min/2016/2016-05-20.parquet size: 5.2 MB rows: 347,331 symbols: 3,293
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-05-20 04:00:00 | AAPL | Stock | 23.675 | 23.7225 | 23.675 | 23.7225 | 2480.0 |
| 2016-05-20 04:05:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 6076.0 |
| 2016-05-20 04:30:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 480.0 |
| 2016-05-20 04:35:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 504.0 |
| 2016-05-20 05:15:00 | AAPL | Stock | 23.655 | 23.655 | 23.6525 | 23.6525 | 1200.0 |
| 2016-05-20 05:20:00 | AAPL | Stock | 23.6525 | 23.6525 | 23.65 | 23.65 | 5760.0 |
| 2016-05-20 05:35:00 | AAPL | Stock | 23.6925 | 23.6925 | 23.6925 | 23.6925 | 1400.0 |
| 2016-05-20 05:40:00 | AAPL | Stock | 23.6775 | 23.6775 | 23.6775 | 23.6775 | 2000.0 |
| 2016-05-20 05:55:00 | AAPL | Stock | 23.6775 | 23.6775 | 23.6775 | 23.6775 | 2748.0 |
| 2016-05-20 06:05:00 | AAPL | Stock | 23.6775 | 23.6775 | 23.6775 | 23.6775 | 1880.0 |
| 2016-05-20 06:10:00 | AAPL | Stock | 23.6675 | 23.6675 | 23.6675 | 23.6675 | 448.0 |
| 2016-05-20 06:25:00 | AAPL | Stock | 23.675 | 23.675 | 23.675 | 23.675 | 1240.0 |
| 2016-05-20 06:50:00 | AAPL | Stock | 23.6675 | 23.67 | 23.6675 | 23.67 | 2000.0 |
| 2016-05-20 07:40:00 | AAPL | Stock | 23.6425 | 23.6425 | 23.6425 | 23.6425 | 800.0 |
| 2016-05-20 07:45:00 | AAPL | Stock | 23.65 | 23.66 | 23.65 | 23.66 | 2000.0 |
| 2016-05-20 07:50:00 | AAPL | Stock | 23.65 | 23.65 | 23.63 | 23.63 | 9468.0 |
| 2016-05-20 07:55:00 | AAPL | Stock | 23.635 | 23.635 | 23.63 | 23.63 | 1200.0 |
| 2016-05-20 08:00:00 | AAPL | Stock | 23.65 | 23.675 | 23.58 | 23.595 | 58580.0 |
| 2016-05-20 08:05:00 | AAPL | Stock | 23.595 | 23.6025 | 23.5875 | 23.6 | 33576.0 |
| 2016-05-20 08:10:00 | AAPL | Stock | 23.605 | 23.6175 | 23.605 | 23.6175 | 22424.0 |
| 2016-05-20 08:15:00 | AAPL | Stock | 23.6175 | 23.6325 | 23.6175 | 23.6325 | 10020.0 |
| 2016-05-20 08:20:00 | AAPL | Stock | 23.6375 | 23.64 | 23.635 | 23.635 | 5160.0 |
| 2016-05-20 08:25:00 | AAPL | Stock | 23.635 | 23.645 | 23.6325 | 23.6425 | 41880.0 |
| 2016-05-20 08:30:00 | AAPL | Stock | 23.63 | 23.645 | 23.63 | 23.6425 | 8868.0 |
| 2016-05-20 08:35:00 | AAPL | Stock | 23.635 | 23.6375 | 23.6175 | 23.6375 | 13204.0 |
| 2016-05-20 08:40:00 | AAPL | Stock | 23.625 | 23.64 | 23.625 | 23.64 | 10540.0 |
| 2016-05-20 08:45:00 | AAPL | Stock | 23.6425 | 23.6625 | 23.6325 | 23.6475 | 41272.0 |
| 2016-05-20 08:50:00 | AAPL | Stock | 23.65 | 23.65 | 23.6375 | 23.65 | 27116.0 |
| 2016-05-20 08:55:00 | AAPL | Stock | 23.6475 | 23.65 | 23.6225 | 23.6225 | 39160.0 |
| 2016-05-20 09:00:00 | AAPL | Stock | 23.6275 | 23.6275 | 23.6 | 23.6125 | 71428.0 |
| 2016-05-20 09:05:00 | AAPL | Stock | 23.6075 | 23.6175 | 23.605 | 23.6175 | 2600.0 |
| 2016-05-20 09:10:00 | AAPL | Stock | 23.6175 | 23.645 | 23.6175 | 23.645 | 30944.0 |
| 2016-05-20 09:15:00 | AAPL | Stock | 23.6325 | 23.6475 | 23.625 | 23.6375 | 19180.0 |
| 2016-05-20 09:20:00 | AAPL | Stock | 23.6475 | 23.6725 | 23.64 | 23.6725 | 41244.0 |
| 2016-05-20 09:25:00 | AAPL | Stock | 23.655 | 23.675 | 23.6025 | 23.675 | 398488.0 |
| 2016-05-20 09:30:00 | AAPL | Stock | 23.675 | 23.7425 | 23.63 | 23.701 | 10747664.0 |
| 2016-05-20 09:35:00 | AAPL | Stock | 23.7 | 23.7375 | 23.6675 | 23.69 | 2355212.0 |
| 2016-05-20 09:40:00 | AAPL | Stock | 23.6875 | 23.73 | 23.665 | 23.7125 | 2284736.0 |
| 2016-05-20 09:45:00 | AAPL | Stock | 23.7125 | 23.736 | 23.685 | 23.7315 | 1928244.0 |
| 2016-05-20 09:50:00 | AAPL | Stock | 23.73 | 23.775 | 23.7275 | 23.7425 | 3363040.0 |
| 2016-05-20 09:55:00 | AAPL | Stock | 23.745 | 23.7625 | 23.7025 | 23.75 | 1827520.0 |
| 2016-05-20 10:00:00 | AAPL | Stock | 23.7475 | 23.7625 | 23.725 | 23.7575 | 1897532.0 |
| 2016-05-20 10:05:00 | AAPL | Stock | 23.7562 | 23.775 | 23.7415 | 23.7625 | 2055804.0 |
| 2016-05-20 10:10:00 | AAPL | Stock | 23.7625 | 23.7825 | 23.7525 | 23.7775 | 1540632.0 |
| 2016-05-20 10:15:00 | AAPL | Stock | 23.7775 | 23.7925 | 23.765 | 23.78 | 1791040.0 |
| 2016-05-20 10:20:00 | AAPL | Stock | 23.78 | 23.7875 | 23.7312 | 23.7425 | 2198700.0 |
| 2016-05-20 10:25:00 | AAPL | Stock | 23.7425 | 23.75 | 23.705 | 23.7138 | 1545988.0 |
| 2016-05-20 10:30:00 | AAPL | Stock | 23.7148 | 23.7425 | 23.71 | 23.73 | 1867100.0 |
| 2016-05-20 10:35:00 | AAPL | Stock | 23.73 | 23.74 | 23.7138 | 23.7352 | 983148.0 |
| 2016-05-20 10:40:00 | AAPL | Stock | 23.7362 | 23.7775 | 23.735 | 23.775 | 1389360.0 |
> showing 50 of 347,331 rows — these rows as CSV