PREVIEW / stock_5min / 2014-05-22
file: by_date/stock_5min/2014/2014-05-22.parquet size: 5.2 MB rows: 346,849 symbols: 3,543
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-22 04:20:00 | AAPL | Stock | 21.6746 | 21.6746 | 21.6746 | 21.6746 | 2800.0 |
| 2014-05-22 04:25:00 | AAPL | Stock | 21.6846 | 21.7011 | 21.6846 | 21.7011 | 11200.0 |
| 2014-05-22 06:20:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6786 | 21.6786 | 2800.0 |
| 2014-05-22 06:40:00 | AAPL | Stock | 21.6893 | 21.6893 | 21.6893 | 21.6893 | 14000.0 |
| 2014-05-22 07:15:00 | AAPL | Stock | 21.6821 | 21.6821 | 21.6821 | 21.6821 | 10584.0 |
| 2014-05-22 07:25:00 | AAPL | Stock | 21.6821 | 21.6821 | 21.6818 | 21.6821 | 14000.0 |
| 2014-05-22 07:30:00 | AAPL | Stock | 21.6821 | 21.6821 | 21.6821 | 21.6821 | 5600.0 |
| 2014-05-22 07:40:00 | AAPL | Stock | 21.6821 | 21.6889 | 21.675 | 21.6889 | 25200.0 |
| 2014-05-22 07:55:00 | AAPL | Stock | 21.6829 | 21.6829 | 21.6829 | 21.6829 | 2800.0 |
| 2014-05-22 08:00:00 | AAPL | Stock | 21.6732 | 21.6882 | 21.6571 | 21.6571 | 118384.0 |
| 2014-05-22 08:05:00 | AAPL | Stock | 21.6693 | 21.675 | 21.6693 | 21.675 | 79688.0 |
| 2014-05-22 08:10:00 | AAPL | Stock | 21.6729 | 21.6743 | 21.6721 | 21.6721 | 31976.0 |
| 2014-05-22 08:15:00 | AAPL | Stock | 21.6714 | 21.6743 | 21.6696 | 21.6696 | 28896.0 |
| 2014-05-22 08:20:00 | AAPL | Stock | 21.6721 | 21.6721 | 21.6689 | 21.6689 | 8400.0 |
| 2014-05-22 08:25:00 | AAPL | Stock | 21.6689 | 21.6711 | 21.6682 | 21.6696 | 36400.0 |
| 2014-05-22 08:30:00 | AAPL | Stock | 21.6682 | 21.6682 | 21.6607 | 21.6607 | 61236.0 |
| 2014-05-22 08:35:00 | AAPL | Stock | 21.6625 | 21.6625 | 21.6607 | 21.6618 | 22400.0 |
| 2014-05-22 08:40:00 | AAPL | Stock | 21.6675 | 21.6696 | 21.6675 | 21.6696 | 5600.0 |
| 2014-05-22 08:45:00 | AAPL | Stock | 21.6696 | 21.6761 | 21.6696 | 21.6761 | 16800.0 |
| 2014-05-22 08:55:00 | AAPL | Stock | 21.6711 | 21.6718 | 21.6711 | 21.6718 | 11200.0 |
| 2014-05-22 09:00:00 | AAPL | Stock | 21.6743 | 21.6864 | 21.6714 | 21.6864 | 102452.0 |
| 2014-05-22 09:05:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.6718 | 21.6786 | 86436.0 |
| 2014-05-22 09:10:00 | AAPL | Stock | 21.6761 | 21.6814 | 21.6761 | 21.6814 | 16800.0 |
| 2014-05-22 09:15:00 | AAPL | Stock | 21.6814 | 21.685 | 21.675 | 21.6811 | 237020.0 |
| 2014-05-22 09:20:00 | AAPL | Stock | 21.6775 | 21.6893 | 21.6775 | 21.6886 | 72800.0 |
| 2014-05-22 09:25:00 | AAPL | Stock | 21.6889 | 21.6964 | 21.6625 | 21.6625 | 527940.0 |
| 2014-05-22 09:30:00 | AAPL | Stock | 21.6643 | 21.7079 | 21.6432 | 21.6596 | 9743440.0 |
| 2014-05-22 09:35:00 | AAPL | Stock | 21.6625 | 21.7093 | 21.6593 | 21.6929 | 3862684.0 |
| 2014-05-22 09:40:00 | AAPL | Stock | 21.6875 | 21.6911 | 21.6264 | 21.6425 | 6527724.0 |
| 2014-05-22 09:45:00 | AAPL | Stock | 21.6393 | 21.6571 | 21.6146 | 21.6182 | 4274228.0 |
| 2014-05-22 09:50:00 | AAPL | Stock | 21.6184 | 21.6589 | 21.6161 | 21.6504 | 3762472.0 |
| 2014-05-22 09:55:00 | AAPL | Stock | 21.6568 | 21.6696 | 21.6464 | 21.6484 | 4648672.0 |
| 2014-05-22 10:00:00 | AAPL | Stock | 21.6546 | 21.6546 | 21.6275 | 21.64 | 2910824.0 |
| 2014-05-22 10:05:00 | AAPL | Stock | 21.635 | 21.6361 | 21.5925 | 21.6143 | 3690260.0 |
| 2014-05-22 10:10:00 | AAPL | Stock | 21.6159 | 21.6279 | 21.6018 | 21.6107 | 1448692.0 |
| 2014-05-22 10:15:00 | AAPL | Stock | 21.6132 | 21.6179 | 21.5907 | 21.6057 | 2330244.0 |
| 2014-05-22 10:20:00 | AAPL | Stock | 21.6 | 21.6089 | 21.575 | 21.6036 | 3247188.0 |
| 2014-05-22 10:25:00 | AAPL | Stock | 21.6034 | 21.6425 | 21.6034 | 21.6218 | 2646868.0 |
| 2014-05-22 10:30:00 | AAPL | Stock | 21.6239 | 21.6454 | 21.6043 | 21.6143 | 1599276.0 |
| 2014-05-22 10:35:00 | AAPL | Stock | 21.6096 | 21.6429 | 21.6093 | 21.6375 | 831124.0 |
| 2014-05-22 10:40:00 | AAPL | Stock | 21.6375 | 21.6389 | 21.6107 | 21.6225 | 826392.0 |
| 2014-05-22 10:45:00 | AAPL | Stock | 21.6225 | 21.6293 | 21.6125 | 21.6179 | 1014720.0 |
| 2014-05-22 10:50:00 | AAPL | Stock | 21.6189 | 21.6429 | 21.6189 | 21.6357 | 2321340.0 |
| 2014-05-22 10:55:00 | AAPL | Stock | 21.6393 | 21.6521 | 21.6296 | 21.6379 | 2371096.0 |
| 2014-05-22 11:00:00 | AAPL | Stock | 21.6371 | 21.64 | 21.6125 | 21.6154 | 951664.0 |
| 2014-05-22 11:05:00 | AAPL | Stock | 21.6182 | 21.6243 | 21.6125 | 21.6182 | 2769116.0 |
| 2014-05-22 11:10:00 | AAPL | Stock | 21.6168 | 21.6425 | 21.6157 | 21.6336 | 1632428.0 |
| 2014-05-22 11:15:00 | AAPL | Stock | 21.6361 | 21.6468 | 21.6214 | 21.6329 | 1657012.0 |
| 2014-05-22 11:20:00 | AAPL | Stock | 21.6296 | 21.6436 | 21.6268 | 21.6379 | 1318380.0 |
| 2014-05-22 11:25:00 | AAPL | Stock | 21.6357 | 21.6386 | 21.618 | 21.6346 | 1879416.0 |
> showing 50 of 346,849 rows — these rows as CSV