PREVIEW / stock_1min / 2012-09-21
file: by_date/stock_1min/2012/2012-09-21.parquet size: 13.3 MB rows: 988,374 symbols: 2,832
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-21 04:06:00 | AAPL | Stock | 24.9911 | 24.9911 | 24.9911 | 24.9911 | 5600.0 |
| 2012-09-21 04:08:00 | AAPL | Stock | 24.9914 | 24.9914 | 24.9914 | 24.9914 | 5600.0 |
| 2012-09-21 04:18:00 | AAPL | Stock | 25.0011 | 25.0011 | 25.0011 | 25.0011 | 2800.0 |
| 2012-09-21 04:31:00 | AAPL | Stock | 25.0125 | 25.0125 | 25.0125 | 25.0125 | 2800.0 |
| 2012-09-21 04:34:00 | AAPL | Stock | 25.0021 | 25.0021 | 25.0021 | 25.0021 | 5600.0 |
| 2012-09-21 04:38:00 | AAPL | Stock | 25.0125 | 25.0125 | 25.0125 | 25.0125 | 8400.0 |
| 2012-09-21 04:39:00 | AAPL | Stock | 25.0161 | 25.0161 | 25.0161 | 25.0161 | 5600.0 |
| 2012-09-21 04:52:00 | AAPL | Stock | 25.0357 | 25.0357 | 25.0357 | 25.0357 | 2800.0 |
| 2012-09-21 04:53:00 | AAPL | Stock | 25.045 | 25.045 | 25.045 | 25.045 | 2800.0 |
| 2012-09-21 05:08:00 | AAPL | Stock | 25.0446 | 25.0446 | 25.0446 | 25.0446 | 2800.0 |
| 2012-09-21 05:11:00 | AAPL | Stock | 25.0446 | 25.0446 | 25.0446 | 25.0446 | 5600.0 |
| 2012-09-21 05:14:00 | AAPL | Stock | 25.0446 | 25.0475 | 25.0446 | 25.0475 | 5600.0 |
| 2012-09-21 06:27:00 | AAPL | Stock | 25.0214 | 25.0214 | 25.0214 | 25.0214 | 5180.0 |
| 2012-09-21 06:35:00 | AAPL | Stock | 25.0475 | 25.0475 | 25.0475 | 25.0475 | 14000.0 |
| 2012-09-21 06:40:00 | AAPL | Stock | 25.0475 | 25.0475 | 25.0475 | 25.0475 | 12600.0 |
| 2012-09-21 06:51:00 | AAPL | Stock | 25.0393 | 25.0393 | 25.0393 | 25.0393 | 2800.0 |
| 2012-09-21 07:00:00 | AAPL | Stock | 25.0654 | 25.0654 | 25.0654 | 25.0654 | 2800.0 |
| 2012-09-21 07:01:00 | AAPL | Stock | 25.0446 | 25.0536 | 25.0446 | 25.0536 | 5600.0 |
| 2012-09-21 07:02:00 | AAPL | Stock | 25.0386 | 25.0389 | 25.0357 | 25.0389 | 60368.0 |
| 2012-09-21 07:03:00 | AAPL | Stock | 25.0307 | 25.0357 | 25.0307 | 25.0357 | 11200.0 |
| 2012-09-21 07:04:00 | AAPL | Stock | 25.0518 | 25.0529 | 25.0518 | 25.0529 | 8400.0 |
| 2012-09-21 07:05:00 | AAPL | Stock | 25.0536 | 25.0593 | 25.0536 | 25.0536 | 56000.0 |
| 2012-09-21 07:06:00 | AAPL | Stock | 25.0429 | 25.0536 | 25.0429 | 25.0536 | 23520.0 |
| 2012-09-21 07:07:00 | AAPL | Stock | 25.0536 | 25.0543 | 25.0536 | 25.0536 | 24472.0 |
| 2012-09-21 07:08:00 | AAPL | Stock | 25.0675 | 25.0754 | 25.0607 | 25.0754 | 100800.0 |
| 2012-09-21 07:09:00 | AAPL | Stock | 25.0736 | 25.0736 | 25.0736 | 25.0736 | 2800.0 |
| 2012-09-21 07:10:00 | AAPL | Stock | 25.0871 | 25.0893 | 25.0871 | 25.0893 | 28868.0 |
| 2012-09-21 07:11:00 | AAPL | Stock | 25.1007 | 25.1018 | 25.0811 | 25.0811 | 32480.0 |
| 2012-09-21 07:12:00 | AAPL | Stock | 25.0714 | 25.0714 | 25.0714 | 25.0714 | 11900.0 |
| 2012-09-21 07:13:00 | AAPL | Stock | 25.0679 | 25.075 | 25.0679 | 25.0714 | 47600.0 |
| 2012-09-21 07:14:00 | AAPL | Stock | 25.0679 | 25.0714 | 25.0557 | 25.0557 | 24108.0 |
| 2012-09-21 07:17:00 | AAPL | Stock | 25.0714 | 25.0718 | 25.0714 | 25.0714 | 20804.0 |
| 2012-09-21 07:18:00 | AAPL | Stock | 25.075 | 25.0786 | 25.075 | 25.0786 | 8400.0 |
| 2012-09-21 07:20:00 | AAPL | Stock | 25.0686 | 25.0782 | 25.0679 | 25.0782 | 57064.0 |
| 2012-09-21 07:23:00 | AAPL | Stock | 25.0718 | 25.0718 | 25.0714 | 25.0714 | 5600.0 |
| 2012-09-21 07:26:00 | AAPL | Stock | 25.0729 | 25.0893 | 25.0729 | 25.0893 | 46592.0 |
| 2012-09-21 07:27:00 | AAPL | Stock | 25.0868 | 25.0868 | 25.0857 | 25.0857 | 9716.0 |
| 2012-09-21 07:28:00 | AAPL | Stock | 25.0875 | 25.0929 | 25.0875 | 25.0929 | 42000.0 |
| 2012-09-21 07:29:00 | AAPL | Stock | 25.0875 | 25.095 | 25.0875 | 25.095 | 30800.0 |
| 2012-09-21 07:30:00 | AAPL | Stock | 25.0889 | 25.0954 | 25.0889 | 25.0954 | 16800.0 |
| 2012-09-21 07:31:00 | AAPL | Stock | 25.1018 | 25.1071 | 25.1 | 25.1071 | 27496.0 |
| 2012-09-21 07:32:00 | AAPL | Stock | 25.1071 | 25.1179 | 25.1071 | 25.1179 | 33964.0 |
| 2012-09-21 07:33:00 | AAPL | Stock | 25.1157 | 25.1157 | 25.1111 | 25.1143 | 14000.0 |
| 2012-09-21 07:34:00 | AAPL | Stock | 25.1143 | 25.1179 | 25.1125 | 25.1179 | 22400.0 |
| 2012-09-21 07:35:00 | AAPL | Stock | 25.1171 | 25.1321 | 25.1168 | 25.1321 | 144060.0 |
| 2012-09-21 07:36:00 | AAPL | Stock | 25.1354 | 25.1461 | 25.1339 | 25.1429 | 89600.0 |
| 2012-09-21 07:37:00 | AAPL | Stock | 25.1443 | 25.1546 | 25.1443 | 25.1507 | 19600.0 |
| 2012-09-21 07:38:00 | AAPL | Stock | 25.1464 | 25.1464 | 25.1357 | 25.1357 | 80528.0 |
| 2012-09-21 07:39:00 | AAPL | Stock | 25.1357 | 25.1429 | 25.1357 | 25.1429 | 11200.0 |
| 2012-09-21 07:40:00 | AAPL | Stock | 25.1371 | 25.1429 | 25.1357 | 25.1429 | 42896.0 |
> showing 50 of 988,374 rows — these rows as CSV