PREVIEW / stock_5min / 2012-07-11
file: by_date/stock_5min/2012/2012-07-11.parquet size: 4.6 MB rows: 314,860 symbols: 3,466
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-11 04:00:00 | AAPL | Stock | 21.7536 | 21.7536 | 21.7536 | 21.7536 | 2800.0 |
| 2012-07-11 04:40:00 | AAPL | Stock | 21.785 | 21.785 | 21.785 | 21.785 | 2800.0 |
| 2012-07-11 04:45:00 | AAPL | Stock | 21.7854 | 21.7854 | 21.7854 | 21.7854 | 2800.0 |
| 2012-07-11 05:10:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 2800.0 |
| 2012-07-11 06:05:00 | AAPL | Stock | 21.7946 | 21.7946 | 21.7946 | 21.7946 | 13580.0 |
| 2012-07-11 06:25:00 | AAPL | Stock | 21.7911 | 21.7911 | 21.7911 | 21.7911 | 2800.0 |
| 2012-07-11 06:40:00 | AAPL | Stock | 21.7946 | 21.7946 | 21.7946 | 21.7946 | 11200.0 |
| 2012-07-11 07:00:00 | AAPL | Stock | 21.7893 | 21.8036 | 21.7882 | 21.8036 | 89180.0 |
| 2012-07-11 07:05:00 | AAPL | Stock | 21.8036 | 21.8179 | 21.8036 | 21.8129 | 44968.0 |
| 2012-07-11 07:10:00 | AAPL | Stock | 21.8054 | 21.8054 | 21.7832 | 21.7832 | 138432.0 |
| 2012-07-11 07:15:00 | AAPL | Stock | 21.7739 | 21.7739 | 21.7679 | 21.7679 | 16044.0 |
| 2012-07-11 07:20:00 | AAPL | Stock | 21.7557 | 21.7557 | 21.7496 | 21.7496 | 35532.0 |
| 2012-07-11 07:25:00 | AAPL | Stock | 21.7411 | 21.7464 | 21.7407 | 21.7464 | 100296.0 |
| 2012-07-11 07:30:00 | AAPL | Stock | 21.7464 | 21.75 | 21.7407 | 21.7486 | 169344.0 |
| 2012-07-11 07:35:00 | AAPL | Stock | 21.7464 | 21.7496 | 21.7364 | 21.7496 | 102144.0 |
| 2012-07-11 07:40:00 | AAPL | Stock | 21.7536 | 21.7589 | 21.7464 | 21.7493 | 80640.0 |
| 2012-07-11 07:45:00 | AAPL | Stock | 21.7414 | 21.7425 | 21.7375 | 21.7425 | 16800.0 |
| 2012-07-11 07:50:00 | AAPL | Stock | 21.7486 | 21.7486 | 21.6971 | 21.6982 | 222656.0 |
| 2012-07-11 07:55:00 | AAPL | Stock | 21.7004 | 21.7321 | 21.6918 | 21.7093 | 44072.0 |
| 2012-07-11 08:00:00 | AAPL | Stock | 21.7082 | 21.7418 | 21.6643 | 21.6786 | 529676.0 |
| 2012-07-11 08:05:00 | AAPL | Stock | 21.6714 | 21.6861 | 21.65 | 21.6861 | 271040.0 |
| 2012-07-11 08:10:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6429 | 21.6429 | 362768.0 |
| 2012-07-11 08:15:00 | AAPL | Stock | 21.6496 | 21.6689 | 21.6496 | 21.6643 | 126672.0 |
| 2012-07-11 08:20:00 | AAPL | Stock | 21.6621 | 21.6829 | 21.6618 | 21.6829 | 142044.0 |
| 2012-07-11 08:25:00 | AAPL | Stock | 21.6857 | 21.6946 | 21.6732 | 21.6793 | 176232.0 |
| 2012-07-11 08:30:00 | AAPL | Stock | 21.6839 | 21.6975 | 21.6839 | 21.6964 | 56224.0 |
| 2012-07-11 08:35:00 | AAPL | Stock | 21.6964 | 21.7064 | 21.6829 | 21.6925 | 142772.0 |
| 2012-07-11 08:40:00 | AAPL | Stock | 21.6871 | 21.7036 | 21.6836 | 21.7014 | 116200.0 |
| 2012-07-11 08:45:00 | AAPL | Stock | 21.7018 | 21.7036 | 21.6836 | 21.6843 | 189644.0 |
| 2012-07-11 08:50:00 | AAPL | Stock | 21.6907 | 21.6918 | 21.6729 | 21.6789 | 152600.0 |
| 2012-07-11 08:55:00 | AAPL | Stock | 21.6771 | 21.6832 | 21.6629 | 21.6629 | 312760.0 |
| 2012-07-11 09:00:00 | AAPL | Stock | 21.6675 | 21.6718 | 21.6575 | 21.6643 | 235228.0 |
| 2012-07-11 09:05:00 | AAPL | Stock | 21.6643 | 21.6786 | 21.6621 | 21.6786 | 151620.0 |
| 2012-07-11 09:10:00 | AAPL | Stock | 21.6857 | 21.6857 | 21.6771 | 21.6839 | 133280.0 |
| 2012-07-11 09:15:00 | AAPL | Stock | 21.6893 | 21.7036 | 21.6893 | 21.6929 | 116424.0 |
| 2012-07-11 09:20:00 | AAPL | Stock | 21.69 | 21.69 | 21.6632 | 21.6739 | 124152.0 |
| 2012-07-11 09:25:00 | AAPL | Stock | 21.6718 | 21.6821 | 21.6464 | 21.6489 | 364000.0 |
| 2012-07-11 09:30:00 | AAPL | Stock | 21.6471 | 21.685 | 21.5179 | 21.5425 | 17097472.0 |
| 2012-07-11 09:35:00 | AAPL | Stock | 21.54 | 21.5906 | 21.5179 | 21.5461 | 11840528.0 |
| 2012-07-11 09:40:00 | AAPL | Stock | 21.545 | 21.5957 | 21.5321 | 21.575 | 7899248.0 |
| 2012-07-11 09:45:00 | AAPL | Stock | 21.5757 | 21.6239 | 21.5357 | 21.5996 | 7135324.0 |
| 2012-07-11 09:50:00 | AAPL | Stock | 21.599 | 21.6649 | 21.5893 | 21.6475 | 9611700.0 |
| 2012-07-11 09:55:00 | AAPL | Stock | 21.6475 | 21.7021 | 21.6164 | 21.63 | 10673264.0 |
| 2012-07-11 10:00:00 | AAPL | Stock | 21.631 | 21.6611 | 21.6071 | 21.6251 | 5877872.0 |
| 2012-07-11 10:05:00 | AAPL | Stock | 21.6293 | 21.6904 | 21.6229 | 21.6666 | 7008176.0 |
| 2012-07-11 10:10:00 | AAPL | Stock | 21.6693 | 21.6761 | 21.625 | 21.639 | 5189184.0 |
| 2012-07-11 10:15:00 | AAPL | Stock | 21.6357 | 21.6689 | 21.6111 | 21.6558 | 3917200.0 |
| 2012-07-11 10:20:00 | AAPL | Stock | 21.6607 | 21.6775 | 21.6289 | 21.6522 | 4851308.0 |
| 2012-07-11 10:25:00 | AAPL | Stock | 21.6532 | 21.6679 | 21.5893 | 21.6107 | 5355700.0 |
| 2012-07-11 10:30:00 | AAPL | Stock | 21.6098 | 21.6195 | 21.5686 | 21.5879 | 4244632.0 |
> showing 50 of 314,860 rows — these rows as CSV