PREVIEW / stock_5min / 2012-04-26
file: by_date/stock_5min/2012/2012-04-26.parquet size: 4.8 MB rows: 322,193 symbols: 3,533
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-26 04:00:00 | AAPL | Stock | 21.8932 | 21.8932 | 21.8857 | 21.8893 | 37016.0 |
| 2012-04-26 04:05:00 | AAPL | Stock | 21.8929 | 21.9 | 21.8929 | 21.8929 | 16800.0 |
| 2012-04-26 04:15:00 | AAPL | Stock | 21.9 | 21.9282 | 21.9 | 21.9282 | 5600.0 |
| 2012-04-26 04:20:00 | AAPL | Stock | 21.9282 | 21.9554 | 21.9282 | 21.9554 | 21028.0 |
| 2012-04-26 04:50:00 | AAPL | Stock | 21.8664 | 21.8857 | 21.8593 | 21.8593 | 19600.0 |
| 2012-04-26 04:55:00 | AAPL | Stock | 21.8629 | 21.8629 | 21.8629 | 21.8629 | 5600.0 |
| 2012-04-26 05:00:00 | AAPL | Stock | 21.8661 | 21.8661 | 21.8629 | 21.8629 | 8400.0 |
| 2012-04-26 05:05:00 | AAPL | Stock | 21.8646 | 21.8646 | 21.8646 | 21.8646 | 2800.0 |
| 2012-04-26 05:10:00 | AAPL | Stock | 21.8982 | 21.8982 | 21.8982 | 21.8982 | 4200.0 |
| 2012-04-26 05:15:00 | AAPL | Stock | 21.8982 | 21.8982 | 21.8982 | 21.8982 | 5600.0 |
| 2012-04-26 05:30:00 | AAPL | Stock | 21.8675 | 21.8675 | 21.8393 | 21.8393 | 28000.0 |
| 2012-04-26 05:35:00 | AAPL | Stock | 21.8393 | 21.8571 | 21.8393 | 21.8429 | 30800.0 |
| 2012-04-26 05:50:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8557 | 21.8571 | 30800.0 |
| 2012-04-26 05:55:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8571 | 21.8571 | 5600.0 |
| 2012-04-26 06:00:00 | AAPL | Stock | 21.8411 | 21.8411 | 21.835 | 21.835 | 12600.0 |
| 2012-04-26 06:10:00 | AAPL | Stock | 21.85 | 21.8568 | 21.85 | 21.8568 | 5600.0 |
| 2012-04-26 06:30:00 | AAPL | Stock | 21.8257 | 21.8257 | 21.8236 | 21.8236 | 9800.0 |
| 2012-04-26 06:45:00 | AAPL | Stock | 21.8079 | 21.8082 | 21.8014 | 21.8014 | 14616.0 |
| 2012-04-26 06:50:00 | AAPL | Stock | 21.795 | 21.8054 | 21.7857 | 21.8054 | 18396.0 |
| 2012-04-26 07:00:00 | AAPL | Stock | 21.8071 | 21.8071 | 21.7857 | 21.7857 | 23688.0 |
| 2012-04-26 07:10:00 | AAPL | Stock | 21.8161 | 21.8161 | 21.8161 | 21.8161 | 4480.0 |
| 2012-04-26 07:15:00 | AAPL | Stock | 21.8143 | 21.8214 | 21.8143 | 21.8214 | 46424.0 |
| 2012-04-26 07:20:00 | AAPL | Stock | 21.8461 | 21.8461 | 21.8389 | 21.8389 | 47600.0 |
| 2012-04-26 07:25:00 | AAPL | Stock | 21.8375 | 21.8579 | 21.8339 | 21.8482 | 114800.0 |
| 2012-04-26 07:30:00 | AAPL | Stock | 21.8425 | 21.8446 | 21.8386 | 21.8446 | 8400.0 |
| 2012-04-26 07:35:00 | AAPL | Stock | 21.8518 | 21.8518 | 21.8475 | 21.8475 | 21112.0 |
| 2012-04-26 07:40:00 | AAPL | Stock | 21.8554 | 21.8568 | 21.8393 | 21.8393 | 43456.0 |
| 2012-04-26 07:45:00 | AAPL | Stock | 21.8329 | 21.8329 | 21.8329 | 21.8329 | 8400.0 |
| 2012-04-26 07:55:00 | AAPL | Stock | 21.835 | 21.8482 | 21.835 | 21.8482 | 28000.0 |
| 2012-04-26 08:00:00 | AAPL | Stock | 21.8518 | 21.8929 | 21.7982 | 21.875 | 928676.0 |
| 2012-04-26 08:05:00 | AAPL | Stock | 21.8786 | 21.8836 | 21.8693 | 21.8779 | 241864.0 |
| 2012-04-26 08:10:00 | AAPL | Stock | 21.8818 | 21.9082 | 21.8771 | 21.8925 | 344372.0 |
| 2012-04-26 08:15:00 | AAPL | Stock | 21.8929 | 21.8936 | 21.8793 | 21.8925 | 259980.0 |
| 2012-04-26 08:20:00 | AAPL | Stock | 21.8879 | 21.8893 | 21.8593 | 21.8661 | 368620.0 |
| 2012-04-26 08:25:00 | AAPL | Stock | 21.8679 | 21.8746 | 21.8668 | 21.8696 | 152488.0 |
| 2012-04-26 08:30:00 | AAPL | Stock | 21.8696 | 21.8889 | 21.8436 | 21.8832 | 590716.0 |
| 2012-04-26 08:35:00 | AAPL | Stock | 21.8832 | 21.8875 | 21.8696 | 21.8779 | 502376.0 |
| 2012-04-26 08:40:00 | AAPL | Stock | 21.8764 | 21.9018 | 21.8711 | 21.8875 | 752024.0 |
| 2012-04-26 08:45:00 | AAPL | Stock | 21.8807 | 21.9064 | 21.8611 | 21.885 | 725480.0 |
| 2012-04-26 08:50:00 | AAPL | Stock | 21.885 | 21.9082 | 21.8839 | 21.8893 | 349356.0 |
| 2012-04-26 08:55:00 | AAPL | Stock | 21.8929 | 21.9036 | 21.8929 | 21.9036 | 238560.0 |
| 2012-04-26 09:00:00 | AAPL | Stock | 21.8989 | 21.8989 | 21.8811 | 21.8811 | 320796.0 |
| 2012-04-26 09:05:00 | AAPL | Stock | 21.8804 | 21.8907 | 21.8743 | 21.8818 | 520184.0 |
| 2012-04-26 09:10:00 | AAPL | Stock | 21.8811 | 21.8979 | 21.8786 | 21.8925 | 471128.0 |
| 2012-04-26 09:15:00 | AAPL | Stock | 21.8832 | 21.8929 | 21.8814 | 21.8921 | 158872.0 |
| 2012-04-26 09:20:00 | AAPL | Stock | 21.8929 | 21.8929 | 21.875 | 21.8779 | 242172.0 |
| 2012-04-26 09:25:00 | AAPL | Stock | 21.8761 | 21.9557 | 21.8736 | 21.9507 | 1814036.0 |
| 2012-04-26 09:30:00 | AAPL | Stock | 21.9382 | 21.9532 | 21.8214 | 21.8393 | 21191156.0 |
| 2012-04-26 09:35:00 | AAPL | Stock | 21.84 | 21.8754 | 21.8036 | 21.8536 | 14546364.0 |
| 2012-04-26 09:40:00 | AAPL | Stock | 21.8539 | 21.8782 | 21.8133 | 21.8507 | 10170384.0 |
> showing 50 of 322,193 rows — these rows as CSV