PREVIEW / stock_5min / 2011-11-17
file: by_date/stock_5min/2011/2011-11-17.parquet size: 4.8 MB rows: 324,782 symbols: 3,499
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-17 05:50:00 | AAPL | Stock | 13.7143 | 13.7143 | 13.7143 | 13.7143 | 2800.0 |
| 2011-11-17 06:35:00 | AAPL | Stock | 13.7264 | 13.7264 | 13.7264 | 13.7264 | 2800.0 |
| 2011-11-17 06:40:00 | AAPL | Stock | 13.7221 | 13.7221 | 13.7143 | 13.7143 | 16800.0 |
| 2011-11-17 06:50:00 | AAPL | Stock | 13.7082 | 13.7082 | 13.6893 | 13.6893 | 8400.0 |
| 2011-11-17 07:00:00 | AAPL | Stock | 13.6893 | 13.6943 | 13.6643 | 13.6643 | 74200.0 |
| 2011-11-17 07:05:00 | AAPL | Stock | 13.6829 | 13.6829 | 13.6786 | 13.6786 | 19600.0 |
| 2011-11-17 07:10:00 | AAPL | Stock | 13.6786 | 13.6886 | 13.6775 | 13.6786 | 19600.0 |
| 2011-11-17 07:15:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6682 | 13.6786 | 25200.0 |
| 2011-11-17 07:20:00 | AAPL | Stock | 13.6732 | 13.6768 | 13.6732 | 13.6732 | 16800.0 |
| 2011-11-17 07:25:00 | AAPL | Stock | 13.6746 | 13.6821 | 13.6746 | 13.6821 | 19600.0 |
| 2011-11-17 07:30:00 | AAPL | Stock | 13.6821 | 13.6857 | 13.6736 | 13.6736 | 47012.0 |
| 2011-11-17 07:40:00 | AAPL | Stock | 13.6839 | 13.7143 | 13.6839 | 13.7143 | 33600.0 |
| 2011-11-17 07:45:00 | AAPL | Stock | 13.6843 | 13.6843 | 13.6839 | 13.6839 | 8400.0 |
| 2011-11-17 07:55:00 | AAPL | Stock | 13.7046 | 13.7046 | 13.7046 | 13.7046 | 2800.0 |
| 2011-11-17 08:00:00 | AAPL | Stock | 13.7118 | 13.7136 | 13.71 | 13.7136 | 24416.0 |
| 2011-11-17 08:05:00 | AAPL | Stock | 13.7107 | 13.7107 | 13.6886 | 13.6936 | 44800.0 |
| 2011-11-17 08:10:00 | AAPL | Stock | 13.7 | 13.7 | 13.6893 | 13.6893 | 24080.0 |
| 2011-11-17 08:15:00 | AAPL | Stock | 13.6932 | 13.7036 | 13.6886 | 13.6893 | 23912.0 |
| 2011-11-17 08:20:00 | AAPL | Stock | 13.6893 | 13.6932 | 13.6893 | 13.6932 | 5600.0 |
| 2011-11-17 08:25:00 | AAPL | Stock | 13.6932 | 13.7089 | 13.6932 | 13.7089 | 84056.0 |
| 2011-11-17 08:30:00 | AAPL | Stock | 13.7125 | 13.725 | 13.7125 | 13.725 | 140644.0 |
| 2011-11-17 08:35:00 | AAPL | Stock | 13.725 | 13.725 | 13.7179 | 13.7196 | 185108.0 |
| 2011-11-17 08:40:00 | AAPL | Stock | 13.7232 | 13.7232 | 13.7061 | 13.7214 | 144480.0 |
| 2011-11-17 08:45:00 | AAPL | Stock | 13.7179 | 13.7179 | 13.7107 | 13.7114 | 50400.0 |
| 2011-11-17 08:50:00 | AAPL | Stock | 13.7089 | 13.7418 | 13.7071 | 13.7107 | 1787520.0 |
| 2011-11-17 08:55:00 | AAPL | Stock | 13.7143 | 13.7232 | 13.7143 | 13.7207 | 51520.0 |
| 2011-11-17 09:00:00 | AAPL | Stock | 13.7189 | 13.7429 | 13.7186 | 13.7407 | 623308.0 |
| 2011-11-17 09:05:00 | AAPL | Stock | 13.7364 | 13.7646 | 13.7325 | 13.7571 | 327684.0 |
| 2011-11-17 09:10:00 | AAPL | Stock | 13.7618 | 13.7636 | 13.7429 | 13.7518 | 86688.0 |
| 2011-11-17 09:15:00 | AAPL | Stock | 13.7564 | 13.7625 | 13.75 | 13.75 | 81452.0 |
| 2011-11-17 09:20:00 | AAPL | Stock | 13.7539 | 13.7586 | 13.73 | 13.7343 | 295036.0 |
| 2011-11-17 09:25:00 | AAPL | Stock | 13.7343 | 13.7343 | 13.6854 | 13.7032 | 942760.0 |
| 2011-11-17 09:30:00 | AAPL | Stock | 13.7136 | 13.735 | 13.6614 | 13.6786 | 9736888.0 |
| 2011-11-17 09:35:00 | AAPL | Stock | 13.6768 | 13.6818 | 13.6429 | 13.675 | 8806336.0 |
| 2011-11-17 09:40:00 | AAPL | Stock | 13.6739 | 13.6939 | 13.65 | 13.6518 | 7374668.0 |
| 2011-11-17 09:45:00 | AAPL | Stock | 13.6521 | 13.6675 | 13.6429 | 13.6625 | 6811084.0 |
| 2011-11-17 09:50:00 | AAPL | Stock | 13.6636 | 13.6771 | 13.6486 | 13.665 | 6172936.0 |
| 2011-11-17 09:55:00 | AAPL | Stock | 13.665 | 13.7043 | 13.6504 | 13.6997 | 8343860.0 |
| 2011-11-17 10:00:00 | AAPL | Stock | 13.7032 | 13.7221 | 13.6854 | 13.7171 | 7208908.0 |
| 2011-11-17 10:05:00 | AAPL | Stock | 13.7171 | 13.7171 | 13.6821 | 13.6821 | 4342688.0 |
| 2011-11-17 10:10:00 | AAPL | Stock | 13.6804 | 13.695 | 13.6714 | 13.6714 | 3571652.0 |
| 2011-11-17 10:15:00 | AAPL | Stock | 13.6746 | 13.6904 | 13.6657 | 13.69 | 3334044.0 |
| 2011-11-17 10:20:00 | AAPL | Stock | 13.69 | 13.7054 | 13.6479 | 13.6536 | 5562620.0 |
| 2011-11-17 10:25:00 | AAPL | Stock | 13.6536 | 13.7 | 13.6471 | 13.6964 | 6459796.0 |
| 2011-11-17 10:30:00 | AAPL | Stock | 13.6968 | 13.6993 | 13.6589 | 13.6911 | 5607084.0 |
| 2011-11-17 10:35:00 | AAPL | Stock | 13.6907 | 13.7086 | 13.6732 | 13.6779 | 4013268.0 |
| 2011-11-17 10:40:00 | AAPL | Stock | 13.6768 | 13.6911 | 13.6625 | 13.6679 | 2227232.0 |
| 2011-11-17 10:45:00 | AAPL | Stock | 13.6668 | 13.6886 | 13.6664 | 13.6729 | 2641184.0 |
| 2011-11-17 10:50:00 | AAPL | Stock | 13.6736 | 13.6843 | 13.6611 | 13.6664 | 3258052.0 |
| 2011-11-17 10:55:00 | AAPL | Stock | 13.6632 | 13.6839 | 13.6571 | 13.6611 | 6533016.0 |
> showing 50 of 324,782 rows — these rows as CSV