PREVIEW / stock_5min / 2012-10-05
file: by_date/stock_5min/2012/2012-10-05.parquet size: 4.7 MB rows: 315,406 symbols: 3,457
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-10-05 04:45:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7857 | 23.7857 | 11200.0 |
| 2012-10-05 06:55:00 | AAPL | Stock | 23.8132 | 23.8132 | 23.8036 | 23.8036 | 26600.0 |
| 2012-10-05 07:00:00 | AAPL | Stock | 23.7961 | 23.7964 | 23.7893 | 23.79 | 53172.0 |
| 2012-10-05 07:05:00 | AAPL | Stock | 23.79 | 23.7964 | 23.7786 | 23.7964 | 33880.0 |
| 2012-10-05 07:10:00 | AAPL | Stock | 23.7929 | 23.7929 | 23.7714 | 23.7714 | 24136.0 |
| 2012-10-05 07:15:00 | AAPL | Stock | 23.7679 | 23.7857 | 23.7679 | 23.7789 | 54600.0 |
| 2012-10-05 07:20:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7854 | 23.7854 | 13664.0 |
| 2012-10-05 07:25:00 | AAPL | Stock | 23.7854 | 23.7889 | 23.7854 | 23.7889 | 5600.0 |
| 2012-10-05 07:30:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7857 | 23.7857 | 11200.0 |
| 2012-10-05 07:35:00 | AAPL | Stock | 23.7911 | 23.7982 | 23.7911 | 23.7971 | 66080.0 |
| 2012-10-05 07:45:00 | AAPL | Stock | 23.7946 | 23.7946 | 23.7946 | 23.7946 | 5600.0 |
| 2012-10-05 07:50:00 | AAPL | Stock | 23.7964 | 23.8075 | 23.7964 | 23.8075 | 72380.0 |
| 2012-10-05 07:55:00 | AAPL | Stock | 23.7993 | 23.8036 | 23.7957 | 23.8032 | 33040.0 |
| 2012-10-05 08:00:00 | AAPL | Stock | 23.8018 | 23.8089 | 23.7514 | 23.7607 | 251328.0 |
| 2012-10-05 08:05:00 | AAPL | Stock | 23.7532 | 23.7536 | 23.7339 | 23.7536 | 62104.0 |
| 2012-10-05 08:10:00 | AAPL | Stock | 23.7661 | 23.7661 | 23.7507 | 23.7593 | 35476.0 |
| 2012-10-05 08:15:00 | AAPL | Stock | 23.7618 | 23.7782 | 23.7618 | 23.7671 | 97832.0 |
| 2012-10-05 08:20:00 | AAPL | Stock | 23.7682 | 23.7839 | 23.7682 | 23.7839 | 35560.0 |
| 2012-10-05 08:25:00 | AAPL | Stock | 23.7768 | 23.7768 | 23.75 | 23.7571 | 70728.0 |
| 2012-10-05 08:30:00 | AAPL | Stock | 23.7754 | 23.8571 | 23.7693 | 23.8357 | 903616.0 |
| 2012-10-05 08:35:00 | AAPL | Stock | 23.8379 | 23.8446 | 23.7771 | 23.7971 | 984564.0 |
| 2012-10-05 08:40:00 | AAPL | Stock | 23.8046 | 23.8107 | 23.7982 | 23.8046 | 243208.0 |
| 2012-10-05 08:45:00 | AAPL | Stock | 23.8039 | 23.8107 | 23.8025 | 23.8054 | 149968.0 |
| 2012-10-05 08:50:00 | AAPL | Stock | 23.81 | 23.8214 | 23.8089 | 23.8143 | 288456.0 |
| 2012-10-05 08:55:00 | AAPL | Stock | 23.8143 | 23.8143 | 23.8021 | 23.8061 | 131208.0 |
| 2012-10-05 09:00:00 | AAPL | Stock | 23.8064 | 23.8286 | 23.8018 | 23.8225 | 376656.0 |
| 2012-10-05 09:05:00 | AAPL | Stock | 23.8275 | 23.8371 | 23.8179 | 23.8286 | 133084.0 |
| 2012-10-05 09:10:00 | AAPL | Stock | 23.8339 | 23.8429 | 23.8318 | 23.8421 | 187264.0 |
| 2012-10-05 09:15:00 | AAPL | Stock | 23.8375 | 23.8418 | 23.7711 | 23.7839 | 537908.0 |
| 2012-10-05 09:20:00 | AAPL | Stock | 23.7786 | 23.7821 | 23.7464 | 23.75 | 594664.0 |
| 2012-10-05 09:25:00 | AAPL | Stock | 23.7436 | 23.7546 | 23.7143 | 23.7486 | 803488.0 |
| 2012-10-05 09:30:00 | AAPL | Stock | 23.7561 | 23.7857 | 23.6943 | 23.7615 | 17173800.0 |
| 2012-10-05 09:35:00 | AAPL | Stock | 23.7546 | 23.7679 | 23.7121 | 23.7421 | 9540412.0 |
| 2012-10-05 09:40:00 | AAPL | Stock | 23.7418 | 23.7418 | 23.665 | 23.7043 | 11533116.0 |
| 2012-10-05 09:45:00 | AAPL | Stock | 23.7079 | 23.7514 | 23.7068 | 23.7364 | 9176328.0 |
| 2012-10-05 09:50:00 | AAPL | Stock | 23.7361 | 23.7857 | 23.7314 | 23.7427 | 11203808.0 |
| 2012-10-05 09:55:00 | AAPL | Stock | 23.7389 | 23.7768 | 23.7179 | 23.7504 | 5818624.0 |
| 2012-10-05 10:00:00 | AAPL | Stock | 23.7479 | 23.7761 | 23.7143 | 23.7654 | 6572188.0 |
| 2012-10-05 10:05:00 | AAPL | Stock | 23.7678 | 23.7693 | 23.7069 | 23.7446 | 5715836.0 |
| 2012-10-05 10:10:00 | AAPL | Stock | 23.7421 | 23.7486 | 23.7096 | 23.7196 | 3467268.0 |
| 2012-10-05 10:15:00 | AAPL | Stock | 23.7218 | 23.75 | 23.6971 | 23.7225 | 5871264.0 |
| 2012-10-05 10:20:00 | AAPL | Stock | 23.7232 | 23.7436 | 23.6986 | 23.7061 | 5640880.0 |
| 2012-10-05 10:25:00 | AAPL | Stock | 23.71 | 23.7257 | 23.6904 | 23.7136 | 3927560.0 |
| 2012-10-05 10:30:00 | AAPL | Stock | 23.7118 | 23.7446 | 23.7096 | 23.7354 | 4663876.0 |
| 2012-10-05 10:35:00 | AAPL | Stock | 23.7386 | 23.7402 | 23.6914 | 23.6922 | 5299420.0 |
| 2012-10-05 10:40:00 | AAPL | Stock | 23.6921 | 23.7018 | 23.6107 | 23.6107 | 11566380.0 |
| 2012-10-05 10:45:00 | AAPL | Stock | 23.6111 | 23.6443 | 23.5979 | 23.6107 | 9477692.0 |
| 2012-10-05 10:50:00 | AAPL | Stock | 23.6079 | 23.6246 | 23.5889 | 23.6075 | 6733020.0 |
| 2012-10-05 10:55:00 | AAPL | Stock | 23.6079 | 23.6164 | 23.55 | 23.5536 | 11353692.0 |
| 2012-10-05 11:00:00 | AAPL | Stock | 23.5561 | 23.6029 | 23.5471 | 23.5764 | 7412860.0 |
> showing 50 of 315,406 rows — these rows as CSV