PREVIEW / stock_5min / 2007-02-08
file: by_date/stock_5min/2007/2007-02-08.parquet size: 3.2 MB rows: 234,190 symbols: 2,496
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-08 04:15:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 11844.0 |
| 2007-02-08 04:40:00 | AAPL | Stock | 3.0764 | 3.0764 | 3.0764 | 3.0764 | 11200.0 |
| 2007-02-08 06:00:00 | AAPL | Stock | 3.0889 | 3.0889 | 3.0889 | 3.0889 | 2800.0 |
| 2007-02-08 06:05:00 | AAPL | Stock | 3.0796 | 3.0796 | 3.0718 | 3.0718 | 87444.0 |
| 2007-02-08 06:20:00 | AAPL | Stock | 3.0693 | 3.0693 | 3.0689 | 3.0689 | 20860.0 |
| 2007-02-08 06:40:00 | AAPL | Stock | 3.0604 | 3.0604 | 3.0604 | 3.0604 | 2800.0 |
| 2007-02-08 06:45:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0679 | 3.0679 | 2800.0 |
| 2007-02-08 06:55:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0661 | 3.0661 | 28000.0 |
| 2007-02-08 07:00:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0625 | 3.0625 | 53200.0 |
| 2007-02-08 07:05:00 | AAPL | Stock | 3.0629 | 3.0657 | 3.0629 | 3.0657 | 14000.0 |
| 2007-02-08 07:10:00 | AAPL | Stock | 3.0657 | 3.0657 | 3.0657 | 3.0657 | 5600.0 |
| 2007-02-08 07:20:00 | AAPL | Stock | 3.0625 | 3.0657 | 3.0604 | 3.0639 | 25340.0 |
| 2007-02-08 07:25:00 | AAPL | Stock | 3.0675 | 3.0679 | 3.0589 | 3.0589 | 125860.0 |
| 2007-02-08 07:30:00 | AAPL | Stock | 3.0546 | 3.0629 | 3.0536 | 3.0625 | 95200.0 |
| 2007-02-08 07:35:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 2800.0 |
| 2007-02-08 07:40:00 | AAPL | Stock | 3.0618 | 3.0625 | 3.0536 | 3.0536 | 30800.0 |
| 2007-02-08 07:45:00 | AAPL | Stock | 3.0546 | 3.0546 | 3.0546 | 3.0546 | 14000.0 |
| 2007-02-08 07:50:00 | AAPL | Stock | 3.06 | 3.06 | 3.0536 | 3.0536 | 68600.0 |
| 2007-02-08 07:55:00 | AAPL | Stock | 3.0536 | 3.0554 | 3.0536 | 3.0554 | 109200.0 |
| 2007-02-08 08:00:00 | AAPL | Stock | 3.0571 | 3.0636 | 3.0539 | 3.0636 | 891660.0 |
| 2007-02-08 08:05:00 | AAPL | Stock | 3.0643 | 3.0657 | 3.0607 | 3.0643 | 806400.0 |
| 2007-02-08 08:10:00 | AAPL | Stock | 3.0643 | 3.0689 | 3.0643 | 3.0661 | 478408.0 |
| 2007-02-08 08:15:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0607 | 3.0611 | 414540.0 |
| 2007-02-08 08:20:00 | AAPL | Stock | 3.0607 | 3.0607 | 3.0554 | 3.0571 | 616812.0 |
| 2007-02-08 08:25:00 | AAPL | Stock | 3.0582 | 3.0589 | 3.0561 | 3.0571 | 357812.0 |
| 2007-02-08 08:30:00 | AAPL | Stock | 3.0589 | 3.0604 | 3.0571 | 3.0593 | 155092.0 |
| 2007-02-08 08:35:00 | AAPL | Stock | 3.0582 | 3.0621 | 3.0579 | 3.0621 | 42560.0 |
| 2007-02-08 08:40:00 | AAPL | Stock | 3.0621 | 3.0661 | 3.0604 | 3.0643 | 385840.0 |
| 2007-02-08 08:45:00 | AAPL | Stock | 3.0643 | 3.0679 | 3.0614 | 3.0614 | 597184.0 |
| 2007-02-08 08:50:00 | AAPL | Stock | 3.0636 | 3.0639 | 3.06 | 3.06 | 221704.0 |
| 2007-02-08 08:55:00 | AAPL | Stock | 3.0593 | 3.0593 | 3.0564 | 3.0564 | 530852.0 |
| 2007-02-08 09:00:00 | AAPL | Stock | 3.0586 | 3.0589 | 3.0561 | 3.0561 | 635040.0 |
| 2007-02-08 09:05:00 | AAPL | Stock | 3.0561 | 3.0575 | 3.0557 | 3.0564 | 346612.0 |
| 2007-02-08 09:10:00 | AAPL | Stock | 3.0564 | 3.0575 | 3.0543 | 3.0564 | 669340.0 |
| 2007-02-08 09:15:00 | AAPL | Stock | 3.0564 | 3.0564 | 3.0529 | 3.055 | 424872.0 |
| 2007-02-08 09:20:00 | AAPL | Stock | 3.0561 | 3.0564 | 3.0518 | 3.0532 | 415184.0 |
| 2007-02-08 09:25:00 | AAPL | Stock | 3.0532 | 3.0625 | 3.0489 | 3.0525 | 2979900.0 |
| 2007-02-08 09:30:00 | AAPL | Stock | 3.0511 | 3.0775 | 3.0504 | 3.075 | 43046668.0 |
| 2007-02-08 09:35:00 | AAPL | Stock | 3.075 | 3.0896 | 3.0707 | 3.0782 | 36768788.0 |
| 2007-02-08 09:40:00 | AAPL | Stock | 3.0775 | 3.0786 | 3.0536 | 3.0579 | 25240628.0 |
| 2007-02-08 09:45:00 | AAPL | Stock | 3.0579 | 3.0661 | 3.0546 | 3.0586 | 22928668.0 |
| 2007-02-08 09:50:00 | AAPL | Stock | 3.0582 | 3.0707 | 3.0582 | 3.0697 | 11533900.0 |
| 2007-02-08 09:55:00 | AAPL | Stock | 3.0696 | 3.075 | 3.0604 | 3.0618 | 10121720.0 |
| 2007-02-08 10:00:00 | AAPL | Stock | 3.0618 | 3.0818 | 3.0611 | 3.0754 | 21876232.0 |
| 2007-02-08 10:05:00 | AAPL | Stock | 3.0754 | 3.0761 | 3.0657 | 3.0661 | 11837980.0 |
| 2007-02-08 10:10:00 | AAPL | Stock | 3.0661 | 3.0707 | 3.0646 | 3.0671 | 8626632.0 |
| 2007-02-08 10:15:00 | AAPL | Stock | 3.0668 | 3.0689 | 3.0586 | 3.0607 | 12295948.0 |
| 2007-02-08 10:20:00 | AAPL | Stock | 3.0607 | 3.0657 | 3.0596 | 3.0643 | 9397864.0 |
| 2007-02-08 10:25:00 | AAPL | Stock | 3.0643 | 3.0671 | 3.06 | 3.0618 | 8959160.0 |
| 2007-02-08 10:30:00 | AAPL | Stock | 3.0621 | 3.0682 | 3.0589 | 3.0664 | 10493168.0 |
> showing 50 of 234,190 rows — these rows as CSV