PREVIEW / stock_5min / 2010-02-12
file: by_date/stock_5min/2010/2010-02-12.parquet size: 4.6 MB rows: 319,158 symbols: 3,433
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-02-12 04:55:00 | AAPL | Stock | 7.0964 | 7.0964 | 7.0964 | 7.0964 | 2800.0 |
| 2010-02-12 05:25:00 | AAPL | Stock | 7.0604 | 7.0604 | 7.0604 | 7.0604 | 5600.0 |
| 2010-02-12 05:30:00 | AAPL | Stock | 7.0511 | 7.0511 | 7.0511 | 7.0511 | 5292.0 |
| 2010-02-12 06:10:00 | AAPL | Stock | 7.0439 | 7.0439 | 7.0439 | 7.0439 | 2800.0 |
| 2010-02-12 06:30:00 | AAPL | Stock | 7.0361 | 7.0361 | 7.0332 | 7.0357 | 14000.0 |
| 2010-02-12 06:35:00 | AAPL | Stock | 7.0236 | 7.0236 | 7.0236 | 7.0236 | 2800.0 |
| 2010-02-12 07:00:00 | AAPL | Stock | 7.0511 | 7.0511 | 7.0511 | 7.0511 | 2800.0 |
| 2010-02-12 07:25:00 | AAPL | Stock | 7.0657 | 7.0779 | 7.0657 | 7.0764 | 57876.0 |
| 2010-02-12 07:40:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0668 | 7.0686 | 132860.0 |
| 2010-02-12 07:45:00 | AAPL | Stock | 7.0707 | 7.0714 | 7.0661 | 7.0661 | 154000.0 |
| 2010-02-12 07:55:00 | AAPL | Stock | 7.0657 | 7.0682 | 7.0625 | 7.0682 | 75600.0 |
| 2010-02-12 08:00:00 | AAPL | Stock | 7.0714 | 7.0811 | 7.0629 | 7.0732 | 418544.0 |
| 2010-02-12 08:05:00 | AAPL | Stock | 7.0707 | 7.0714 | 7.0607 | 7.0607 | 110068.0 |
| 2010-02-12 08:10:00 | AAPL | Stock | 7.0593 | 7.0593 | 7.0496 | 7.0564 | 182868.0 |
| 2010-02-12 08:15:00 | AAPL | Stock | 7.0562 | 7.0679 | 7.0525 | 7.0632 | 152488.0 |
| 2010-02-12 08:20:00 | AAPL | Stock | 7.0632 | 7.0679 | 7.0632 | 7.0679 | 126000.0 |
| 2010-02-12 08:25:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0661 | 7.0671 | 137200.0 |
| 2010-02-12 08:30:00 | AAPL | Stock | 7.0679 | 7.0746 | 7.0607 | 7.0643 | 538580.0 |
| 2010-02-12 08:35:00 | AAPL | Stock | 7.0668 | 7.075 | 7.0625 | 7.0743 | 218344.0 |
| 2010-02-12 08:40:00 | AAPL | Stock | 7.0711 | 7.0725 | 7.0679 | 7.0696 | 58800.0 |
| 2010-02-12 08:45:00 | AAPL | Stock | 7.0714 | 7.0786 | 7.0696 | 7.0775 | 289800.0 |
| 2010-02-12 08:50:00 | AAPL | Stock | 7.0779 | 7.0779 | 7.0714 | 7.0721 | 127708.0 |
| 2010-02-12 08:55:00 | AAPL | Stock | 7.0714 | 7.0736 | 7.0696 | 7.0729 | 189420.0 |
| 2010-02-12 09:00:00 | AAPL | Stock | 7.075 | 7.0864 | 7.0739 | 7.085 | 281680.0 |
| 2010-02-12 09:05:00 | AAPL | Stock | 7.0854 | 7.0861 | 7.0782 | 7.0814 | 415884.0 |
| 2010-02-12 09:10:00 | AAPL | Stock | 7.0821 | 7.0843 | 7.0786 | 7.0832 | 181300.0 |
| 2010-02-12 09:15:00 | AAPL | Stock | 7.0811 | 7.0811 | 7.0679 | 7.0679 | 371924.0 |
| 2010-02-12 09:20:00 | AAPL | Stock | 7.0668 | 7.0679 | 7.0593 | 7.0618 | 330008.0 |
| 2010-02-12 09:25:00 | AAPL | Stock | 7.0636 | 7.0786 | 7.0625 | 7.0786 | 670292.0 |
| 2010-02-12 09:30:00 | AAPL | Stock | 7.0782 | 7.0868 | 7.05 | 7.0625 | 18091780.0 |
| 2010-02-12 09:35:00 | AAPL | Stock | 7.0639 | 7.0668 | 7.0407 | 7.0536 | 13357372.0 |
| 2010-02-12 09:40:00 | AAPL | Stock | 7.0532 | 7.0575 | 7.0357 | 7.05 | 9482368.0 |
| 2010-02-12 09:45:00 | AAPL | Stock | 7.05 | 7.05 | 7.0321 | 7.0343 | 10556448.0 |
| 2010-02-12 09:50:00 | AAPL | Stock | 7.0339 | 7.0446 | 7.0279 | 7.0379 | 9166108.0 |
| 2010-02-12 09:55:00 | AAPL | Stock | 7.0375 | 7.0579 | 7.0364 | 7.0521 | 12907104.0 |
| 2010-02-12 10:00:00 | AAPL | Stock | 7.0529 | 7.0571 | 7.0268 | 7.0464 | 13972952.0 |
| 2010-02-12 10:05:00 | AAPL | Stock | 7.0465 | 7.0686 | 7.0429 | 7.0661 | 9714292.0 |
| 2010-02-12 10:10:00 | AAPL | Stock | 7.0661 | 7.0675 | 7.0482 | 7.055 | 7169596.0 |
| 2010-02-12 10:15:00 | AAPL | Stock | 7.0546 | 7.0689 | 7.0479 | 7.055 | 7767732.0 |
| 2010-02-12 10:20:00 | AAPL | Stock | 7.0543 | 7.0625 | 7.0482 | 7.0539 | 5362084.0 |
| 2010-02-12 10:25:00 | AAPL | Stock | 7.0557 | 7.0757 | 7.0554 | 7.0721 | 8470308.0 |
| 2010-02-12 10:30:00 | AAPL | Stock | 7.0721 | 7.0786 | 7.0643 | 7.0729 | 5992532.0 |
| 2010-02-12 10:35:00 | AAPL | Stock | 7.0729 | 7.0732 | 7.0393 | 7.045 | 7935760.0 |
| 2010-02-12 10:40:00 | AAPL | Stock | 7.045 | 7.0539 | 7.0429 | 7.0475 | 4580184.0 |
| 2010-02-12 10:45:00 | AAPL | Stock | 7.0475 | 7.0589 | 7.045 | 7.0493 | 3957464.0 |
| 2010-02-12 10:50:00 | AAPL | Stock | 7.0496 | 7.0637 | 7.045 | 7.0471 | 4461884.0 |
| 2010-02-12 10:55:00 | AAPL | Stock | 7.0493 | 7.0593 | 7.0464 | 7.0543 | 4551960.0 |
| 2010-02-12 11:00:00 | AAPL | Stock | 7.0536 | 7.0586 | 7.0496 | 7.0539 | 5253780.0 |
| 2010-02-12 11:05:00 | AAPL | Stock | 7.0536 | 7.0629 | 7.0521 | 7.0586 | 4029648.0 |
| 2010-02-12 11:10:00 | AAPL | Stock | 7.0593 | 7.0668 | 7.0586 | 7.0668 | 2713200.0 |
> showing 50 of 319,158 rows — these rows as CSV