PREVIEW / stock_5min / 2012-03-28
file: by_date/stock_5min/2012/2012-03-28.parquet size: 4.9 MB rows: 328,659 symbols: 3,524
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-03-28 04:00:00 | AAPL | Stock | 21.9657 | 21.9657 | 21.9657 | 21.9657 | 2800.0 |
| 2012-03-28 04:15:00 | AAPL | Stock | 22.0343 | 22.0346 | 22.0343 | 22.0346 | 29400.0 |
| 2012-03-28 04:40:00 | AAPL | Stock | 22.0107 | 22.0107 | 22.0107 | 22.0107 | 14000.0 |
| 2012-03-28 04:50:00 | AAPL | Stock | 21.9761 | 22.0061 | 21.9732 | 22.0061 | 25900.0 |
| 2012-03-28 04:55:00 | AAPL | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 26600.0 |
| 2012-03-28 05:20:00 | AAPL | Stock | 21.9754 | 21.9754 | 21.9754 | 21.9754 | 2800.0 |
| 2012-03-28 05:25:00 | AAPL | Stock | 22.0 | 22.0054 | 22.0 | 22.0054 | 19600.0 |
| 2012-03-28 05:45:00 | AAPL | Stock | 22.0 | 22.0 | 22.0 | 22.0 | 2800.0 |
| 2012-03-28 05:50:00 | AAPL | Stock | 21.9811 | 22.0032 | 21.9811 | 22.0032 | 19600.0 |
| 2012-03-28 05:55:00 | AAPL | Stock | 22.0018 | 22.0036 | 22.0018 | 22.0036 | 12320.0 |
| 2012-03-28 06:00:00 | AAPL | Stock | 22.0014 | 22.0014 | 22.0014 | 22.0014 | 2800.0 |
| 2012-03-28 06:05:00 | AAPL | Stock | 22.0014 | 22.0014 | 22.0014 | 22.0014 | 2800.0 |
| 2012-03-28 06:10:00 | AAPL | Stock | 22.0036 | 22.0036 | 22.0036 | 22.0036 | 23240.0 |
| 2012-03-28 06:15:00 | AAPL | Stock | 22.0007 | 22.0007 | 22.0007 | 22.0007 | 2800.0 |
| 2012-03-28 06:20:00 | AAPL | Stock | 22.005 | 22.005 | 22.005 | 22.005 | 2800.0 |
| 2012-03-28 06:25:00 | AAPL | Stock | 22.005 | 22.005 | 22.005 | 22.005 | 5600.0 |
| 2012-03-28 06:30:00 | AAPL | Stock | 22.0054 | 22.0071 | 22.0054 | 22.0071 | 64400.0 |
| 2012-03-28 06:35:00 | AAPL | Stock | 22.0036 | 22.0071 | 22.0036 | 22.0071 | 18200.0 |
| 2012-03-28 06:40:00 | AAPL | Stock | 22.0071 | 22.0071 | 22.0071 | 22.0071 | 14000.0 |
| 2012-03-28 06:50:00 | AAPL | Stock | 22.0089 | 22.0089 | 22.0089 | 22.0089 | 2800.0 |
| 2012-03-28 06:55:00 | AAPL | Stock | 22.0125 | 22.0125 | 22.0125 | 22.0125 | 25200.0 |
| 2012-03-28 07:00:00 | AAPL | Stock | 22.0089 | 22.0125 | 21.9929 | 22.0089 | 60032.0 |
| 2012-03-28 07:05:00 | AAPL | Stock | 22.0125 | 22.0429 | 22.0125 | 22.0429 | 39760.0 |
| 2012-03-28 07:10:00 | AAPL | Stock | 22.0429 | 22.0625 | 22.0354 | 22.0357 | 129304.0 |
| 2012-03-28 07:15:00 | AAPL | Stock | 22.0357 | 22.0518 | 22.0357 | 22.0429 | 36148.0 |
| 2012-03-28 07:20:00 | AAPL | Stock | 22.0475 | 22.0575 | 22.0214 | 22.0575 | 193256.0 |
| 2012-03-28 07:25:00 | AAPL | Stock | 22.0579 | 22.0607 | 22.0539 | 22.0607 | 45808.0 |
| 2012-03-28 07:30:00 | AAPL | Stock | 22.0596 | 22.0607 | 22.05 | 22.0536 | 97272.0 |
| 2012-03-28 07:35:00 | AAPL | Stock | 22.0554 | 22.0607 | 22.0554 | 22.0571 | 42224.0 |
| 2012-03-28 07:40:00 | AAPL | Stock | 22.0589 | 22.0736 | 22.0589 | 22.0679 | 169428.0 |
| 2012-03-28 07:45:00 | AAPL | Stock | 22.065 | 22.0689 | 22.0414 | 22.0414 | 130732.0 |
| 2012-03-28 07:50:00 | AAPL | Stock | 22.0579 | 22.0579 | 22.0254 | 22.0411 | 156548.0 |
| 2012-03-28 07:55:00 | AAPL | Stock | 22.0418 | 22.0418 | 22.0307 | 22.0411 | 40460.0 |
| 2012-03-28 08:00:00 | AAPL | Stock | 22.0479 | 22.0625 | 22.0321 | 22.0571 | 767536.0 |
| 2012-03-28 08:05:00 | AAPL | Stock | 22.0571 | 22.0829 | 22.0571 | 22.0775 | 629804.0 |
| 2012-03-28 08:10:00 | AAPL | Stock | 22.0754 | 22.0832 | 22.0589 | 22.0596 | 660464.0 |
| 2012-03-28 08:15:00 | AAPL | Stock | 22.0621 | 22.0714 | 22.0482 | 22.0607 | 605780.0 |
| 2012-03-28 08:20:00 | AAPL | Stock | 22.0629 | 22.0714 | 22.0511 | 22.065 | 326928.0 |
| 2012-03-28 08:25:00 | AAPL | Stock | 22.065 | 22.0689 | 22.0607 | 22.065 | 300048.0 |
| 2012-03-28 08:30:00 | AAPL | Stock | 22.0646 | 22.0675 | 22.0429 | 22.0593 | 646744.0 |
| 2012-03-28 08:35:00 | AAPL | Stock | 22.0596 | 22.0636 | 22.0514 | 22.0514 | 298732.0 |
| 2012-03-28 08:40:00 | AAPL | Stock | 22.05 | 22.0557 | 22.0464 | 22.0539 | 229180.0 |
| 2012-03-28 08:45:00 | AAPL | Stock | 22.0557 | 22.0675 | 22.0539 | 22.0625 | 335384.0 |
| 2012-03-28 08:50:00 | AAPL | Stock | 22.0654 | 22.0729 | 22.0582 | 22.0729 | 398916.0 |
| 2012-03-28 08:55:00 | AAPL | Stock | 22.0754 | 22.0768 | 22.0432 | 22.0446 | 642040.0 |
| 2012-03-28 09:00:00 | AAPL | Stock | 22.0446 | 22.0643 | 22.0389 | 22.0507 | 525924.0 |
| 2012-03-28 09:05:00 | AAPL | Stock | 22.0504 | 22.0568 | 22.0468 | 22.0521 | 122220.0 |
| 2012-03-28 09:10:00 | AAPL | Stock | 22.0521 | 22.0571 | 22.0507 | 22.0536 | 159068.0 |
| 2012-03-28 09:15:00 | AAPL | Stock | 22.055 | 22.0564 | 22.0361 | 22.045 | 261940.0 |
| 2012-03-28 09:20:00 | AAPL | Stock | 22.0493 | 22.0536 | 22.0407 | 22.0536 | 268716.0 |
> showing 50 of 328,659 rows — these rows as CSV