PREVIEW / stock_1min / 2013-09-19
file: by_date/stock_1min/2013/2013-09-19.parquet size: 13.7 MB rows: 995,451 symbols: 2,858
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-19 04:00:00 | AAPL | Stock | 16.7543 | 16.7543 | 16.7543 | 16.7543 | 2800.0 |
| 2013-09-19 04:07:00 | AAPL | Stock | 16.6964 | 16.7136 | 16.6964 | 16.7136 | 25200.0 |
| 2013-09-19 04:09:00 | AAPL | Stock | 16.6889 | 16.6889 | 16.6889 | 16.6889 | 2800.0 |
| 2013-09-19 04:13:00 | AAPL | Stock | 16.6707 | 16.6929 | 16.6625 | 16.6625 | 29792.0 |
| 2013-09-19 04:27:00 | AAPL | Stock | 16.705 | 16.7104 | 16.705 | 16.7104 | 12068.0 |
| 2013-09-19 04:30:00 | AAPL | Stock | 16.6946 | 16.6946 | 16.6946 | 16.6946 | 14000.0 |
| 2013-09-19 04:31:00 | AAPL | Stock | 16.6946 | 16.6946 | 16.6946 | 16.6946 | 5600.0 |
| 2013-09-19 04:32:00 | AAPL | Stock | 16.6789 | 16.6789 | 16.6789 | 16.6789 | 8400.0 |
| 2013-09-19 04:33:00 | AAPL | Stock | 16.6643 | 16.6643 | 16.6639 | 16.6639 | 12600.0 |
| 2013-09-19 04:35:00 | AAPL | Stock | 16.6975 | 16.7054 | 16.6975 | 16.7054 | 54992.0 |
| 2013-09-19 04:44:00 | AAPL | Stock | 16.7014 | 16.7054 | 16.7014 | 16.7014 | 33600.0 |
| 2013-09-19 04:59:00 | AAPL | Stock | 16.6786 | 16.6886 | 16.6786 | 16.6793 | 8736.0 |
| 2013-09-19 05:02:00 | AAPL | Stock | 16.6964 | 16.6964 | 16.6964 | 16.6964 | 2800.0 |
| 2013-09-19 05:04:00 | AAPL | Stock | 16.6971 | 16.6971 | 16.6971 | 16.6971 | 2800.0 |
| 2013-09-19 05:10:00 | AAPL | Stock | 16.7129 | 16.7143 | 16.7129 | 16.7143 | 42000.0 |
| 2013-09-19 05:52:00 | AAPL | Stock | 16.7286 | 16.7286 | 16.7286 | 16.7286 | 2800.0 |
| 2013-09-19 06:01:00 | AAPL | Stock | 16.7286 | 16.7286 | 16.7286 | 16.7286 | 2800.0 |
| 2013-09-19 06:02:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 2800.0 |
| 2013-09-19 06:19:00 | AAPL | Stock | 16.6804 | 16.6804 | 16.6804 | 16.6804 | 2800.0 |
| 2013-09-19 06:30:00 | AAPL | Stock | 16.6961 | 16.6964 | 16.6961 | 16.6964 | 44576.0 |
| 2013-09-19 06:35:00 | AAPL | Stock | 16.7 | 16.7 | 16.7 | 16.7 | 2800.0 |
| 2013-09-19 06:36:00 | AAPL | Stock | 16.695 | 16.6957 | 16.695 | 16.6957 | 8400.0 |
| 2013-09-19 06:54:00 | AAPL | Stock | 16.7054 | 16.7054 | 16.7054 | 16.7054 | 27944.0 |
| 2013-09-19 06:58:00 | AAPL | Stock | 16.7071 | 16.7071 | 16.7071 | 16.7071 | 8400.0 |
| 2013-09-19 06:59:00 | AAPL | Stock | 16.7071 | 16.7071 | 16.7071 | 16.7071 | 5600.0 |
| 2013-09-19 07:00:00 | AAPL | Stock | 16.7107 | 16.7107 | 16.7107 | 16.7107 | 36400.0 |
| 2013-09-19 07:01:00 | AAPL | Stock | 16.7075 | 16.71 | 16.7054 | 16.7096 | 33516.0 |
| 2013-09-19 07:02:00 | AAPL | Stock | 16.7071 | 16.7139 | 16.7071 | 16.7139 | 11760.0 |
| 2013-09-19 07:03:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 11200.0 |
| 2013-09-19 07:05:00 | AAPL | Stock | 16.7289 | 16.7318 | 16.7289 | 16.7318 | 14000.0 |
| 2013-09-19 07:06:00 | AAPL | Stock | 16.7361 | 16.75 | 16.7357 | 16.75 | 33600.0 |
| 2013-09-19 07:07:00 | AAPL | Stock | 16.7489 | 16.7489 | 16.7489 | 16.7489 | 3500.0 |
| 2013-09-19 07:08:00 | AAPL | Stock | 16.75 | 16.75 | 16.75 | 16.75 | 2800.0 |
| 2013-09-19 07:10:00 | AAPL | Stock | 16.7489 | 16.75 | 16.7489 | 16.75 | 33600.0 |
| 2013-09-19 07:11:00 | AAPL | Stock | 16.7504 | 16.7504 | 16.75 | 16.75 | 16800.0 |
| 2013-09-19 07:12:00 | AAPL | Stock | 16.75 | 16.7529 | 16.75 | 16.7529 | 22400.0 |
| 2013-09-19 07:18:00 | AAPL | Stock | 16.7489 | 16.7489 | 16.7489 | 16.7489 | 2800.0 |
| 2013-09-19 07:19:00 | AAPL | Stock | 16.7479 | 16.7479 | 16.7479 | 16.7479 | 2800.0 |
| 2013-09-19 07:21:00 | AAPL | Stock | 16.7475 | 16.7475 | 16.7464 | 16.7464 | 38444.0 |
| 2013-09-19 07:22:00 | AAPL | Stock | 16.7425 | 16.7425 | 16.735 | 16.735 | 21000.0 |
| 2013-09-19 07:23:00 | AAPL | Stock | 16.735 | 16.7354 | 16.7346 | 16.7346 | 8400.0 |
| 2013-09-19 07:25:00 | AAPL | Stock | 16.7393 | 16.7396 | 16.7393 | 16.7396 | 22400.0 |
| 2013-09-19 07:26:00 | AAPL | Stock | 16.7461 | 16.7514 | 16.7461 | 16.7514 | 36400.0 |
| 2013-09-19 07:27:00 | AAPL | Stock | 16.7514 | 16.7514 | 16.7429 | 16.75 | 88872.0 |
| 2013-09-19 07:28:00 | AAPL | Stock | 16.7464 | 16.75 | 16.7464 | 16.75 | 22064.0 |
| 2013-09-19 07:29:00 | AAPL | Stock | 16.7496 | 16.7621 | 16.7496 | 16.7621 | 22568.0 |
| 2013-09-19 07:30:00 | AAPL | Stock | 16.7536 | 16.7536 | 16.7486 | 16.7486 | 5600.0 |
| 2013-09-19 07:31:00 | AAPL | Stock | 16.7536 | 16.7536 | 16.7536 | 16.7536 | 5600.0 |
| 2013-09-19 07:32:00 | AAPL | Stock | 16.75 | 16.7518 | 16.75 | 16.7518 | 11200.0 |
| 2013-09-19 07:37:00 | AAPL | Stock | 16.7468 | 16.7468 | 16.7464 | 16.7464 | 19600.0 |
> showing 50 of 995,451 rows — these rows as CSV