PREVIEW / stock_5min / 2013-02-22
file: by_date/stock_5min/2013/2013-02-22.parquet size: 4.9 MB rows: 326,238 symbols: 3,467
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-22 04:00:00 | AAPL | Stock | 15.9946 | 15.9946 | 15.9946 | 15.9946 | 2800.0 |
| 2013-02-22 04:05:00 | AAPL | Stock | 16.0304 | 16.035 | 16.0171 | 16.0171 | 8400.0 |
| 2013-02-22 04:45:00 | AAPL | Stock | 15.9875 | 15.9875 | 15.9875 | 15.9875 | 8036.0 |
| 2013-02-22 05:25:00 | AAPL | Stock | 16.0214 | 16.0214 | 16.0214 | 16.0214 | 2800.0 |
| 2013-02-22 06:00:00 | AAPL | Stock | 15.9789 | 15.9789 | 15.9789 | 15.9789 | 5600.0 |
| 2013-02-22 06:05:00 | AAPL | Stock | 15.9768 | 15.9768 | 15.9732 | 15.9732 | 8400.0 |
| 2013-02-22 06:10:00 | AAPL | Stock | 15.9732 | 15.9732 | 15.9732 | 15.9732 | 5656.0 |
| 2013-02-22 06:40:00 | AAPL | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 2800.0 |
| 2013-02-22 06:55:00 | AAPL | Stock | 16.0286 | 16.0357 | 16.0286 | 16.0357 | 65800.0 |
| 2013-02-22 07:00:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0179 | 16.0179 | 19712.0 |
| 2013-02-22 07:05:00 | AAPL | Stock | 16.0239 | 16.0357 | 16.0239 | 16.0307 | 37800.0 |
| 2013-02-22 07:10:00 | AAPL | Stock | 16.0304 | 16.0446 | 16.0304 | 16.0446 | 25200.0 |
| 2013-02-22 07:15:00 | AAPL | Stock | 16.0357 | 16.0464 | 16.0311 | 16.0429 | 54460.0 |
| 2013-02-22 07:20:00 | AAPL | Stock | 16.0368 | 16.0575 | 16.0357 | 16.0575 | 82600.0 |
| 2013-02-22 07:25:00 | AAPL | Stock | 16.0604 | 16.0714 | 16.0504 | 16.0714 | 126532.0 |
| 2013-02-22 07:30:00 | AAPL | Stock | 16.0679 | 16.0889 | 16.0543 | 16.0679 | 174104.0 |
| 2013-02-22 07:35:00 | AAPL | Stock | 16.0589 | 16.0589 | 16.0357 | 16.0357 | 137480.0 |
| 2013-02-22 07:40:00 | AAPL | Stock | 16.035 | 16.0439 | 16.0321 | 16.0321 | 11200.0 |
| 2013-02-22 07:45:00 | AAPL | Stock | 16.0411 | 16.0571 | 16.0411 | 16.0571 | 33264.0 |
| 2013-02-22 07:50:00 | AAPL | Stock | 16.0586 | 16.0679 | 16.0571 | 16.0679 | 126420.0 |
| 2013-02-22 07:55:00 | AAPL | Stock | 16.0661 | 16.0679 | 16.0536 | 16.0675 | 201600.0 |
| 2013-02-22 08:00:00 | AAPL | Stock | 16.0582 | 16.0825 | 16.0339 | 16.0482 | 513240.0 |
| 2013-02-22 08:05:00 | AAPL | Stock | 16.0482 | 16.065 | 15.9286 | 16.0571 | 242340.0 |
| 2013-02-22 08:10:00 | AAPL | Stock | 16.0546 | 16.0832 | 16.0546 | 16.0771 | 352912.0 |
| 2013-02-22 08:15:00 | AAPL | Stock | 16.0829 | 16.0857 | 16.0714 | 16.0768 | 114240.0 |
| 2013-02-22 08:20:00 | AAPL | Stock | 16.0754 | 16.0846 | 16.0593 | 16.0593 | 252756.0 |
| 2013-02-22 08:25:00 | AAPL | Stock | 16.0643 | 16.0693 | 16.0386 | 16.0571 | 165844.0 |
| 2013-02-22 08:30:00 | AAPL | Stock | 16.0521 | 16.0536 | 16.0404 | 16.0414 | 117880.0 |
| 2013-02-22 08:35:00 | AAPL | Stock | 16.0386 | 16.0646 | 16.0375 | 16.0618 | 193312.0 |
| 2013-02-22 08:40:00 | AAPL | Stock | 16.0589 | 16.0693 | 16.0543 | 16.0693 | 155960.0 |
| 2013-02-22 08:45:00 | AAPL | Stock | 16.0679 | 16.0775 | 16.0214 | 16.0279 | 535248.0 |
| 2013-02-22 08:50:00 | AAPL | Stock | 16.0261 | 16.0532 | 16.0257 | 16.0525 | 114968.0 |
| 2013-02-22 08:55:00 | AAPL | Stock | 16.0479 | 16.0486 | 16.0357 | 16.0357 | 263060.0 |
| 2013-02-22 09:00:00 | AAPL | Stock | 16.0357 | 16.0396 | 16.0225 | 16.0232 | 153636.0 |
| 2013-02-22 09:05:00 | AAPL | Stock | 16.0221 | 16.0396 | 16.0182 | 16.035 | 124824.0 |
| 2013-02-22 09:10:00 | AAPL | Stock | 16.035 | 16.0396 | 16.0293 | 16.0396 | 108192.0 |
| 2013-02-22 09:15:00 | AAPL | Stock | 16.0464 | 16.0536 | 16.0368 | 16.0379 | 124656.0 |
| 2013-02-22 09:20:00 | AAPL | Stock | 16.0364 | 16.0432 | 16.0357 | 16.0361 | 139720.0 |
| 2013-02-22 09:25:00 | AAPL | Stock | 16.0282 | 16.0557 | 16.0182 | 16.0446 | 546616.0 |
| 2013-02-22 09:30:00 | AAPL | Stock | 16.0418 | 16.0889 | 16.0 | 16.0514 | 15251908.0 |
| 2013-02-22 09:35:00 | AAPL | Stock | 16.0554 | 16.1286 | 16.0507 | 16.0675 | 15424612.0 |
| 2013-02-22 09:40:00 | AAPL | Stock | 16.0739 | 16.0786 | 16.0286 | 16.0725 | 7457716.0 |
| 2013-02-22 09:45:00 | AAPL | Stock | 16.0736 | 16.0782 | 15.9936 | 16.0129 | 7773948.0 |
| 2013-02-22 09:50:00 | AAPL | Stock | 16.0118 | 16.0453 | 15.9675 | 16.0 | 9603804.0 |
| 2013-02-22 09:55:00 | AAPL | Stock | 16.0014 | 16.0256 | 15.9661 | 15.9807 | 5702648.0 |
| 2013-02-22 10:00:00 | AAPL | Stock | 15.9879 | 16.0078 | 15.9596 | 15.9693 | 8011612.0 |
| 2013-02-22 10:05:00 | AAPL | Stock | 15.9707 | 16.0129 | 15.9646 | 16.0125 | 5573904.0 |
| 2013-02-22 10:10:00 | AAPL | Stock | 16.0139 | 16.0143 | 15.9789 | 15.9918 | 2576084.0 |
| 2013-02-22 10:15:00 | AAPL | Stock | 15.9846 | 16.0046 | 15.9693 | 15.991 | 5062512.0 |
| 2013-02-22 10:20:00 | AAPL | Stock | 15.9896 | 15.9979 | 15.95 | 15.9586 | 6669908.0 |
> showing 50 of 326,238 rows — these rows as CSV