PREVIEW / stock_5min / 2012-01-13
file: by_date/stock_5min/2012/2012-01-13.parquet size: 4.7 MB rows: 314,701 symbols: 3,511
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-01-13 04:50:00 | AAPL | Stock | 15.0829 | 15.0829 | 15.0829 | 15.0829 | 2800.0 |
| 2012-01-13 04:55:00 | AAPL | Stock | 15.0786 | 15.0786 | 15.0786 | 15.0786 | 5600.0 |
| 2012-01-13 05:00:00 | AAPL | Stock | 15.0786 | 15.0821 | 15.0786 | 15.0821 | 19600.0 |
| 2012-01-13 05:20:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 19600.0 |
| 2012-01-13 05:30:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 4200.0 |
| 2012-01-13 05:40:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 3304.0 |
| 2012-01-13 06:30:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 5600.0 |
| 2012-01-13 07:00:00 | AAPL | Stock | 15.05 | 15.05 | 15.05 | 15.05 | 7000.0 |
| 2012-01-13 07:20:00 | AAPL | Stock | 15.0507 | 15.0507 | 15.05 | 15.05 | 14000.0 |
| 2012-01-13 07:25:00 | AAPL | Stock | 15.0518 | 15.0518 | 15.0518 | 15.0518 | 8652.0 |
| 2012-01-13 07:40:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0464 | 15.0464 | 23828.0 |
| 2012-01-13 07:45:00 | AAPL | Stock | 15.0468 | 15.0468 | 15.0464 | 15.0464 | 24864.0 |
| 2012-01-13 07:50:00 | AAPL | Stock | 15.0361 | 15.0361 | 15.0261 | 15.0261 | 13300.0 |
| 2012-01-13 07:55:00 | AAPL | Stock | 15.0357 | 15.0396 | 15.0229 | 15.0296 | 136248.0 |
| 2012-01-13 08:00:00 | AAPL | Stock | 15.0296 | 15.0357 | 15.0268 | 15.0357 | 57260.0 |
| 2012-01-13 08:05:00 | AAPL | Stock | 15.035 | 15.0354 | 15.0196 | 15.025 | 108164.0 |
| 2012-01-13 08:10:00 | AAPL | Stock | 15.0275 | 15.0357 | 15.0214 | 15.0357 | 122948.0 |
| 2012-01-13 08:15:00 | AAPL | Stock | 15.0429 | 15.0536 | 15.0429 | 15.0464 | 108360.0 |
| 2012-01-13 08:20:00 | AAPL | Stock | 15.0464 | 15.0661 | 15.0429 | 15.0643 | 101332.0 |
| 2012-01-13 08:25:00 | AAPL | Stock | 15.0679 | 15.07 | 15.06 | 15.0636 | 201180.0 |
| 2012-01-13 08:30:00 | AAPL | Stock | 15.0536 | 15.0575 | 15.0536 | 15.0536 | 30800.0 |
| 2012-01-13 08:35:00 | AAPL | Stock | 15.0421 | 15.0421 | 15.0196 | 15.0257 | 232568.0 |
| 2012-01-13 08:40:00 | AAPL | Stock | 15.0339 | 15.0354 | 15.0257 | 15.035 | 46144.0 |
| 2012-01-13 08:45:00 | AAPL | Stock | 15.0318 | 15.0318 | 15.005 | 15.0107 | 177940.0 |
| 2012-01-13 08:50:00 | AAPL | Stock | 15.0196 | 15.0214 | 15.0054 | 15.0054 | 28896.0 |
| 2012-01-13 08:55:00 | AAPL | Stock | 15.0211 | 15.0218 | 14.9821 | 14.9871 | 255920.0 |
| 2012-01-13 09:00:00 | AAPL | Stock | 14.9879 | 14.9946 | 14.9739 | 14.9739 | 242648.0 |
| 2012-01-13 09:05:00 | AAPL | Stock | 14.9854 | 14.9857 | 14.9696 | 14.9696 | 136080.0 |
| 2012-01-13 09:10:00 | AAPL | Stock | 14.9686 | 14.9696 | 14.9507 | 14.9696 | 474572.0 |
| 2012-01-13 09:15:00 | AAPL | Stock | 14.9689 | 14.9725 | 14.9611 | 14.9671 | 175252.0 |
| 2012-01-13 09:20:00 | AAPL | Stock | 14.9732 | 14.9768 | 14.9732 | 14.9768 | 8260.0 |
| 2012-01-13 09:25:00 | AAPL | Stock | 14.9696 | 14.9889 | 14.9571 | 14.9889 | 512512.0 |
| 2012-01-13 09:30:00 | AAPL | Stock | 14.9893 | 14.9893 | 14.9521 | 14.9761 | 10070984.0 |
| 2012-01-13 09:35:00 | AAPL | Stock | 14.9764 | 14.9961 | 14.975 | 14.9939 | 7687120.0 |
| 2012-01-13 09:40:00 | AAPL | Stock | 14.993 | 14.9979 | 14.9593 | 14.9907 | 5440960.0 |
| 2012-01-13 09:45:00 | AAPL | Stock | 14.9893 | 15.0061 | 14.9864 | 15.0004 | 4693164.0 |
| 2012-01-13 09:50:00 | AAPL | Stock | 15.0007 | 15.0161 | 14.9943 | 15.0041 | 5083372.0 |
| 2012-01-13 09:55:00 | AAPL | Stock | 15.0004 | 15.0129 | 14.9782 | 14.9829 | 5474448.0 |
| 2012-01-13 10:00:00 | AAPL | Stock | 14.9821 | 15.0046 | 14.9768 | 15.0014 | 2980124.0 |
| 2012-01-13 10:05:00 | AAPL | Stock | 15.0021 | 15.0032 | 14.9879 | 14.9921 | 4357360.0 |
| 2012-01-13 10:10:00 | AAPL | Stock | 14.9939 | 14.9975 | 14.9729 | 14.9864 | 4806676.0 |
| 2012-01-13 10:15:00 | AAPL | Stock | 14.9857 | 14.9925 | 14.9739 | 14.9861 | 3359552.0 |
| 2012-01-13 10:20:00 | AAPL | Stock | 14.9825 | 14.9852 | 14.9654 | 14.9768 | 4400340.0 |
| 2012-01-13 10:25:00 | AAPL | Stock | 14.9768 | 14.9914 | 14.9714 | 14.9825 | 4641308.0 |
| 2012-01-13 10:30:00 | AAPL | Stock | 14.9821 | 14.9854 | 14.975 | 14.9804 | 2365020.0 |
| 2012-01-13 10:35:00 | AAPL | Stock | 14.9771 | 14.9875 | 14.9686 | 14.9707 | 3291680.0 |
| 2012-01-13 10:40:00 | AAPL | Stock | 14.9705 | 14.9743 | 14.9561 | 14.9589 | 5941936.0 |
| 2012-01-13 10:45:00 | AAPL | Stock | 14.9579 | 14.9714 | 14.9564 | 14.96 | 3488548.0 |
| 2012-01-13 10:50:00 | AAPL | Stock | 14.96 | 14.97 | 14.9568 | 14.9614 | 3224256.0 |
| 2012-01-13 10:55:00 | AAPL | Stock | 14.9604 | 14.9768 | 14.9593 | 14.9739 | 3161172.0 |
> showing 50 of 314,701 rows — these rows as CSV