PREVIEW / stock_5min / 2010-10-27
file: by_date/stock_5min/2010/2010-10-27.parquet size: 4.8 MB rows: 326,102 symbols: 3,499
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-10-27 05:05:00 | AAPL | Stock | 10.9843 | 10.9843 | 10.9839 | 10.9839 | 8400.0 |
| 2010-10-27 05:40:00 | AAPL | Stock | 10.9821 | 10.9821 | 10.9821 | 10.9821 | 2800.0 |
| 2010-10-27 07:00:00 | AAPL | Stock | 10.9821 | 10.9921 | 10.9821 | 10.9921 | 11480.0 |
| 2010-10-27 07:05:00 | AAPL | Stock | 10.9682 | 10.9682 | 10.9682 | 10.9682 | 3080.0 |
| 2010-10-27 07:10:00 | AAPL | Stock | 10.9718 | 10.9729 | 10.9686 | 10.9714 | 22400.0 |
| 2010-10-27 07:15:00 | AAPL | Stock | 10.9714 | 10.9714 | 10.9661 | 10.9661 | 36400.0 |
| 2010-10-27 07:20:00 | AAPL | Stock | 10.9671 | 10.9761 | 10.9661 | 10.9761 | 22400.0 |
| 2010-10-27 07:25:00 | AAPL | Stock | 10.9757 | 10.9757 | 10.9732 | 10.9739 | 14000.0 |
| 2010-10-27 07:30:00 | AAPL | Stock | 10.9739 | 10.9739 | 10.9739 | 10.9739 | 2800.0 |
| 2010-10-27 07:35:00 | AAPL | Stock | 10.9664 | 10.9664 | 10.9639 | 10.9639 | 71400.0 |
| 2010-10-27 07:40:00 | AAPL | Stock | 10.9546 | 10.9586 | 10.9546 | 10.9586 | 53200.0 |
| 2010-10-27 07:45:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9639 | 10.9639 | 5600.0 |
| 2010-10-27 07:50:00 | AAPL | Stock | 10.9643 | 10.9668 | 10.9586 | 10.9661 | 81200.0 |
| 2010-10-27 07:55:00 | AAPL | Stock | 10.9654 | 10.9657 | 10.9446 | 10.9511 | 203000.0 |
| 2010-10-27 08:00:00 | AAPL | Stock | 10.95 | 10.9643 | 10.9429 | 10.95 | 534968.0 |
| 2010-10-27 08:05:00 | AAPL | Stock | 10.9554 | 10.9607 | 10.9554 | 10.9571 | 67872.0 |
| 2010-10-27 08:10:00 | AAPL | Stock | 10.9589 | 10.9721 | 10.9589 | 10.9721 | 152656.0 |
| 2010-10-27 08:15:00 | AAPL | Stock | 10.9714 | 10.9732 | 10.9696 | 10.9732 | 42000.0 |
| 2010-10-27 08:20:00 | AAPL | Stock | 10.9721 | 10.9732 | 10.97 | 10.9732 | 81788.0 |
| 2010-10-27 08:25:00 | AAPL | Stock | 10.9746 | 10.9761 | 10.9729 | 10.975 | 57400.0 |
| 2010-10-27 08:30:00 | AAPL | Stock | 10.9721 | 10.9971 | 10.9589 | 10.995 | 956620.0 |
| 2010-10-27 08:35:00 | AAPL | Stock | 10.9936 | 11.0268 | 10.9904 | 11.0189 | 1286964.0 |
| 2010-10-27 08:40:00 | AAPL | Stock | 11.0179 | 11.0429 | 11.0179 | 11.0286 | 1106616.0 |
| 2010-10-27 08:45:00 | AAPL | Stock | 11.0321 | 11.0446 | 11.0229 | 11.0268 | 1345680.0 |
| 2010-10-27 08:50:00 | AAPL | Stock | 11.0271 | 11.0396 | 11.0136 | 11.0179 | 840056.0 |
| 2010-10-27 08:55:00 | AAPL | Stock | 11.0179 | 11.0214 | 11.0082 | 11.0129 | 525504.0 |
| 2010-10-27 09:00:00 | AAPL | Stock | 11.0089 | 11.0111 | 11.0018 | 11.0089 | 649040.0 |
| 2010-10-27 09:05:00 | AAPL | Stock | 11.0071 | 11.0075 | 10.9939 | 10.9993 | 263480.0 |
| 2010-10-27 09:10:00 | AAPL | Stock | 10.9993 | 11.0068 | 10.9936 | 10.9936 | 194992.0 |
| 2010-10-27 09:15:00 | AAPL | Stock | 10.995 | 11.0018 | 10.9943 | 11.0004 | 77420.0 |
| 2010-10-27 09:20:00 | AAPL | Stock | 10.9989 | 11.0004 | 10.99 | 10.99 | 153300.0 |
| 2010-10-27 09:25:00 | AAPL | Stock | 10.9914 | 10.9979 | 10.9732 | 10.9861 | 302904.0 |
| 2010-10-27 09:30:00 | AAPL | Stock | 10.985 | 11.0679 | 10.9579 | 11.0329 | 21571620.0 |
| 2010-10-27 09:35:00 | AAPL | Stock | 11.0268 | 11.0479 | 10.9929 | 10.9968 | 12353964.0 |
| 2010-10-27 09:40:00 | AAPL | Stock | 10.9956 | 11.0111 | 10.9721 | 10.9829 | 10315256.0 |
| 2010-10-27 09:45:00 | AAPL | Stock | 10.9775 | 11.015 | 10.9643 | 11.015 | 10289860.0 |
| 2010-10-27 09:50:00 | AAPL | Stock | 11.0154 | 11.0229 | 11.0018 | 11.0079 | 12494664.0 |
| 2010-10-27 09:55:00 | AAPL | Stock | 11.0089 | 11.0307 | 10.9918 | 11.0039 | 7150864.0 |
| 2010-10-27 10:00:00 | AAPL | Stock | 11.006 | 11.0143 | 10.975 | 10.99 | 7420868.0 |
| 2010-10-27 10:05:00 | AAPL | Stock | 10.9935 | 10.9957 | 10.9796 | 10.9943 | 6301148.0 |
| 2010-10-27 10:10:00 | AAPL | Stock | 10.9946 | 11.0093 | 10.9839 | 10.9961 | 5330976.0 |
| 2010-10-27 10:15:00 | AAPL | Stock | 10.9964 | 11.0068 | 10.9732 | 10.9793 | 4937464.0 |
| 2010-10-27 10:20:00 | AAPL | Stock | 10.9799 | 10.9857 | 10.9507 | 10.9511 | 9150148.0 |
| 2010-10-27 10:25:00 | AAPL | Stock | 10.9514 | 10.9596 | 10.9364 | 10.95 | 10139668.0 |
| 2010-10-27 10:30:00 | AAPL | Stock | 10.9518 | 10.9743 | 10.9396 | 10.9689 | 7143388.0 |
| 2010-10-27 10:35:00 | AAPL | Stock | 10.9689 | 10.9779 | 10.9525 | 10.9579 | 5319384.0 |
| 2010-10-27 10:40:00 | AAPL | Stock | 10.9582 | 10.9707 | 10.9464 | 10.955 | 4272772.0 |
| 2010-10-27 10:45:00 | AAPL | Stock | 10.9546 | 10.9696 | 10.95 | 10.9554 | 2917152.0 |
| 2010-10-27 10:50:00 | AAPL | Stock | 10.9539 | 10.9679 | 10.9429 | 10.9645 | 3587472.0 |
| 2010-10-27 10:55:00 | AAPL | Stock | 10.9657 | 10.9671 | 10.9336 | 10.935 | 4589060.0 |
> showing 50 of 326,102 rows — these rows as CSV