PREVIEW / stock_5min / 2007-01-29
file: by_date/stock_5min/2007/2007-01-29.parquet size: 3.3 MB rows: 242,388 symbols: 2,514
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-01-29 07:00:00 | AAPL | Stock | 3.0436 | 3.0436 | 3.0436 | 3.0436 | 26600.0 |
| 2007-01-29 07:40:00 | AAPL | Stock | 3.0464 | 3.0464 | 3.0439 | 3.0439 | 16800.0 |
| 2007-01-29 07:45:00 | AAPL | Stock | 3.0471 | 3.0471 | 3.0471 | 3.0471 | 42000.0 |
| 2007-01-29 07:50:00 | AAPL | Stock | 3.0471 | 3.0471 | 3.0471 | 3.0471 | 28000.0 |
| 2007-01-29 07:55:00 | AAPL | Stock | 3.0536 | 3.0707 | 3.0536 | 3.0586 | 736400.0 |
| 2007-01-29 08:00:00 | AAPL | Stock | 3.0625 | 3.0786 | 3.0611 | 3.0754 | 2015636.0 |
| 2007-01-29 08:05:00 | AAPL | Stock | 3.0754 | 3.0789 | 3.0682 | 3.0693 | 837984.0 |
| 2007-01-29 08:10:00 | AAPL | Stock | 3.0696 | 3.0729 | 3.0675 | 3.0714 | 544292.0 |
| 2007-01-29 08:15:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0668 | 3.0671 | 311668.0 |
| 2007-01-29 08:20:00 | AAPL | Stock | 3.0686 | 3.0711 | 3.0679 | 3.07 | 323624.0 |
| 2007-01-29 08:25:00 | AAPL | Stock | 3.07 | 3.0711 | 3.0679 | 3.0704 | 570640.0 |
| 2007-01-29 08:30:00 | AAPL | Stock | 3.0696 | 3.0714 | 3.0696 | 3.0711 | 579208.0 |
| 2007-01-29 08:35:00 | AAPL | Stock | 3.0711 | 3.075 | 3.07 | 3.0746 | 785680.0 |
| 2007-01-29 08:40:00 | AAPL | Stock | 3.0739 | 3.0739 | 3.0696 | 3.0707 | 566720.0 |
| 2007-01-29 08:45:00 | AAPL | Stock | 3.0718 | 3.0736 | 3.0704 | 3.0725 | 550564.0 |
| 2007-01-29 08:50:00 | AAPL | Stock | 3.0725 | 3.0732 | 3.0721 | 3.0725 | 347228.0 |
| 2007-01-29 08:55:00 | AAPL | Stock | 3.0732 | 3.075 | 3.0721 | 3.075 | 210896.0 |
| 2007-01-29 09:00:00 | AAPL | Stock | 3.0739 | 3.0796 | 3.0736 | 3.0786 | 982184.0 |
| 2007-01-29 09:05:00 | AAPL | Stock | 3.0786 | 3.0836 | 3.0786 | 3.0836 | 1239336.0 |
| 2007-01-29 09:10:00 | AAPL | Stock | 3.0836 | 3.0889 | 3.0832 | 3.0868 | 1588720.0 |
| 2007-01-29 09:15:00 | AAPL | Stock | 3.0868 | 3.0875 | 3.0829 | 3.0857 | 413000.0 |
| 2007-01-29 09:20:00 | AAPL | Stock | 3.0857 | 3.0879 | 3.0804 | 3.0811 | 712180.0 |
| 2007-01-29 09:25:00 | AAPL | Stock | 3.0807 | 3.0832 | 3.0768 | 3.0821 | 1721608.0 |
| 2007-01-29 09:30:00 | AAPL | Stock | 3.0821 | 3.0857 | 3.0661 | 3.0714 | 31200512.0 |
| 2007-01-29 09:35:00 | AAPL | Stock | 3.0711 | 3.0875 | 3.0643 | 3.0864 | 27050268.0 |
| 2007-01-29 09:40:00 | AAPL | Stock | 3.0868 | 3.0943 | 3.0846 | 3.0896 | 32742416.0 |
| 2007-01-29 09:45:00 | AAPL | Stock | 3.0896 | 3.0918 | 3.0775 | 3.0807 | 22449224.0 |
| 2007-01-29 09:50:00 | AAPL | Stock | 3.0804 | 3.0836 | 3.0654 | 3.0757 | 24236940.0 |
| 2007-01-29 09:55:00 | AAPL | Stock | 3.0757 | 3.0775 | 3.0657 | 3.0739 | 15125768.0 |
| 2007-01-29 10:00:00 | AAPL | Stock | 3.0736 | 3.0854 | 3.0714 | 3.0825 | 22589756.0 |
| 2007-01-29 10:05:00 | AAPL | Stock | 3.0829 | 3.0907 | 3.0807 | 3.0875 | 15574720.0 |
| 2007-01-29 10:10:00 | AAPL | Stock | 3.0871 | 3.0871 | 3.0736 | 3.0768 | 15890672.0 |
| 2007-01-29 10:15:00 | AAPL | Stock | 3.0768 | 3.0829 | 3.0607 | 3.0632 | 30445268.0 |
| 2007-01-29 10:20:00 | AAPL | Stock | 3.0632 | 3.0675 | 3.0582 | 3.065 | 26103924.0 |
| 2007-01-29 10:25:00 | AAPL | Stock | 3.0632 | 3.0707 | 3.0607 | 3.0629 | 16853788.0 |
| 2007-01-29 10:30:00 | AAPL | Stock | 3.0625 | 3.0675 | 3.0589 | 3.0632 | 13816740.0 |
| 2007-01-29 10:35:00 | AAPL | Stock | 3.0632 | 3.0693 | 3.0575 | 3.0654 | 14129528.0 |
| 2007-01-29 10:40:00 | AAPL | Stock | 3.065 | 3.0754 | 3.0643 | 3.0736 | 16702924.0 |
| 2007-01-29 10:45:00 | AAPL | Stock | 3.0739 | 3.0814 | 3.0721 | 3.0796 | 13546316.0 |
| 2007-01-29 10:50:00 | AAPL | Stock | 3.0793 | 3.0821 | 3.0757 | 3.0785 | 13401640.0 |
| 2007-01-29 10:55:00 | AAPL | Stock | 3.0782 | 3.0793 | 3.0721 | 3.0729 | 6816208.0 |
| 2007-01-29 11:00:00 | AAPL | Stock | 3.0736 | 3.0775 | 3.0714 | 3.0764 | 12435976.0 |
| 2007-01-29 11:05:00 | AAPL | Stock | 3.0768 | 3.0779 | 3.0718 | 3.0754 | 7452956.0 |
| 2007-01-29 11:10:00 | AAPL | Stock | 3.0754 | 3.0811 | 3.0746 | 3.0782 | 12272456.0 |
| 2007-01-29 11:15:00 | AAPL | Stock | 3.0782 | 3.0793 | 3.0714 | 3.0732 | 6846112.0 |
| 2007-01-29 11:20:00 | AAPL | Stock | 3.0732 | 3.0754 | 3.0693 | 3.075 | 7780108.0 |
| 2007-01-29 11:25:00 | AAPL | Stock | 3.075 | 3.0775 | 3.0739 | 3.0764 | 4819584.0 |
| 2007-01-29 11:30:00 | AAPL | Stock | 3.0764 | 3.0764 | 3.07 | 3.0711 | 8333528.0 |
| 2007-01-29 11:35:00 | AAPL | Stock | 3.0711 | 3.0754 | 3.0707 | 3.0736 | 5972288.0 |
| 2007-01-29 11:40:00 | AAPL | Stock | 3.0736 | 3.0796 | 3.0732 | 3.0779 | 10353728.0 |
> showing 50 of 242,388 rows — these rows as CSV