PREVIEW / stock_5min / 2013-11-26
file: by_date/stock_5min/2013/2013-11-26.parquet size: 5.4 MB rows: 356,020 symbols: 3,561
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-26 06:15:00 | AAPL | Stock | 18.7175 | 18.7175 | 18.7175 | 18.7175 | 2800.0 |
| 2013-11-26 06:30:00 | AAPL | Stock | 18.7146 | 18.7232 | 18.7146 | 18.7204 | 19600.0 |
| 2013-11-26 07:00:00 | AAPL | Stock | 18.7004 | 18.7004 | 18.7 | 18.7 | 8400.0 |
| 2013-11-26 07:30:00 | AAPL | Stock | 18.7371 | 18.7429 | 18.7371 | 18.7429 | 25676.0 |
| 2013-11-26 07:40:00 | AAPL | Stock | 18.7464 | 18.7464 | 18.7429 | 18.7429 | 8400.0 |
| 2013-11-26 07:55:00 | AAPL | Stock | 18.7425 | 18.7475 | 18.7425 | 18.7475 | 39200.0 |
| 2013-11-26 08:00:00 | AAPL | Stock | 18.7357 | 18.7443 | 18.7071 | 18.7443 | 85932.0 |
| 2013-11-26 08:05:00 | AAPL | Stock | 18.7425 | 18.7443 | 18.7425 | 18.7425 | 40376.0 |
| 2013-11-26 08:15:00 | AAPL | Stock | 18.7454 | 18.75 | 18.7454 | 18.7496 | 280980.0 |
| 2013-11-26 08:20:00 | AAPL | Stock | 18.7479 | 18.7564 | 18.7457 | 18.7482 | 78680.0 |
| 2013-11-26 08:25:00 | AAPL | Stock | 18.7579 | 18.7579 | 18.7439 | 18.7439 | 23296.0 |
| 2013-11-26 08:30:00 | AAPL | Stock | 18.7439 | 18.7439 | 18.7407 | 18.7407 | 8400.0 |
| 2013-11-26 08:35:00 | AAPL | Stock | 18.7393 | 18.7657 | 18.7321 | 18.7654 | 212044.0 |
| 2013-11-26 08:40:00 | AAPL | Stock | 18.7593 | 18.7661 | 18.7525 | 18.7579 | 60200.0 |
| 2013-11-26 08:45:00 | AAPL | Stock | 18.7632 | 18.7696 | 18.7571 | 18.7625 | 120960.0 |
| 2013-11-26 08:50:00 | AAPL | Stock | 18.7632 | 18.7657 | 18.7607 | 18.765 | 84000.0 |
| 2013-11-26 08:55:00 | AAPL | Stock | 18.7564 | 18.7564 | 18.755 | 18.755 | 11200.0 |
| 2013-11-26 09:00:00 | AAPL | Stock | 18.7561 | 18.7589 | 18.7529 | 18.7589 | 25200.0 |
| 2013-11-26 09:05:00 | AAPL | Stock | 18.7604 | 18.7643 | 18.7589 | 18.7625 | 63728.0 |
| 2013-11-26 09:10:00 | AAPL | Stock | 18.7568 | 18.7625 | 18.7525 | 18.7625 | 88172.0 |
| 2013-11-26 09:15:00 | AAPL | Stock | 18.7596 | 18.7607 | 18.7521 | 18.7521 | 36344.0 |
| 2013-11-26 09:20:00 | AAPL | Stock | 18.7536 | 18.7586 | 18.7268 | 18.7268 | 196560.0 |
| 2013-11-26 09:25:00 | AAPL | Stock | 18.7321 | 18.7325 | 18.7143 | 18.7143 | 159880.0 |
| 2013-11-26 09:30:00 | AAPL | Stock | 18.7193 | 18.825 | 18.7143 | 18.8154 | 14418516.0 |
| 2013-11-26 09:35:00 | AAPL | Stock | 18.8218 | 18.8286 | 18.8071 | 18.8175 | 8314208.0 |
| 2013-11-26 09:40:00 | AAPL | Stock | 18.8193 | 18.8339 | 18.8107 | 18.8327 | 6633256.0 |
| 2013-11-26 09:45:00 | AAPL | Stock | 18.832 | 18.8482 | 18.8218 | 18.8407 | 6186740.0 |
| 2013-11-26 09:50:00 | AAPL | Stock | 18.8432 | 18.85 | 18.8289 | 18.8482 | 4803904.0 |
| 2013-11-26 09:55:00 | AAPL | Stock | 18.8486 | 18.8518 | 18.8104 | 18.8201 | 4870768.0 |
| 2013-11-26 10:00:00 | AAPL | Stock | 18.8139 | 18.8409 | 18.8114 | 18.8125 | 6728736.0 |
| 2013-11-26 10:05:00 | AAPL | Stock | 18.8129 | 18.8504 | 18.7964 | 18.8407 | 8394792.0 |
| 2013-11-26 10:10:00 | AAPL | Stock | 18.8418 | 18.8764 | 18.8418 | 18.8729 | 8051876.0 |
| 2013-11-26 10:15:00 | AAPL | Stock | 18.8725 | 18.8886 | 18.8711 | 18.8765 | 4550140.0 |
| 2013-11-26 10:20:00 | AAPL | Stock | 18.8777 | 18.9011 | 18.8764 | 18.8971 | 5984356.0 |
| 2013-11-26 10:25:00 | AAPL | Stock | 18.8964 | 18.8982 | 18.8789 | 18.895 | 4341260.0 |
| 2013-11-26 10:30:00 | AAPL | Stock | 18.8964 | 18.9046 | 18.88 | 18.8882 | 4176088.0 |
| 2013-11-26 10:35:00 | AAPL | Stock | 18.8868 | 18.8929 | 18.8829 | 18.8929 | 2711072.0 |
| 2013-11-26 10:40:00 | AAPL | Stock | 18.8929 | 18.9018 | 18.8675 | 18.8804 | 3415972.0 |
| 2013-11-26 10:45:00 | AAPL | Stock | 18.8836 | 18.8836 | 18.8686 | 18.8804 | 3495324.0 |
| 2013-11-26 10:50:00 | AAPL | Stock | 18.8789 | 18.8893 | 18.8775 | 18.8861 | 1694392.0 |
| 2013-11-26 10:55:00 | AAPL | Stock | 18.8871 | 18.8946 | 18.8839 | 18.8893 | 2179716.0 |
| 2013-11-26 11:00:00 | AAPL | Stock | 18.8889 | 18.9089 | 18.8879 | 18.9086 | 3832304.0 |
| 2013-11-26 11:05:00 | AAPL | Stock | 18.9082 | 18.9157 | 18.8886 | 18.8929 | 6169548.0 |
| 2013-11-26 11:10:00 | AAPL | Stock | 18.8929 | 18.9 | 18.8882 | 18.8896 | 3695104.0 |
| 2013-11-26 11:15:00 | AAPL | Stock | 18.89 | 18.8973 | 18.8804 | 18.8943 | 1748908.0 |
| 2013-11-26 11:20:00 | AAPL | Stock | 18.8943 | 18.9107 | 18.8941 | 18.9089 | 1532496.0 |
| 2013-11-26 11:25:00 | AAPL | Stock | 18.9071 | 18.9154 | 18.8943 | 18.9004 | 2626204.0 |
| 2013-11-26 11:30:00 | AAPL | Stock | 18.9 | 18.9142 | 18.8954 | 18.9054 | 2508772.0 |
| 2013-11-26 11:35:00 | AAPL | Stock | 18.9054 | 18.9243 | 18.9046 | 18.9239 | 2653812.0 |
| 2013-11-26 11:40:00 | AAPL | Stock | 18.9232 | 18.9414 | 18.9196 | 18.9364 | 9770712.0 |
> showing 50 of 356,020 rows — these rows as CSV