PREVIEW / stock_5min / 2010-08-23
file: by_date/stock_5min/2010/2010-08-23.parquet size: 4.6 MB rows: 321,426 symbols: 3,463
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-23 06:40:00 | AAPL | Stock | 8.9446 | 8.9446 | 8.9446 | 8.9446 | 2800.0 |
| 2010-08-23 06:45:00 | AAPL | Stock | 8.9464 | 8.9464 | 8.9464 | 8.9464 | 8400.0 |
| 2010-08-23 07:00:00 | AAPL | Stock | 8.9518 | 8.9518 | 8.9518 | 8.9518 | 2800.0 |
| 2010-08-23 07:05:00 | AAPL | Stock | 8.9561 | 8.9679 | 8.9561 | 8.9679 | 30800.0 |
| 2010-08-23 07:15:00 | AAPL | Stock | 8.9661 | 8.9661 | 8.9661 | 8.9661 | 3080.0 |
| 2010-08-23 07:20:00 | AAPL | Stock | 8.9661 | 8.9732 | 8.9661 | 8.9711 | 25200.0 |
| 2010-08-23 07:25:00 | AAPL | Stock | 8.9571 | 8.9589 | 8.9571 | 8.9589 | 5600.0 |
| 2010-08-23 07:35:00 | AAPL | Stock | 8.9589 | 8.9589 | 8.9571 | 8.9571 | 19600.0 |
| 2010-08-23 07:40:00 | AAPL | Stock | 8.9636 | 8.9636 | 8.9636 | 8.9636 | 8400.0 |
| 2010-08-23 07:45:00 | AAPL | Stock | 8.9657 | 8.9679 | 8.9657 | 8.9679 | 14000.0 |
| 2010-08-23 07:50:00 | AAPL | Stock | 8.9671 | 8.9732 | 8.9643 | 8.9732 | 53200.0 |
| 2010-08-23 07:55:00 | AAPL | Stock | 8.9764 | 8.9893 | 8.9764 | 8.9818 | 86520.0 |
| 2010-08-23 08:00:00 | AAPL | Stock | 8.9732 | 8.9836 | 8.9621 | 8.975 | 320824.0 |
| 2010-08-23 08:05:00 | AAPL | Stock | 8.9729 | 8.975 | 8.9714 | 8.9729 | 35280.0 |
| 2010-08-23 08:10:00 | AAPL | Stock | 8.9675 | 8.9679 | 8.9668 | 8.9679 | 48020.0 |
| 2010-08-23 08:15:00 | AAPL | Stock | 8.9725 | 8.9746 | 8.9675 | 8.9696 | 120400.0 |
| 2010-08-23 08:20:00 | AAPL | Stock | 8.9675 | 8.9675 | 8.9536 | 8.9536 | 116116.0 |
| 2010-08-23 08:25:00 | AAPL | Stock | 8.9604 | 8.9775 | 8.9571 | 8.9732 | 447748.0 |
| 2010-08-23 08:30:00 | AAPL | Stock | 8.975 | 8.9875 | 8.975 | 8.9839 | 268240.0 |
| 2010-08-23 08:35:00 | AAPL | Stock | 8.9839 | 8.9875 | 8.9714 | 8.9721 | 133840.0 |
| 2010-08-23 08:40:00 | AAPL | Stock | 8.9725 | 8.9761 | 8.9725 | 8.975 | 46900.0 |
| 2010-08-23 08:45:00 | AAPL | Stock | 8.9786 | 8.9811 | 8.975 | 8.975 | 98000.0 |
| 2010-08-23 08:50:00 | AAPL | Stock | 8.9732 | 8.9857 | 8.9721 | 8.9857 | 216888.0 |
| 2010-08-23 08:55:00 | AAPL | Stock | 8.9829 | 8.9861 | 8.9821 | 8.9821 | 482720.0 |
| 2010-08-23 09:00:00 | AAPL | Stock | 8.9821 | 8.9836 | 8.9711 | 8.9732 | 201712.0 |
| 2010-08-23 09:05:00 | AAPL | Stock | 8.9736 | 8.9875 | 8.9725 | 8.9821 | 398440.0 |
| 2010-08-23 09:10:00 | AAPL | Stock | 8.9786 | 8.9875 | 8.9775 | 8.9846 | 257880.0 |
| 2010-08-23 09:15:00 | AAPL | Stock | 8.9839 | 8.9882 | 8.9839 | 8.9839 | 75180.0 |
| 2010-08-23 09:20:00 | AAPL | Stock | 8.9846 | 8.9946 | 8.9846 | 8.9929 | 477092.0 |
| 2010-08-23 09:25:00 | AAPL | Stock | 8.9925 | 8.9957 | 8.9904 | 8.9925 | 335636.0 |
| 2010-08-23 09:30:00 | AAPL | Stock | 8.9925 | 9.0 | 8.9646 | 8.98 | 9903208.0 |
| 2010-08-23 09:35:00 | AAPL | Stock | 8.9789 | 8.9886 | 8.9768 | 8.9886 | 6797140.0 |
| 2010-08-23 09:40:00 | AAPL | Stock | 8.9886 | 8.9921 | 8.9671 | 8.9714 | 6877220.0 |
| 2010-08-23 09:45:00 | AAPL | Stock | 8.9729 | 8.9871 | 8.9718 | 8.9775 | 5142676.0 |
| 2010-08-23 09:50:00 | AAPL | Stock | 8.9789 | 8.9811 | 8.96 | 8.9639 | 9197412.0 |
| 2010-08-23 09:55:00 | AAPL | Stock | 8.9621 | 8.9654 | 8.9564 | 8.9586 | 5723592.0 |
| 2010-08-23 10:00:00 | AAPL | Stock | 8.9568 | 8.9586 | 8.9307 | 8.9311 | 8394344.0 |
| 2010-08-23 10:05:00 | AAPL | Stock | 8.9309 | 8.9439 | 8.9207 | 8.9318 | 11782428.0 |
| 2010-08-23 10:10:00 | AAPL | Stock | 8.9318 | 8.9325 | 8.9107 | 8.9174 | 6317136.0 |
| 2010-08-23 10:15:00 | AAPL | Stock | 8.9171 | 8.9171 | 8.8864 | 8.8982 | 10247412.0 |
| 2010-08-23 10:20:00 | AAPL | Stock | 8.8989 | 8.8989 | 8.8625 | 8.8737 | 10095512.0 |
| 2010-08-23 10:25:00 | AAPL | Stock | 8.8743 | 8.8879 | 8.8707 | 8.8775 | 6229580.0 |
| 2010-08-23 10:30:00 | AAPL | Stock | 8.8771 | 8.9014 | 8.8618 | 8.8998 | 7647052.0 |
| 2010-08-23 10:35:00 | AAPL | Stock | 8.8993 | 8.9107 | 8.8961 | 8.9068 | 7212380.0 |
| 2010-08-23 10:40:00 | AAPL | Stock | 8.9071 | 8.9079 | 8.8486 | 8.8521 | 9632504.0 |
| 2010-08-23 10:45:00 | AAPL | Stock | 8.8521 | 8.8711 | 8.8489 | 8.8593 | 6160000.0 |
| 2010-08-23 10:50:00 | AAPL | Stock | 8.8596 | 8.8671 | 8.8464 | 8.865 | 5830580.0 |
| 2010-08-23 10:55:00 | AAPL | Stock | 8.8657 | 8.8671 | 8.8543 | 8.8596 | 4120844.0 |
| 2010-08-23 11:00:00 | AAPL | Stock | 8.8596 | 8.8607 | 8.8293 | 8.8429 | 7542584.0 |
| 2010-08-23 11:05:00 | AAPL | Stock | 8.8429 | 8.847 | 8.8268 | 8.8352 | 5619236.0 |
> showing 50 of 321,426 rows — these rows as CSV