PREVIEW / stock_5min / 2012-04-16
file: by_date/stock_5min/2012/2012-04-16.parquet size: 4.7 MB rows: 322,176 symbols: 3,527
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-04-16 04:00:00 | AAPL | Stock | 21.5671 | 21.5982 | 21.5671 | 21.5786 | 16800.0 |
| 2012-04-16 04:05:00 | AAPL | Stock | 21.5786 | 21.5979 | 21.5786 | 21.5786 | 22400.0 |
| 2012-04-16 04:10:00 | AAPL | Stock | 21.5786 | 21.5786 | 21.5714 | 21.5714 | 5600.0 |
| 2012-04-16 04:15:00 | AAPL | Stock | 21.5679 | 21.5679 | 21.5679 | 21.5679 | 5600.0 |
| 2012-04-16 04:20:00 | AAPL | Stock | 21.5536 | 21.5536 | 21.5536 | 21.5536 | 2800.0 |
| 2012-04-16 04:55:00 | AAPL | Stock | 21.5893 | 21.5893 | 21.5893 | 21.5893 | 11200.0 |
| 2012-04-16 05:00:00 | AAPL | Stock | 21.6036 | 21.6036 | 21.6036 | 21.6036 | 5600.0 |
| 2012-04-16 05:20:00 | AAPL | Stock | 21.5982 | 21.5982 | 21.5982 | 21.5982 | 5600.0 |
| 2012-04-16 05:30:00 | AAPL | Stock | 21.6068 | 21.6143 | 21.6068 | 21.6143 | 14000.0 |
| 2012-04-16 05:35:00 | AAPL | Stock | 21.6214 | 21.6214 | 21.6214 | 21.6214 | 2800.0 |
| 2012-04-16 06:05:00 | AAPL | Stock | 21.6929 | 21.6929 | 21.6929 | 21.6929 | 2800.0 |
| 2012-04-16 06:10:00 | AAPL | Stock | 21.6964 | 21.6964 | 21.6964 | 21.6964 | 4228.0 |
| 2012-04-16 06:15:00 | AAPL | Stock | 21.7 | 21.7125 | 21.7 | 21.7054 | 12740.0 |
| 2012-04-16 06:20:00 | AAPL | Stock | 21.7 | 21.7 | 21.7 | 21.7 | 8400.0 |
| 2012-04-16 06:25:00 | AAPL | Stock | 21.6986 | 21.6986 | 21.6986 | 21.6986 | 2800.0 |
| 2012-04-16 06:35:00 | AAPL | Stock | 21.7036 | 21.7036 | 21.6964 | 21.6964 | 19880.0 |
| 2012-04-16 06:50:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6761 | 21.6786 | 25200.0 |
| 2012-04-16 06:55:00 | AAPL | Stock | 21.6786 | 21.6804 | 21.6786 | 21.6804 | 49224.0 |
| 2012-04-16 07:00:00 | AAPL | Stock | 21.6786 | 21.6886 | 21.675 | 21.6857 | 175644.0 |
| 2012-04-16 07:05:00 | AAPL | Stock | 21.6821 | 21.7143 | 21.6821 | 21.7071 | 109424.0 |
| 2012-04-16 07:10:00 | AAPL | Stock | 21.7125 | 21.7321 | 21.6964 | 21.7143 | 186172.0 |
| 2012-04-16 07:15:00 | AAPL | Stock | 21.73 | 21.7304 | 21.7143 | 21.7143 | 22260.0 |
| 2012-04-16 07:20:00 | AAPL | Stock | 21.7193 | 21.7193 | 21.7179 | 21.7179 | 11200.0 |
| 2012-04-16 07:25:00 | AAPL | Stock | 21.7232 | 21.7232 | 21.6964 | 21.7046 | 152320.0 |
| 2012-04-16 07:30:00 | AAPL | Stock | 21.7036 | 21.7039 | 21.6964 | 21.6979 | 16800.0 |
| 2012-04-16 07:35:00 | AAPL | Stock | 21.6975 | 21.6996 | 21.6929 | 21.6929 | 19600.0 |
| 2012-04-16 07:40:00 | AAPL | Stock | 21.6875 | 21.6875 | 21.6789 | 21.6789 | 47460.0 |
| 2012-04-16 07:45:00 | AAPL | Stock | 21.6718 | 21.6786 | 21.6607 | 21.6639 | 75740.0 |
| 2012-04-16 07:50:00 | AAPL | Stock | 21.6607 | 21.6786 | 21.6561 | 21.6636 | 115360.0 |
| 2012-04-16 07:55:00 | AAPL | Stock | 21.6607 | 21.6782 | 21.6607 | 21.6782 | 35840.0 |
| 2012-04-16 08:00:00 | AAPL | Stock | 21.6771 | 21.7318 | 21.6554 | 21.6764 | 386512.0 |
| 2012-04-16 08:05:00 | AAPL | Stock | 21.6743 | 21.7 | 21.6714 | 21.6925 | 331296.0 |
| 2012-04-16 08:10:00 | AAPL | Stock | 21.6946 | 21.7232 | 21.6857 | 21.7221 | 200312.0 |
| 2012-04-16 08:15:00 | AAPL | Stock | 21.7207 | 21.7507 | 21.7157 | 21.7486 | 504868.0 |
| 2012-04-16 08:20:00 | AAPL | Stock | 21.7425 | 21.7479 | 21.7321 | 21.7321 | 400624.0 |
| 2012-04-16 08:25:00 | AAPL | Stock | 21.7314 | 21.7321 | 21.725 | 21.7307 | 206668.0 |
| 2012-04-16 08:30:00 | AAPL | Stock | 21.7289 | 21.8386 | 21.7289 | 21.8211 | 1174936.0 |
| 2012-04-16 08:35:00 | AAPL | Stock | 21.8189 | 21.8389 | 21.8036 | 21.8036 | 940716.0 |
| 2012-04-16 08:40:00 | AAPL | Stock | 21.8043 | 21.8329 | 21.8036 | 21.8157 | 720664.0 |
| 2012-04-16 08:45:00 | AAPL | Stock | 21.8146 | 21.8146 | 21.7582 | 21.7625 | 915824.0 |
| 2012-04-16 08:50:00 | AAPL | Stock | 21.7704 | 21.8036 | 21.7704 | 21.7946 | 272608.0 |
| 2012-04-16 08:55:00 | AAPL | Stock | 21.7929 | 21.7929 | 21.7718 | 21.7786 | 803768.0 |
| 2012-04-16 09:00:00 | AAPL | Stock | 21.7786 | 21.7893 | 21.7721 | 21.7854 | 329532.0 |
| 2012-04-16 09:05:00 | AAPL | Stock | 21.7857 | 21.7893 | 21.7789 | 21.7857 | 307048.0 |
| 2012-04-16 09:10:00 | AAPL | Stock | 21.7871 | 21.7896 | 21.7796 | 21.7839 | 371700.0 |
| 2012-04-16 09:15:00 | AAPL | Stock | 21.7821 | 21.7836 | 21.7711 | 21.7743 | 253764.0 |
| 2012-04-16 09:20:00 | AAPL | Stock | 21.7782 | 21.7857 | 21.7718 | 21.7857 | 281960.0 |
| 2012-04-16 09:25:00 | AAPL | Stock | 21.7857 | 21.8 | 21.7686 | 21.78 | 701064.0 |
| 2012-04-16 09:30:00 | AAPL | Stock | 21.7879 | 21.7957 | 21.6668 | 21.7036 | 19686268.0 |
| 2012-04-16 09:35:00 | AAPL | Stock | 21.7067 | 21.766 | 21.6804 | 21.6821 | 15045576.0 |
> showing 50 of 322,176 rows — these rows as CSV