PREVIEW / stock_5min / 2009-08-21
file: by_date/stock_5min/2009/2009-08-21.parquet size: 4.6 MB rows: 318,563 symbols: 3,383
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-21 07:10:00 | AAPL | Stock | 5.9643 | 5.9821 | 5.9643 | 5.9736 | 64400.0 |
| 2009-08-21 07:15:00 | AAPL | Stock | 5.9821 | 5.9821 | 5.9821 | 5.9821 | 367108.0 |
| 2009-08-21 07:35:00 | AAPL | Stock | 5.9718 | 5.9718 | 5.9643 | 5.9714 | 36400.0 |
| 2009-08-21 07:40:00 | AAPL | Stock | 5.9736 | 5.9736 | 5.9696 | 5.9718 | 120400.0 |
| 2009-08-21 07:45:00 | AAPL | Stock | 5.9714 | 5.9732 | 5.9714 | 5.9732 | 181384.0 |
| 2009-08-21 07:50:00 | AAPL | Stock | 5.9679 | 5.9711 | 5.9679 | 5.9711 | 30800.0 |
| 2009-08-21 07:55:00 | AAPL | Stock | 5.9711 | 5.9732 | 5.9711 | 5.9714 | 89600.0 |
| 2009-08-21 08:00:00 | AAPL | Stock | 5.9643 | 5.9707 | 5.9629 | 5.9664 | 56000.0 |
| 2009-08-21 08:05:00 | AAPL | Stock | 5.9646 | 5.9668 | 5.9646 | 5.9668 | 11200.0 |
| 2009-08-21 08:10:00 | AAPL | Stock | 5.9668 | 5.9668 | 5.9625 | 5.9643 | 79128.0 |
| 2009-08-21 08:15:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 21420.0 |
| 2009-08-21 08:20:00 | AAPL | Stock | 5.9643 | 5.9696 | 5.9643 | 5.9696 | 79800.0 |
| 2009-08-21 08:25:00 | AAPL | Stock | 5.9711 | 5.9732 | 5.9711 | 5.9729 | 112196.0 |
| 2009-08-21 08:30:00 | AAPL | Stock | 5.9746 | 5.975 | 5.9704 | 5.9714 | 204624.0 |
| 2009-08-21 08:35:00 | AAPL | Stock | 5.9714 | 5.9729 | 5.9714 | 5.9729 | 19600.0 |
| 2009-08-21 08:40:00 | AAPL | Stock | 5.9729 | 5.9732 | 5.9682 | 5.9682 | 52780.0 |
| 2009-08-21 08:45:00 | AAPL | Stock | 5.9704 | 5.9718 | 5.9704 | 5.9718 | 17584.0 |
| 2009-08-21 08:50:00 | AAPL | Stock | 5.9696 | 5.9725 | 5.9679 | 5.9725 | 56420.0 |
| 2009-08-21 08:55:00 | AAPL | Stock | 5.9721 | 5.9732 | 5.9714 | 5.9714 | 77532.0 |
| 2009-08-21 09:00:00 | AAPL | Stock | 5.9714 | 5.9725 | 5.9714 | 5.9714 | 16800.0 |
| 2009-08-21 09:05:00 | AAPL | Stock | 5.9725 | 5.9729 | 5.9725 | 5.9725 | 41048.0 |
| 2009-08-21 09:10:00 | AAPL | Stock | 5.9729 | 5.9732 | 5.9714 | 5.9725 | 261240.0 |
| 2009-08-21 09:15:00 | AAPL | Stock | 5.9711 | 5.9732 | 5.9711 | 5.9721 | 71120.0 |
| 2009-08-21 09:20:00 | AAPL | Stock | 5.9714 | 5.9739 | 5.9696 | 5.9714 | 151200.0 |
| 2009-08-21 09:25:00 | AAPL | Stock | 5.9714 | 5.9964 | 5.9682 | 5.99 | 2259236.0 |
| 2009-08-21 09:30:00 | AAPL | Stock | 5.99 | 5.9932 | 5.9607 | 5.9631 | 45000648.0 |
| 2009-08-21 09:35:00 | AAPL | Stock | 5.9611 | 5.9757 | 5.9589 | 5.9757 | 9759680.0 |
| 2009-08-21 09:40:00 | AAPL | Stock | 5.9761 | 5.9839 | 5.9715 | 5.9743 | 8342040.0 |
| 2009-08-21 09:45:00 | AAPL | Stock | 5.9754 | 5.9814 | 5.96 | 5.9664 | 8538320.0 |
| 2009-08-21 09:50:00 | AAPL | Stock | 5.965 | 5.9664 | 5.9571 | 5.9629 | 6045144.0 |
| 2009-08-21 09:55:00 | AAPL | Stock | 5.9629 | 5.9754 | 5.9618 | 5.975 | 4365872.0 |
| 2009-08-21 10:00:00 | AAPL | Stock | 5.975 | 6.0 | 5.975 | 6.0 | 15579424.0 |
| 2009-08-21 10:05:00 | AAPL | Stock | 6.0 | 6.005 | 5.995 | 5.9954 | 10690792.0 |
| 2009-08-21 10:10:00 | AAPL | Stock | 5.9957 | 6.0157 | 5.9929 | 6.015 | 12005560.0 |
| 2009-08-21 10:15:00 | AAPL | Stock | 6.015 | 6.0279 | 6.0121 | 6.0121 | 11475688.0 |
| 2009-08-21 10:20:00 | AAPL | Stock | 6.0125 | 6.0164 | 6.0107 | 6.0146 | 5139120.0 |
| 2009-08-21 10:25:00 | AAPL | Stock | 6.0157 | 6.0164 | 6.0121 | 6.0136 | 3948028.0 |
| 2009-08-21 10:30:00 | AAPL | Stock | 6.0136 | 6.0232 | 6.0118 | 6.0229 | 6531140.0 |
| 2009-08-21 10:35:00 | AAPL | Stock | 6.0231 | 6.0268 | 6.0218 | 6.0243 | 5099388.0 |
| 2009-08-21 10:40:00 | AAPL | Stock | 6.0243 | 6.0286 | 6.0232 | 6.0257 | 4392080.0 |
| 2009-08-21 10:45:00 | AAPL | Stock | 6.0257 | 6.0261 | 6.0111 | 6.0125 | 5236700.0 |
| 2009-08-21 10:50:00 | AAPL | Stock | 6.0129 | 6.02 | 6.0111 | 6.0168 | 3115616.0 |
| 2009-08-21 10:55:00 | AAPL | Stock | 6.0171 | 6.0189 | 6.0096 | 6.0139 | 4986856.0 |
| 2009-08-21 11:00:00 | AAPL | Stock | 6.0136 | 6.0211 | 6.0118 | 6.0173 | 3545108.0 |
| 2009-08-21 11:05:00 | AAPL | Stock | 6.0171 | 6.025 | 6.0154 | 6.0243 | 4419324.0 |
| 2009-08-21 11:10:00 | AAPL | Stock | 6.0239 | 6.0286 | 6.0232 | 6.0236 | 3747044.0 |
| 2009-08-21 11:15:00 | AAPL | Stock | 6.0236 | 6.0254 | 6.0207 | 6.0232 | 4502568.0 |
| 2009-08-21 11:20:00 | AAPL | Stock | 6.0236 | 6.0257 | 6.0196 | 6.0218 | 2595572.0 |
| 2009-08-21 11:25:00 | AAPL | Stock | 6.0218 | 6.0264 | 6.02 | 6.0225 | 2983540.0 |
| 2009-08-21 11:30:00 | AAPL | Stock | 6.0225 | 6.025 | 6.0186 | 6.0246 | 2456356.0 |
> showing 50 of 318,563 rows — these rows as CSV