PREVIEW / stock_1min / 2012-11-28
file: by_date/stock_1min/2012/2012-11-28.parquet size: 12.7 MB rows: 946,612 symbols: 2,812
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-11-28 04:22:00 | AAPL | Stock | 20.8218 | 20.8218 | 20.8218 | 20.8218 | 2800.0 |
| 2012-11-28 04:26:00 | AAPL | Stock | 20.8054 | 20.8054 | 20.8054 | 20.8054 | 2800.0 |
| 2012-11-28 06:16:00 | AAPL | Stock | 20.7946 | 20.7946 | 20.7946 | 20.7946 | 5600.0 |
| 2012-11-28 06:30:00 | AAPL | Stock | 20.7861 | 20.7861 | 20.7861 | 20.7861 | 11200.0 |
| 2012-11-28 06:31:00 | AAPL | Stock | 20.7861 | 20.7861 | 20.7861 | 20.7861 | 5600.0 |
| 2012-11-28 06:32:00 | AAPL | Stock | 20.7861 | 20.7861 | 20.7861 | 20.7861 | 11200.0 |
| 2012-11-28 06:34:00 | AAPL | Stock | 20.7861 | 20.7861 | 20.7857 | 20.7857 | 11508.0 |
| 2012-11-28 06:58:00 | AAPL | Stock | 20.7571 | 20.7571 | 20.7571 | 20.7571 | 2800.0 |
| 2012-11-28 07:00:00 | AAPL | Stock | 20.7529 | 20.7529 | 20.7529 | 20.7529 | 8400.0 |
| 2012-11-28 07:01:00 | AAPL | Stock | 20.7886 | 20.7886 | 20.7886 | 20.7886 | 2800.0 |
| 2012-11-28 07:03:00 | AAPL | Stock | 20.7836 | 20.7836 | 20.7836 | 20.7836 | 2800.0 |
| 2012-11-28 07:13:00 | AAPL | Stock | 20.7768 | 20.7779 | 20.7768 | 20.7779 | 5600.0 |
| 2012-11-28 07:14:00 | AAPL | Stock | 20.77 | 20.7704 | 20.7536 | 20.7536 | 30520.0 |
| 2012-11-28 07:15:00 | AAPL | Stock | 20.7764 | 20.7768 | 20.7764 | 20.7768 | 19600.0 |
| 2012-11-28 07:18:00 | AAPL | Stock | 20.7746 | 20.7857 | 20.7746 | 20.7857 | 100072.0 |
| 2012-11-28 07:20:00 | AAPL | Stock | 20.8054 | 20.8054 | 20.8054 | 20.8054 | 4760.0 |
| 2012-11-28 07:30:00 | AAPL | Stock | 20.7857 | 20.7857 | 20.7857 | 20.7857 | 2800.0 |
| 2012-11-28 07:34:00 | AAPL | Stock | 20.7857 | 20.7857 | 20.7857 | 20.7857 | 2800.0 |
| 2012-11-28 07:35:00 | AAPL | Stock | 20.7857 | 20.7857 | 20.7857 | 20.7857 | 8120.0 |
| 2012-11-28 07:37:00 | AAPL | Stock | 20.7786 | 20.7786 | 20.7786 | 20.7786 | 2800.0 |
| 2012-11-28 07:39:00 | AAPL | Stock | 20.7768 | 20.7768 | 20.7696 | 20.7696 | 22400.0 |
| 2012-11-28 07:40:00 | AAPL | Stock | 20.7643 | 20.7714 | 20.7643 | 20.7714 | 8400.0 |
| 2012-11-28 07:41:00 | AAPL | Stock | 20.7657 | 20.7657 | 20.7529 | 20.7579 | 33600.0 |
| 2012-11-28 07:42:00 | AAPL | Stock | 20.7579 | 20.7593 | 20.7579 | 20.7589 | 11200.0 |
| 2012-11-28 07:45:00 | AAPL | Stock | 20.7607 | 20.7607 | 20.7607 | 20.7607 | 5600.0 |
| 2012-11-28 07:46:00 | AAPL | Stock | 20.7661 | 20.7661 | 20.7661 | 20.7661 | 25200.0 |
| 2012-11-28 07:47:00 | AAPL | Stock | 20.7589 | 20.7589 | 20.7589 | 20.7589 | 2800.0 |
| 2012-11-28 07:48:00 | AAPL | Stock | 20.7593 | 20.7593 | 20.7396 | 20.7396 | 81200.0 |
| 2012-11-28 07:50:00 | AAPL | Stock | 20.7411 | 20.7411 | 20.7411 | 20.7411 | 20300.0 |
| 2012-11-28 07:57:00 | AAPL | Stock | 20.75 | 20.75 | 20.7464 | 20.7464 | 5600.0 |
| 2012-11-28 08:00:00 | AAPL | Stock | 20.7425 | 20.8036 | 20.7368 | 20.7411 | 88424.0 |
| 2012-11-28 08:01:00 | AAPL | Stock | 20.75 | 20.7589 | 20.7475 | 20.7582 | 57316.0 |
| 2012-11-28 08:02:00 | AAPL | Stock | 20.7589 | 20.7643 | 20.7536 | 20.7536 | 58100.0 |
| 2012-11-28 08:03:00 | AAPL | Stock | 20.7539 | 20.7539 | 20.7429 | 20.7429 | 67760.0 |
| 2012-11-28 08:04:00 | AAPL | Stock | 20.7375 | 20.7411 | 20.7289 | 20.7293 | 23520.0 |
| 2012-11-28 08:05:00 | AAPL | Stock | 20.7261 | 20.7329 | 20.7207 | 20.7207 | 149968.0 |
| 2012-11-28 08:06:00 | AAPL | Stock | 20.7236 | 20.7464 | 20.7232 | 20.7264 | 95256.0 |
| 2012-11-28 08:07:00 | AAPL | Stock | 20.7321 | 20.7321 | 20.7221 | 20.7286 | 161476.0 |
| 2012-11-28 08:08:00 | AAPL | Stock | 20.725 | 20.7411 | 20.7214 | 20.7357 | 77868.0 |
| 2012-11-28 08:09:00 | AAPL | Stock | 20.7321 | 20.7411 | 20.7321 | 20.7411 | 55188.0 |
| 2012-11-28 08:10:00 | AAPL | Stock | 20.7404 | 20.7404 | 20.7321 | 20.7339 | 33236.0 |
| 2012-11-28 08:11:00 | AAPL | Stock | 20.7375 | 20.7375 | 20.7375 | 20.7375 | 2800.0 |
| 2012-11-28 08:12:00 | AAPL | Stock | 20.7311 | 20.7314 | 20.7268 | 20.7314 | 25200.0 |
| 2012-11-28 08:13:00 | AAPL | Stock | 20.7232 | 20.7246 | 20.7186 | 20.7243 | 23800.0 |
| 2012-11-28 08:14:00 | AAPL | Stock | 20.7239 | 20.7311 | 20.7239 | 20.7311 | 13748.0 |
| 2012-11-28 08:15:00 | AAPL | Stock | 20.7257 | 20.7318 | 20.7186 | 20.7186 | 93996.0 |
| 2012-11-28 08:16:00 | AAPL | Stock | 20.7304 | 20.7304 | 20.725 | 20.725 | 5600.0 |
| 2012-11-28 08:17:00 | AAPL | Stock | 20.725 | 20.7318 | 20.7196 | 20.7318 | 27720.0 |
| 2012-11-28 08:18:00 | AAPL | Stock | 20.7196 | 20.7218 | 20.7 | 20.7 | 184996.0 |
| 2012-11-28 08:19:00 | AAPL | Stock | 20.6964 | 20.6964 | 20.6711 | 20.6961 | 102704.0 |
> showing 50 of 946,612 rows — these rows as CSV