PREVIEW / stock_5min / 2013-09-20
file: by_date/stock_5min/2013/2013-09-20.parquet size: 5.4 MB rows: 354,912 symbols: 3,537
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 |
|---|---|---|---|---|---|---|---|
| 2013-09-20 04:00:00 | AAPL | Stock | 16.8264 | 16.8264 | 16.8182 | 16.8182 | 8400.0 |
| 2013-09-20 04:05:00 | AAPL | Stock | 16.87 | 16.87 | 16.8214 | 16.8568 | 14000.0 |
| 2013-09-20 04:35:00 | AAPL | Stock | 16.8375 | 16.8375 | 16.8375 | 16.8375 | 14000.0 |
| 2013-09-20 04:45:00 | AAPL | Stock | 16.8268 | 16.8268 | 16.8268 | 16.8268 | 2800.0 |
| 2013-09-20 04:55:00 | AAPL | Stock | 16.8268 | 16.8268 | 16.8257 | 16.8257 | 5600.0 |
| 2013-09-20 05:20:00 | AAPL | Stock | 16.8396 | 16.8396 | 16.8396 | 16.8396 | 2800.0 |
| 2013-09-20 05:45:00 | AAPL | Stock | 16.8514 | 16.8679 | 16.8514 | 16.8679 | 37800.0 |
| 2013-09-20 06:05:00 | AAPL | Stock | 16.8907 | 16.8925 | 16.8907 | 16.8925 | 8400.0 |
| 2013-09-20 06:30:00 | AAPL | Stock | 16.9275 | 16.9275 | 16.9275 | 16.9275 | 2800.0 |
| 2013-09-20 06:35:00 | AAPL | Stock | 16.9268 | 16.9268 | 16.9246 | 16.9246 | 9520.0 |
| 2013-09-20 06:45:00 | AAPL | Stock | 16.9282 | 16.9321 | 16.9282 | 16.9321 | 5600.0 |
| 2013-09-20 06:50:00 | AAPL | Stock | 16.9375 | 16.9375 | 16.9375 | 16.9375 | 14000.0 |
| 2013-09-20 06:55:00 | AAPL | Stock | 16.9268 | 16.9268 | 16.9268 | 16.9268 | 8400.0 |
| 2013-09-20 07:00:00 | AAPL | Stock | 16.9225 | 16.9286 | 16.9107 | 16.9107 | 67984.0 |
| 2013-09-20 07:05:00 | AAPL | Stock | 16.8929 | 16.8929 | 16.8929 | 16.8929 | 20188.0 |
| 2013-09-20 07:10:00 | AAPL | Stock | 16.8929 | 16.8982 | 16.8893 | 16.8982 | 64820.0 |
| 2013-09-20 07:15:00 | AAPL | Stock | 16.8996 | 16.9211 | 16.8996 | 16.9107 | 33208.0 |
| 2013-09-20 07:20:00 | AAPL | Stock | 16.9125 | 16.9157 | 16.9125 | 16.9143 | 22008.0 |
| 2013-09-20 07:25:00 | AAPL | Stock | 16.9143 | 16.9143 | 16.8932 | 16.9018 | 133812.0 |
| 2013-09-20 07:30:00 | AAPL | Stock | 16.9036 | 16.9157 | 16.9036 | 16.9157 | 23072.0 |
| 2013-09-20 07:35:00 | AAPL | Stock | 16.9154 | 16.9279 | 16.9154 | 16.9171 | 80052.0 |
| 2013-09-20 07:40:00 | AAPL | Stock | 16.9289 | 16.9289 | 16.9125 | 16.9125 | 54796.0 |
| 2013-09-20 07:45:00 | AAPL | Stock | 16.9271 | 17.0 | 16.9271 | 17.0 | 431788.0 |
| 2013-09-20 07:50:00 | AAPL | Stock | 16.9893 | 17.1104 | 16.9821 | 17.1071 | 708792.0 |
| 2013-09-20 07:55:00 | AAPL | Stock | 17.0896 | 17.1046 | 17.0489 | 17.0807 | 655200.0 |
| 2013-09-20 08:00:00 | AAPL | Stock | 17.0807 | 17.1068 | 16.9904 | 17.0621 | 1717212.0 |
| 2013-09-20 08:05:00 | AAPL | Stock | 17.0711 | 17.1143 | 17.0711 | 17.1071 | 1217076.0 |
| 2013-09-20 08:10:00 | AAPL | Stock | 17.1068 | 17.1179 | 17.0943 | 17.1 | 576996.0 |
| 2013-09-20 08:15:00 | AAPL | Stock | 17.1071 | 17.1443 | 17.0993 | 17.125 | 1139740.0 |
| 2013-09-20 08:20:00 | AAPL | Stock | 17.125 | 17.125 | 17.105 | 17.1132 | 671860.0 |
| 2013-09-20 08:25:00 | AAPL | Stock | 17.1182 | 17.1529 | 17.1139 | 17.1382 | 826924.0 |
| 2013-09-20 08:30:00 | AAPL | Stock | 17.1457 | 17.1518 | 17.1207 | 17.125 | 727048.0 |
| 2013-09-20 08:35:00 | AAPL | Stock | 17.1243 | 17.1393 | 17.1243 | 17.1382 | 408688.0 |
| 2013-09-20 08:40:00 | AAPL | Stock | 17.1339 | 17.1339 | 17.1096 | 17.1096 | 256116.0 |
| 2013-09-20 08:45:00 | AAPL | Stock | 17.1114 | 17.1232 | 17.0893 | 17.0893 | 1028972.0 |
| 2013-09-20 08:50:00 | AAPL | Stock | 17.0929 | 17.0971 | 17.075 | 17.0857 | 910812.0 |
| 2013-09-20 08:55:00 | AAPL | Stock | 17.0868 | 17.1046 | 17.0857 | 17.0936 | 439292.0 |
| 2013-09-20 09:00:00 | AAPL | Stock | 17.09 | 17.1068 | 17.0893 | 17.0982 | 445620.0 |
| 2013-09-20 09:05:00 | AAPL | Stock | 17.1032 | 17.1171 | 17.0964 | 17.1171 | 369824.0 |
| 2013-09-20 09:10:00 | AAPL | Stock | 17.1086 | 17.1086 | 17.0961 | 17.1014 | 417172.0 |
| 2013-09-20 09:15:00 | AAPL | Stock | 17.0996 | 17.1057 | 17.0943 | 17.0979 | 223020.0 |
| 2013-09-20 09:20:00 | AAPL | Stock | 17.0964 | 17.1 | 17.0804 | 17.0804 | 382116.0 |
| 2013-09-20 09:25:00 | AAPL | Stock | 17.0829 | 17.1107 | 17.0679 | 17.0714 | 1038268.0 |
| 2013-09-20 09:30:00 | AAPL | Stock | 17.0671 | 17.0911 | 17.0275 | 17.0354 | 62137320.0 |
| 2013-09-20 09:35:00 | AAPL | Stock | 17.0356 | 17.0421 | 17.0107 | 17.0296 | 11915792.0 |
| 2013-09-20 09:40:00 | AAPL | Stock | 17.025 | 17.0464 | 16.975 | 16.9796 | 11733148.0 |
| 2013-09-20 09:45:00 | AAPL | Stock | 16.9832 | 16.9957 | 16.8811 | 16.9164 | 21893172.0 |
| 2013-09-20 09:50:00 | AAPL | Stock | 16.9161 | 16.9586 | 16.9129 | 16.9529 | 10024000.0 |
| 2013-09-20 09:55:00 | AAPL | Stock | 16.955 | 16.9585 | 16.9036 | 16.9121 | 5095160.0 |
| 2013-09-20 10:00:00 | AAPL | Stock | 16.9068 | 16.9746 | 16.9018 | 16.9586 | 8700132.0 |
> showing 50 of 354,912 rows — these rows as CSV