PREVIEW / stock_1min / 2013-09-20
file: by_date/stock_1min/2013/2013-09-20.parquet size: 14.0 MB rows: 1,020,720 symbols: 2,864
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:03:00 | AAPL | Stock | 16.8264 | 16.8264 | 16.8214 | 16.8214 | 5600.0 |
| 2013-09-20 04:04:00 | AAPL | Stock | 16.8182 | 16.8182 | 16.8182 | 16.8182 | 2800.0 |
| 2013-09-20 04:05:00 | AAPL | Stock | 16.87 | 16.87 | 16.87 | 16.87 | 5600.0 |
| 2013-09-20 04:07:00 | AAPL | Stock | 16.8214 | 16.8568 | 16.8214 | 16.8568 | 5600.0 |
| 2013-09-20 04:08:00 | AAPL | Stock | 16.8568 | 16.8568 | 16.8568 | 16.8568 | 2800.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:23: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:06:00 | AAPL | Stock | 16.8907 | 16.8907 | 16.8907 | 16.8907 | 5600.0 |
| 2013-09-20 06:07:00 | AAPL | Stock | 16.8925 | 16.8925 | 16.8925 | 16.8925 | 2800.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.9268 | 16.9268 | 3080.0 |
| 2013-09-20 06:37:00 | AAPL | Stock | 16.9268 | 16.9268 | 16.9268 | 16.9268 | 2800.0 |
| 2013-09-20 06:38:00 | AAPL | Stock | 16.9246 | 16.9246 | 16.9246 | 16.9246 | 3640.0 |
| 2013-09-20 06:45:00 | AAPL | Stock | 16.9282 | 16.9282 | 16.9282 | 16.9282 | 2800.0 |
| 2013-09-20 06:49:00 | AAPL | Stock | 16.9321 | 16.9321 | 16.9321 | 16.9321 | 2800.0 |
| 2013-09-20 06:51:00 | AAPL | Stock | 16.9375 | 16.9375 | 16.9375 | 16.9375 | 2800.0 |
| 2013-09-20 06:52:00 | AAPL | Stock | 16.9375 | 16.9375 | 16.9375 | 16.9375 | 11200.0 |
| 2013-09-20 06:57:00 | AAPL | Stock | 16.9268 | 16.9268 | 16.9268 | 16.9268 | 8400.0 |
| 2013-09-20 07:00:00 | AAPL | Stock | 16.9225 | 16.9225 | 16.9225 | 16.9225 | 2800.0 |
| 2013-09-20 07:01:00 | AAPL | Stock | 16.9196 | 16.9196 | 16.9186 | 16.9196 | 25200.0 |
| 2013-09-20 07:02:00 | AAPL | Stock | 16.9154 | 16.9286 | 16.9154 | 16.9286 | 9380.0 |
| 2013-09-20 07:03:00 | AAPL | Stock | 16.9161 | 16.9161 | 16.9154 | 16.9154 | 10360.0 |
| 2013-09-20 07:04:00 | AAPL | Stock | 16.9107 | 16.9107 | 16.9107 | 16.9107 | 20244.0 |
| 2013-09-20 07:05:00 | AAPL | Stock | 16.8929 | 16.8929 | 16.8929 | 16.8929 | 13160.0 |
| 2013-09-20 07:09:00 | AAPL | Stock | 16.8929 | 16.8929 | 16.8929 | 16.8929 | 7028.0 |
| 2013-09-20 07:11:00 | AAPL | Stock | 16.8929 | 16.8929 | 16.8893 | 16.8929 | 30520.0 |
| 2013-09-20 07:13:00 | AAPL | Stock | 16.8946 | 16.8982 | 16.8929 | 16.8982 | 34300.0 |
| 2013-09-20 07:16:00 | AAPL | Stock | 16.8996 | 16.9036 | 16.8996 | 16.9036 | 10808.0 |
| 2013-09-20 07:17:00 | AAPL | Stock | 16.9071 | 16.9071 | 16.9071 | 16.9071 | 5600.0 |
| 2013-09-20 07:18:00 | AAPL | Stock | 16.9107 | 16.9211 | 16.9107 | 16.9179 | 11200.0 |
| 2013-09-20 07:19:00 | AAPL | Stock | 16.9107 | 16.9107 | 16.9107 | 16.9107 | 5600.0 |
| 2013-09-20 07:20:00 | AAPL | Stock | 16.9125 | 16.9125 | 16.9125 | 16.9125 | 2800.0 |
| 2013-09-20 07:21:00 | AAPL | Stock | 16.9143 | 16.9143 | 16.9143 | 16.9143 | 7728.0 |
| 2013-09-20 07:24:00 | AAPL | Stock | 16.9157 | 16.9157 | 16.9143 | 16.9143 | 11480.0 |
| 2013-09-20 07:25:00 | AAPL | Stock | 16.9143 | 16.9143 | 16.9143 | 16.9143 | 32760.0 |
| 2013-09-20 07:26:00 | AAPL | Stock | 16.9107 | 16.9107 | 16.9054 | 16.9054 | 15932.0 |
| 2013-09-20 07:27:00 | AAPL | Stock | 16.9025 | 16.9054 | 16.8932 | 16.9 | 82320.0 |
| 2013-09-20 07:28:00 | AAPL | Stock | 16.9018 | 16.9018 | 16.9018 | 16.9018 | 2800.0 |
| 2013-09-20 07:32:00 | AAPL | Stock | 16.9036 | 16.9071 | 16.9036 | 16.9071 | 11200.0 |
| 2013-09-20 07:33:00 | AAPL | Stock | 16.9107 | 16.9107 | 16.9107 | 16.9107 | 8400.0 |
| 2013-09-20 07:34:00 | AAPL | Stock | 16.9157 | 16.9157 | 16.9157 | 16.9157 | 3472.0 |
| 2013-09-20 07:35:00 | AAPL | Stock | 16.9154 | 16.9161 | 16.9154 | 16.9161 | 10024.0 |
| 2013-09-20 07:37:00 | AAPL | Stock | 16.9243 | 16.9243 | 16.9243 | 16.9243 | 2800.0 |
| 2013-09-20 07:38:00 | AAPL | Stock | 16.9243 | 16.9243 | 16.9243 | 16.9243 | 4900.0 |
| 2013-09-20 07:39:00 | AAPL | Stock | 16.9196 | 16.9279 | 16.9171 | 16.9171 | 62328.0 |
| 2013-09-20 07:40:00 | AAPL | Stock | 16.9289 | 16.9289 | 16.9289 | 16.9289 | 5600.0 |
| 2013-09-20 07:41:00 | AAPL | Stock | 16.9289 | 16.9289 | 16.9289 | 16.9289 | 2800.0 |
> showing 50 of 1,020,720 rows — these rows as CSV