PREVIEW / stock_5min / 2012-10-11
file: by_date/stock_5min/2012/2012-10-11.parquet size: 4.6 MB rows: 311,706 symbols: 3,465
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-10-11 04:00:00 | AAPL | Stock | 22.9339 | 22.9339 | 22.9286 | 22.9286 | 20916.0 |
| 2012-10-11 04:10:00 | AAPL | Stock | 23.0 | 23.0 | 23.0 | 23.0 | 8400.0 |
| 2012-10-11 04:15:00 | AAPL | Stock | 23.0 | 23.0 | 23.0 | 23.0 | 11200.0 |
| 2012-10-11 04:20:00 | AAPL | Stock | 23.0 | 23.0 | 23.0 | 23.0 | 10976.0 |
| 2012-10-11 04:30:00 | AAPL | Stock | 23.0 | 23.0 | 22.9957 | 22.9957 | 5600.0 |
| 2012-10-11 05:00:00 | AAPL | Stock | 23.0139 | 23.0139 | 23.0139 | 23.0139 | 2856.0 |
| 2012-10-11 05:35:00 | AAPL | Stock | 23.0179 | 23.0179 | 23.0036 | 23.0036 | 28840.0 |
| 2012-10-11 05:40:00 | AAPL | Stock | 23.0036 | 23.0036 | 23.0036 | 23.0036 | 5600.0 |
| 2012-10-11 05:45:00 | AAPL | Stock | 23.0179 | 23.0179 | 23.0179 | 23.0179 | 5600.0 |
| 2012-10-11 05:50:00 | AAPL | Stock | 23.0179 | 23.0179 | 23.0179 | 23.0179 | 2800.0 |
| 2012-10-11 05:55:00 | AAPL | Stock | 23.0179 | 23.0179 | 23.0179 | 23.0179 | 2968.0 |
| 2012-10-11 06:35:00 | AAPL | Stock | 23.0357 | 23.0357 | 23.0357 | 23.0357 | 5600.0 |
| 2012-10-11 06:50:00 | AAPL | Stock | 23.0357 | 23.0357 | 23.0354 | 23.0357 | 9800.0 |
| 2012-10-11 07:00:00 | AAPL | Stock | 23.0179 | 23.0571 | 23.0179 | 23.0446 | 102732.0 |
| 2012-10-11 07:05:00 | AAPL | Stock | 23.0446 | 23.0475 | 23.0436 | 23.0436 | 16800.0 |
| 2012-10-11 07:10:00 | AAPL | Stock | 23.0375 | 23.0375 | 23.0068 | 23.0179 | 67424.0 |
| 2012-10-11 07:15:00 | AAPL | Stock | 23.0232 | 23.0354 | 23.0054 | 23.0054 | 56000.0 |
| 2012-10-11 07:20:00 | AAPL | Stock | 23.0089 | 23.015 | 22.9896 | 23.0036 | 74788.0 |
| 2012-10-11 07:25:00 | AAPL | Stock | 23.01 | 23.0268 | 23.01 | 23.0246 | 61600.0 |
| 2012-10-11 07:30:00 | AAPL | Stock | 23.0179 | 23.0264 | 23.0111 | 23.0111 | 37744.0 |
| 2012-10-11 07:35:00 | AAPL | Stock | 23.0118 | 23.0168 | 22.9979 | 23.0 | 75208.0 |
| 2012-10-11 07:40:00 | AAPL | Stock | 23.0032 | 23.0107 | 23.0032 | 23.0107 | 137984.0 |
| 2012-10-11 07:45:00 | AAPL | Stock | 23.0143 | 23.0229 | 23.0121 | 23.0121 | 49364.0 |
| 2012-10-11 07:50:00 | AAPL | Stock | 23.0121 | 23.0243 | 23.0121 | 23.0243 | 98000.0 |
| 2012-10-11 07:55:00 | AAPL | Stock | 23.0271 | 23.0325 | 23.0257 | 23.0257 | 19600.0 |
| 2012-10-11 08:00:00 | AAPL | Stock | 23.0161 | 23.0243 | 22.9821 | 22.9821 | 350336.0 |
| 2012-10-11 08:05:00 | AAPL | Stock | 22.9911 | 23.0 | 22.9821 | 23.0 | 95900.0 |
| 2012-10-11 08:10:00 | AAPL | Stock | 23.0036 | 23.0036 | 22.9964 | 23.0036 | 177800.0 |
| 2012-10-11 08:15:00 | AAPL | Stock | 23.0071 | 23.0204 | 23.0071 | 23.0204 | 107800.0 |
| 2012-10-11 08:20:00 | AAPL | Stock | 23.0214 | 23.0214 | 23.0179 | 23.0207 | 11200.0 |
| 2012-10-11 08:25:00 | AAPL | Stock | 23.0214 | 23.0246 | 23.0079 | 23.0079 | 173264.0 |
| 2012-10-11 08:30:00 | AAPL | Stock | 23.0268 | 23.0436 | 23.0189 | 23.025 | 408128.0 |
| 2012-10-11 08:35:00 | AAPL | Stock | 23.0257 | 23.0643 | 23.0257 | 23.0607 | 523376.0 |
| 2012-10-11 08:40:00 | AAPL | Stock | 23.0614 | 23.0643 | 23.0464 | 23.0607 | 254884.0 |
| 2012-10-11 08:45:00 | AAPL | Stock | 23.0554 | 23.0714 | 23.0514 | 23.0671 | 310156.0 |
| 2012-10-11 08:50:00 | AAPL | Stock | 23.0671 | 23.0714 | 23.0464 | 23.0664 | 171780.0 |
| 2012-10-11 08:55:00 | AAPL | Stock | 23.0629 | 23.0661 | 23.0554 | 23.0593 | 122640.0 |
| 2012-10-11 09:00:00 | AAPL | Stock | 23.0575 | 23.0686 | 23.0529 | 23.0686 | 251160.0 |
| 2012-10-11 09:05:00 | AAPL | Stock | 23.0661 | 23.0675 | 23.0586 | 23.0661 | 257544.0 |
| 2012-10-11 09:10:00 | AAPL | Stock | 23.065 | 23.0829 | 23.0618 | 23.0786 | 247828.0 |
| 2012-10-11 09:15:00 | AAPL | Stock | 23.0804 | 23.0811 | 23.0732 | 23.0771 | 236124.0 |
| 2012-10-11 09:20:00 | AAPL | Stock | 23.0796 | 23.085 | 23.0746 | 23.0807 | 375732.0 |
| 2012-10-11 09:25:00 | AAPL | Stock | 23.085 | 23.1036 | 23.0754 | 23.0961 | 901768.0 |
| 2012-10-11 09:30:00 | AAPL | Stock | 23.095 | 23.1143 | 23.0125 | 23.0661 | 17211936.0 |
| 2012-10-11 09:35:00 | AAPL | Stock | 23.0711 | 23.0961 | 23.0357 | 23.0504 | 10076892.0 |
| 2012-10-11 09:40:00 | AAPL | Stock | 23.0514 | 23.0525 | 22.9718 | 22.9718 | 9683184.0 |
| 2012-10-11 09:45:00 | AAPL | Stock | 22.9714 | 23.0057 | 22.9554 | 23.0057 | 9468340.0 |
| 2012-10-11 09:50:00 | AAPL | Stock | 23.0068 | 23.0157 | 22.9379 | 22.9643 | 8012592.0 |
| 2012-10-11 09:55:00 | AAPL | Stock | 22.9682 | 22.991 | 22.9289 | 22.9664 | 6769616.0 |
| 2012-10-11 10:00:00 | AAPL | Stock | 22.9654 | 23.0096 | 22.9489 | 22.9621 | 6650140.0 |
> showing 50 of 311,706 rows — these rows as CSV