PREVIEW / stock_5min / 2009-08-24
file: by_date/stock_5min/2009/2009-08-24.parquet size: 4.6 MB rows: 317,848 symbols: 3,390
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-24 04:15:00 | AAPL | Stock | 6.0482 | 6.0714 | 6.0482 | 6.0714 | 7560.0 |
| 2009-08-24 07:20:00 | AAPL | Stock | 6.0679 | 6.0679 | 6.0679 | 6.0679 | 14000.0 |
| 2009-08-24 07:25:00 | AAPL | Stock | 6.0686 | 6.0714 | 6.0679 | 6.0679 | 94080.0 |
| 2009-08-24 07:30:00 | AAPL | Stock | 6.0643 | 6.0643 | 6.0643 | 6.0643 | 2800.0 |
| 2009-08-24 07:35:00 | AAPL | Stock | 6.0686 | 6.0714 | 6.0686 | 6.0714 | 40040.0 |
| 2009-08-24 07:40:00 | AAPL | Stock | 6.0714 | 6.0761 | 6.0714 | 6.0761 | 32760.0 |
| 2009-08-24 07:45:00 | AAPL | Stock | 6.075 | 6.075 | 6.075 | 6.075 | 3920.0 |
| 2009-08-24 07:50:00 | AAPL | Stock | 6.0718 | 6.0761 | 6.0714 | 6.0761 | 14588.0 |
| 2009-08-24 08:00:00 | AAPL | Stock | 6.0718 | 6.0779 | 6.0643 | 6.0714 | 411628.0 |
| 2009-08-24 08:05:00 | AAPL | Stock | 6.0743 | 6.0757 | 6.0714 | 6.0718 | 304836.0 |
| 2009-08-24 08:10:00 | AAPL | Stock | 6.0754 | 6.0882 | 6.0729 | 6.0871 | 336224.0 |
| 2009-08-24 08:15:00 | AAPL | Stock | 6.0868 | 6.0868 | 6.0821 | 6.0861 | 75208.0 |
| 2009-08-24 08:20:00 | AAPL | Stock | 6.0839 | 6.0857 | 6.0757 | 6.0832 | 481152.0 |
| 2009-08-24 08:25:00 | AAPL | Stock | 6.0832 | 6.0832 | 6.0796 | 6.0804 | 86240.0 |
| 2009-08-24 08:30:00 | AAPL | Stock | 6.0804 | 6.0804 | 6.0679 | 6.0714 | 217812.0 |
| 2009-08-24 08:35:00 | AAPL | Stock | 6.0732 | 6.0732 | 6.0721 | 6.0721 | 46200.0 |
| 2009-08-24 08:40:00 | AAPL | Stock | 6.0757 | 6.0821 | 6.0725 | 6.0818 | 89488.0 |
| 2009-08-24 08:45:00 | AAPL | Stock | 6.0814 | 6.0839 | 6.0814 | 6.0839 | 148652.0 |
| 2009-08-24 08:50:00 | AAPL | Stock | 6.0839 | 6.0839 | 6.075 | 6.0804 | 129780.0 |
| 2009-08-24 08:55:00 | AAPL | Stock | 6.0811 | 6.0821 | 6.0771 | 6.0814 | 84504.0 |
| 2009-08-24 09:00:00 | AAPL | Stock | 6.0821 | 6.0857 | 6.0821 | 6.0857 | 59416.0 |
| 2009-08-24 09:05:00 | AAPL | Stock | 6.0857 | 6.0875 | 6.0829 | 6.0839 | 180180.0 |
| 2009-08-24 09:10:00 | AAPL | Stock | 6.0832 | 6.0868 | 6.0832 | 6.0868 | 119980.0 |
| 2009-08-24 09:15:00 | AAPL | Stock | 6.0875 | 6.0875 | 6.0832 | 6.0839 | 167580.0 |
| 2009-08-24 09:20:00 | AAPL | Stock | 6.0836 | 6.0861 | 6.0832 | 6.0861 | 149800.0 |
| 2009-08-24 09:25:00 | AAPL | Stock | 6.085 | 6.085 | 6.0714 | 6.0739 | 648200.0 |
| 2009-08-24 09:30:00 | AAPL | Stock | 6.0757 | 6.0779 | 6.0457 | 6.0696 | 23090032.0 |
| 2009-08-24 09:35:00 | AAPL | Stock | 6.0689 | 6.07 | 6.0575 | 6.0636 | 10505264.0 |
| 2009-08-24 09:40:00 | AAPL | Stock | 6.0632 | 6.0668 | 6.0375 | 6.0404 | 14486668.0 |
| 2009-08-24 09:45:00 | AAPL | Stock | 6.0402 | 6.0471 | 6.025 | 6.0418 | 15578192.0 |
| 2009-08-24 09:50:00 | AAPL | Stock | 6.0432 | 6.0443 | 6.0329 | 6.0429 | 9003512.0 |
| 2009-08-24 09:55:00 | AAPL | Stock | 6.0439 | 6.0786 | 6.0425 | 6.071 | 21589008.0 |
| 2009-08-24 10:00:00 | AAPL | Stock | 6.07 | 6.0782 | 6.0686 | 6.0725 | 8254204.0 |
| 2009-08-24 10:05:00 | AAPL | Stock | 6.0725 | 6.0946 | 6.0721 | 6.0896 | 10577840.0 |
| 2009-08-24 10:10:00 | AAPL | Stock | 6.0911 | 6.0968 | 6.0859 | 6.0889 | 7267960.0 |
| 2009-08-24 10:15:00 | AAPL | Stock | 6.0886 | 6.0921 | 6.0821 | 6.0889 | 9115204.0 |
| 2009-08-24 10:20:00 | AAPL | Stock | 6.0891 | 6.0893 | 6.0832 | 6.0893 | 2859864.0 |
| 2009-08-24 10:25:00 | AAPL | Stock | 6.0893 | 6.0929 | 6.0839 | 6.0871 | 5352284.0 |
| 2009-08-24 10:30:00 | AAPL | Stock | 6.0875 | 6.0886 | 6.0836 | 6.086 | 4037852.0 |
| 2009-08-24 10:35:00 | AAPL | Stock | 6.0861 | 6.0893 | 6.0854 | 6.0875 | 3394580.0 |
| 2009-08-24 10:40:00 | AAPL | Stock | 6.0871 | 6.0879 | 6.0839 | 6.0868 | 3167696.0 |
| 2009-08-24 10:45:00 | AAPL | Stock | 6.0875 | 6.0882 | 6.0814 | 6.0846 | 4111548.0 |
| 2009-08-24 10:50:00 | AAPL | Stock | 6.0846 | 6.0875 | 6.0782 | 6.08 | 4251352.0 |
| 2009-08-24 10:55:00 | AAPL | Stock | 6.08 | 6.0868 | 6.0786 | 6.0849 | 3092740.0 |
| 2009-08-24 11:00:00 | AAPL | Stock | 6.0854 | 6.0879 | 6.0825 | 6.0878 | 2082332.0 |
| 2009-08-24 11:05:00 | AAPL | Stock | 6.0875 | 6.0932 | 6.0861 | 6.0929 | 3778852.0 |
| 2009-08-24 11:10:00 | AAPL | Stock | 6.0925 | 6.095 | 6.0893 | 6.0904 | 2934736.0 |
| 2009-08-24 11:15:00 | AAPL | Stock | 6.0904 | 6.0914 | 6.0857 | 6.0886 | 2224460.0 |
| 2009-08-24 11:20:00 | AAPL | Stock | 6.0882 | 6.0896 | 6.0804 | 6.0814 | 3921064.0 |
| 2009-08-24 11:25:00 | AAPL | Stock | 6.0814 | 6.0857 | 6.08 | 6.0836 | 3001348.0 |
> showing 50 of 317,848 rows — these rows as CSV