PREVIEW / stock_1min / 2013-04-26
file: by_date/stock_1min/2013/2013-04-26.parquet size: 12.9 MB rows: 952,780 symbols: 2,799
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-04-26 04:00:00 | AAPL | Stock | 14.5996 | 14.5996 | 14.5996 | 14.5996 | 11200.0 |
| 2013-04-26 04:43:00 | AAPL | Stock | 14.57 | 14.57 | 14.57 | 14.57 | 5600.0 |
| 2013-04-26 06:04:00 | AAPL | Stock | 14.5386 | 14.5386 | 14.5386 | 14.5386 | 5600.0 |
| 2013-04-26 06:50:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 25200.0 |
| 2013-04-26 07:02:00 | AAPL | Stock | 14.5296 | 14.5296 | 14.5296 | 14.5296 | 2800.0 |
| 2013-04-26 07:03:00 | AAPL | Stock | 14.5336 | 14.5336 | 14.5336 | 14.5336 | 2800.0 |
| 2013-04-26 07:05:00 | AAPL | Stock | 14.5429 | 14.5446 | 14.5429 | 14.5446 | 35364.0 |
| 2013-04-26 07:07:00 | AAPL | Stock | 14.5446 | 14.5446 | 14.5446 | 14.5446 | 8400.0 |
| 2013-04-26 07:12:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5536 | 14.5536 | 11088.0 |
| 2013-04-26 07:13:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5429 | 14.5429 | 36092.0 |
| 2013-04-26 07:14:00 | AAPL | Stock | 14.5414 | 14.5414 | 14.5411 | 14.5414 | 28000.0 |
| 2013-04-26 07:15:00 | AAPL | Stock | 14.5411 | 14.5411 | 14.5357 | 14.5357 | 36400.0 |
| 2013-04-26 07:18:00 | AAPL | Stock | 14.5432 | 14.5432 | 14.5432 | 14.5432 | 4200.0 |
| 2013-04-26 07:23:00 | AAPL | Stock | 14.5443 | 14.5443 | 14.5443 | 14.5443 | 2800.0 |
| 2013-04-26 07:25:00 | AAPL | Stock | 14.5529 | 14.5536 | 14.5529 | 14.5536 | 30800.0 |
| 2013-04-26 07:26:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5536 | 14.5536 | 2800.0 |
| 2013-04-26 07:45:00 | AAPL | Stock | 14.5539 | 14.5539 | 14.5539 | 14.5539 | 14000.0 |
| 2013-04-26 07:46:00 | AAPL | Stock | 14.5586 | 14.5714 | 14.5586 | 14.5714 | 30800.0 |
| 2013-04-26 07:47:00 | AAPL | Stock | 14.5571 | 14.5571 | 14.5571 | 14.5571 | 5600.0 |
| 2013-04-26 07:59:00 | AAPL | Stock | 14.5554 | 14.5554 | 14.5496 | 14.5504 | 30800.0 |
| 2013-04-26 08:00:00 | AAPL | Stock | 14.5621 | 14.5693 | 14.5411 | 14.5561 | 60368.0 |
| 2013-04-26 08:01:00 | AAPL | Stock | 14.5518 | 14.5518 | 14.5518 | 14.5518 | 11760.0 |
| 2013-04-26 08:03:00 | AAPL | Stock | 14.5446 | 14.5446 | 14.5439 | 14.5439 | 8120.0 |
| 2013-04-26 08:04:00 | AAPL | Stock | 14.5439 | 14.5475 | 14.5439 | 14.5475 | 10920.0 |
| 2013-04-26 08:05:00 | AAPL | Stock | 14.585 | 14.585 | 14.5432 | 14.5432 | 938000.0 |
| 2013-04-26 08:06:00 | AAPL | Stock | 14.5514 | 14.5521 | 14.545 | 14.545 | 8400.0 |
| 2013-04-26 08:07:00 | AAPL | Stock | 14.5439 | 14.5439 | 14.5218 | 14.5218 | 123060.0 |
| 2013-04-26 08:08:00 | AAPL | Stock | 14.5321 | 14.5321 | 14.5314 | 14.5314 | 8400.0 |
| 2013-04-26 08:09:00 | AAPL | Stock | 14.5318 | 14.5318 | 14.5318 | 14.5318 | 2800.0 |
| 2013-04-26 08:10:00 | AAPL | Stock | 14.5329 | 14.5364 | 14.5286 | 14.5364 | 51548.0 |
| 2013-04-26 08:11:00 | AAPL | Stock | 14.5482 | 14.5482 | 14.5482 | 14.5482 | 15680.0 |
| 2013-04-26 08:12:00 | AAPL | Stock | 14.5429 | 14.5429 | 14.5429 | 14.5429 | 9800.0 |
| 2013-04-26 08:13:00 | AAPL | Stock | 14.5536 | 14.5604 | 14.5514 | 14.5514 | 25200.0 |
| 2013-04-26 08:15:00 | AAPL | Stock | 14.5632 | 14.5632 | 14.5632 | 14.5632 | 2800.0 |
| 2013-04-26 08:17:00 | AAPL | Stock | 14.5568 | 14.5568 | 14.5568 | 14.5568 | 2800.0 |
| 2013-04-26 08:19:00 | AAPL | Stock | 14.5668 | 14.5668 | 14.5668 | 14.5668 | 2800.0 |
| 2013-04-26 08:20:00 | AAPL | Stock | 14.5661 | 14.5661 | 14.5625 | 14.5625 | 14000.0 |
| 2013-04-26 08:21:00 | AAPL | Stock | 14.5643 | 14.5714 | 14.5625 | 14.5714 | 59640.0 |
| 2013-04-26 08:22:00 | AAPL | Stock | 14.5725 | 14.5725 | 14.5725 | 14.5725 | 2800.0 |
| 2013-04-26 08:23:00 | AAPL | Stock | 14.5625 | 14.5661 | 14.5625 | 14.5661 | 21000.0 |
| 2013-04-26 08:25:00 | AAPL | Stock | 14.5661 | 14.5661 | 14.5661 | 14.5661 | 2800.0 |
| 2013-04-26 08:27:00 | AAPL | Stock | 14.5693 | 14.5693 | 14.5596 | 14.5596 | 19600.0 |
| 2013-04-26 08:28:00 | AAPL | Stock | 14.5604 | 14.5643 | 14.5604 | 14.5643 | 9296.0 |
| 2013-04-26 08:29:00 | AAPL | Stock | 14.5693 | 14.5693 | 14.5643 | 14.5693 | 14700.0 |
| 2013-04-26 08:30:00 | AAPL | Stock | 14.5604 | 14.5643 | 14.5368 | 14.5461 | 140280.0 |
| 2013-04-26 08:31:00 | AAPL | Stock | 14.5536 | 14.5546 | 14.5536 | 14.5536 | 42336.0 |
| 2013-04-26 08:32:00 | AAPL | Stock | 14.5571 | 14.5643 | 14.5571 | 14.5571 | 54180.0 |
| 2013-04-26 08:33:00 | AAPL | Stock | 14.5621 | 14.5621 | 14.5607 | 14.5607 | 10892.0 |
| 2013-04-26 08:34:00 | AAPL | Stock | 14.5607 | 14.5607 | 14.5554 | 14.5607 | 95200.0 |
| 2013-04-26 08:35:00 | AAPL | Stock | 14.5607 | 14.5607 | 14.5607 | 14.5607 | 11200.0 |
> showing 50 of 952,780 rows — these rows as CSV