PREVIEW / stock_5min / 2009-06-30
file: by_date/stock_5min/2009/2009-06-30.parquet size: 4.7 MB rows: 327,805 symbols: 3,335
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-06-30 08:00:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0679 | 5.0821 | 82712.0 |
| 2009-06-30 08:10:00 | AAPL | Stock | 5.0796 | 5.0796 | 5.0779 | 5.0786 | 31696.0 |
| 2009-06-30 08:15:00 | AAPL | Stock | 5.0786 | 5.0786 | 5.0679 | 5.0714 | 90020.0 |
| 2009-06-30 08:20:00 | AAPL | Stock | 5.0704 | 5.0714 | 5.0704 | 5.0714 | 78204.0 |
| 2009-06-30 08:25:00 | AAPL | Stock | 5.0775 | 5.0775 | 5.0775 | 5.0775 | 11200.0 |
| 2009-06-30 08:30:00 | AAPL | Stock | 5.0768 | 5.0768 | 5.0768 | 5.0768 | 29400.0 |
| 2009-06-30 08:35:00 | AAPL | Stock | 5.0721 | 5.0775 | 5.0714 | 5.0743 | 142240.0 |
| 2009-06-30 08:40:00 | AAPL | Stock | 5.0732 | 5.075 | 5.0732 | 5.075 | 93380.0 |
| 2009-06-30 08:45:00 | AAPL | Stock | 5.0775 | 5.0775 | 5.0761 | 5.0768 | 37128.0 |
| 2009-06-30 08:50:00 | AAPL | Stock | 5.0757 | 5.0786 | 5.0757 | 5.0786 | 16800.0 |
| 2009-06-30 08:55:00 | AAPL | Stock | 5.0775 | 5.0775 | 5.0757 | 5.0771 | 266336.0 |
| 2009-06-30 09:00:00 | AAPL | Stock | 5.075 | 5.0793 | 5.0743 | 5.0793 | 179172.0 |
| 2009-06-30 09:05:00 | AAPL | Stock | 5.0821 | 5.0929 | 5.0821 | 5.0882 | 243516.0 |
| 2009-06-30 09:10:00 | AAPL | Stock | 5.0889 | 5.0889 | 5.0818 | 5.0889 | 124040.0 |
| 2009-06-30 09:15:00 | AAPL | Stock | 5.0857 | 5.0861 | 5.0854 | 5.0854 | 67200.0 |
| 2009-06-30 09:20:00 | AAPL | Stock | 5.0857 | 5.0893 | 5.0857 | 5.0893 | 33880.0 |
| 2009-06-30 09:25:00 | AAPL | Stock | 5.0911 | 5.1014 | 5.0882 | 5.0946 | 432432.0 |
| 2009-06-30 09:30:00 | AAPL | Stock | 5.0921 | 5.1189 | 5.0743 | 5.1189 | 21218540.0 |
| 2009-06-30 09:35:00 | AAPL | Stock | 5.1179 | 5.1314 | 5.1114 | 5.1304 | 15368164.0 |
| 2009-06-30 09:40:00 | AAPL | Stock | 5.1307 | 5.1357 | 5.1261 | 5.1314 | 12926536.0 |
| 2009-06-30 09:45:00 | AAPL | Stock | 5.1314 | 5.1339 | 5.1086 | 5.1089 | 11172896.0 |
| 2009-06-30 09:50:00 | AAPL | Stock | 5.1089 | 5.1157 | 5.1018 | 5.1157 | 10166828.0 |
| 2009-06-30 09:55:00 | AAPL | Stock | 5.1157 | 5.1189 | 5.1089 | 5.1118 | 4722564.0 |
| 2009-06-30 10:00:00 | AAPL | Stock | 5.1118 | 5.1118 | 5.0893 | 5.1018 | 14489748.0 |
| 2009-06-30 10:05:00 | AAPL | Stock | 5.1025 | 5.1079 | 5.0893 | 5.1061 | 7679056.0 |
| 2009-06-30 10:10:00 | AAPL | Stock | 5.1061 | 5.1121 | 5.0986 | 5.1071 | 5962768.0 |
| 2009-06-30 10:15:00 | AAPL | Stock | 5.1068 | 5.1068 | 5.085 | 5.0854 | 6526912.0 |
| 2009-06-30 10:20:00 | AAPL | Stock | 5.0854 | 5.0939 | 5.0804 | 5.0917 | 7887320.0 |
| 2009-06-30 10:25:00 | AAPL | Stock | 5.0911 | 5.0932 | 5.0804 | 5.0861 | 4959976.0 |
| 2009-06-30 10:30:00 | AAPL | Stock | 5.0857 | 5.0857 | 5.0643 | 5.0728 | 11860296.0 |
| 2009-06-30 10:35:00 | AAPL | Stock | 5.0721 | 5.0839 | 5.0682 | 5.0786 | 7884072.0 |
| 2009-06-30 10:40:00 | AAPL | Stock | 5.0789 | 5.0918 | 5.0768 | 5.0879 | 7092680.0 |
| 2009-06-30 10:45:00 | AAPL | Stock | 5.0875 | 5.0939 | 5.0836 | 5.0914 | 6053432.0 |
| 2009-06-30 10:50:00 | AAPL | Stock | 5.0914 | 5.0921 | 5.0782 | 5.0804 | 5532520.0 |
| 2009-06-30 10:55:00 | AAPL | Stock | 5.0804 | 5.0907 | 5.0796 | 5.0836 | 4159540.0 |
| 2009-06-30 11:00:00 | AAPL | Stock | 5.0832 | 5.0925 | 5.0821 | 5.09 | 3471580.0 |
| 2009-06-30 11:05:00 | AAPL | Stock | 5.0896 | 5.0957 | 5.0818 | 5.0843 | 5397364.0 |
| 2009-06-30 11:10:00 | AAPL | Stock | 5.0836 | 5.0868 | 5.0793 | 5.0811 | 3429468.0 |
| 2009-06-30 11:15:00 | AAPL | Stock | 5.0807 | 5.0889 | 5.0793 | 5.0876 | 1869700.0 |
| 2009-06-30 11:20:00 | AAPL | Stock | 5.0871 | 5.0896 | 5.0796 | 5.0804 | 2775696.0 |
| 2009-06-30 11:25:00 | AAPL | Stock | 5.0807 | 5.0829 | 5.0732 | 5.0743 | 3401720.0 |
| 2009-06-30 11:30:00 | AAPL | Stock | 5.0743 | 5.0782 | 5.0671 | 5.0768 | 5770996.0 |
| 2009-06-30 11:35:00 | AAPL | Stock | 5.0761 | 5.0771 | 5.0675 | 5.075 | 4678716.0 |
| 2009-06-30 11:40:00 | AAPL | Stock | 5.075 | 5.0761 | 5.0693 | 5.0707 | 3085964.0 |
| 2009-06-30 11:45:00 | AAPL | Stock | 5.0704 | 5.0779 | 5.0696 | 5.0771 | 3234952.0 |
| 2009-06-30 11:50:00 | AAPL | Stock | 5.0769 | 5.0821 | 5.0754 | 5.0771 | 3164616.0 |
| 2009-06-30 11:55:00 | AAPL | Stock | 5.0779 | 5.0789 | 5.0739 | 5.0768 | 2561300.0 |
| 2009-06-30 12:00:00 | AAPL | Stock | 5.0768 | 5.0779 | 5.0746 | 5.0757 | 1689380.0 |
| 2009-06-30 12:05:00 | AAPL | Stock | 5.0775 | 5.0782 | 5.0761 | 5.0764 | 1133524.0 |
| 2009-06-30 12:10:00 | AAPL | Stock | 5.0764 | 5.0789 | 5.0736 | 5.0782 | 2343684.0 |
> showing 50 of 327,805 rows — these rows as CSV