PREVIEW / stock_1min / 2013-04-11
file: by_date/stock_1min/2013/2013-04-11.parquet size: 13.3 MB rows: 968,581 symbols: 2,814
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-11 04:01:00 | AAPL | Stock | 15.5421 | 15.5421 | 15.5357 | 15.5357 | 7000.0 |
| 2013-04-11 04:02:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 4200.0 |
| 2013-04-11 04:34:00 | AAPL | Stock | 15.5268 | 15.5268 | 15.5268 | 15.5268 | 2800.0 |
| 2013-04-11 04:52:00 | AAPL | Stock | 15.5675 | 15.5675 | 15.5675 | 15.5675 | 2800.0 |
| 2013-04-11 04:54:00 | AAPL | Stock | 15.5693 | 15.5714 | 15.5693 | 15.5714 | 8400.0 |
| 2013-04-11 05:33:00 | AAPL | Stock | 15.5504 | 15.5504 | 15.5489 | 15.5489 | 15484.0 |
| 2013-04-11 05:53:00 | AAPL | Stock | 15.5707 | 15.5707 | 15.5707 | 15.5707 | 11592.0 |
| 2013-04-11 06:20:00 | AAPL | Stock | 15.5811 | 15.5811 | 15.5811 | 15.5811 | 2800.0 |
| 2013-04-11 06:37:00 | AAPL | Stock | 15.5736 | 15.5736 | 15.5736 | 15.5736 | 14280.0 |
| 2013-04-11 06:38:00 | AAPL | Stock | 15.5736 | 15.5736 | 15.5736 | 15.5736 | 6300.0 |
| 2013-04-11 06:39:00 | AAPL | Stock | 15.5743 | 15.5743 | 15.5736 | 15.5736 | 10220.0 |
| 2013-04-11 06:52:00 | AAPL | Stock | 15.5604 | 15.5604 | 15.5554 | 15.5554 | 23240.0 |
| 2013-04-11 06:53:00 | AAPL | Stock | 15.5486 | 15.5486 | 15.5486 | 15.5486 | 5600.0 |
| 2013-04-11 07:13:00 | AAPL | Stock | 15.5414 | 15.5414 | 15.5411 | 15.5414 | 17192.0 |
| 2013-04-11 07:14:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 2968.0 |
| 2013-04-11 07:15:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 16072.0 |
| 2013-04-11 07:17:00 | AAPL | Stock | 15.5361 | 15.5361 | 15.5336 | 15.5336 | 14000.0 |
| 2013-04-11 07:20:00 | AAPL | Stock | 15.5029 | 15.5036 | 15.4996 | 15.5036 | 31892.0 |
| 2013-04-11 07:21:00 | AAPL | Stock | 15.4968 | 15.4968 | 15.4879 | 15.4879 | 11200.0 |
| 2013-04-11 07:22:00 | AAPL | Stock | 15.4929 | 15.4929 | 15.4929 | 15.4929 | 5600.0 |
| 2013-04-11 07:23:00 | AAPL | Stock | 15.4929 | 15.4964 | 15.4929 | 15.4964 | 8400.0 |
| 2013-04-11 07:25:00 | AAPL | Stock | 15.4911 | 15.4964 | 15.4911 | 15.4964 | 5600.0 |
| 2013-04-11 07:26:00 | AAPL | Stock | 15.4986 | 15.4986 | 15.4986 | 15.4986 | 4200.0 |
| 2013-04-11 07:27:00 | AAPL | Stock | 15.4936 | 15.4936 | 15.4861 | 15.4861 | 78400.0 |
| 2013-04-11 07:29:00 | AAPL | Stock | 15.4911 | 15.4911 | 15.4911 | 15.4911 | 5600.0 |
| 2013-04-11 07:30:00 | AAPL | Stock | 15.4911 | 15.4911 | 15.4911 | 15.4911 | 25200.0 |
| 2013-04-11 07:32:00 | AAPL | Stock | 15.4914 | 15.4914 | 15.4914 | 15.4914 | 6720.0 |
| 2013-04-11 07:33:00 | AAPL | Stock | 15.4911 | 15.4911 | 15.4893 | 15.4893 | 5600.0 |
| 2013-04-11 07:34:00 | AAPL | Stock | 15.4875 | 15.4875 | 15.4875 | 15.4875 | 3108.0 |
| 2013-04-11 07:36:00 | AAPL | Stock | 15.4821 | 15.4821 | 15.4814 | 15.4821 | 22400.0 |
| 2013-04-11 07:37:00 | AAPL | Stock | 15.4754 | 15.4754 | 15.4679 | 15.4714 | 33348.0 |
| 2013-04-11 07:38:00 | AAPL | Stock | 15.4561 | 15.4561 | 15.4464 | 15.4468 | 30800.0 |
| 2013-04-11 07:39:00 | AAPL | Stock | 15.4639 | 15.4639 | 15.4639 | 15.4639 | 5600.0 |
| 2013-04-11 07:40:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4411 | 15.4411 | 74228.0 |
| 2013-04-11 07:41:00 | AAPL | Stock | 15.4468 | 15.4468 | 15.4457 | 15.4457 | 28000.0 |
| 2013-04-11 07:42:00 | AAPL | Stock | 15.4411 | 15.4414 | 15.4179 | 15.4179 | 51912.0 |
| 2013-04-11 07:43:00 | AAPL | Stock | 15.4182 | 15.4286 | 15.4182 | 15.4286 | 64960.0 |
| 2013-04-11 07:44:00 | AAPL | Stock | 15.4296 | 15.4296 | 15.4296 | 15.4296 | 2800.0 |
| 2013-04-11 07:45:00 | AAPL | Stock | 15.4564 | 15.4564 | 15.4564 | 15.4564 | 4452.0 |
| 2013-04-11 07:46:00 | AAPL | Stock | 15.4329 | 15.4329 | 15.4329 | 15.4329 | 2800.0 |
| 2013-04-11 07:47:00 | AAPL | Stock | 15.4543 | 15.4554 | 15.4543 | 15.4554 | 12880.0 |
| 2013-04-11 07:48:00 | AAPL | Stock | 15.45 | 15.45 | 15.4482 | 15.4482 | 16800.0 |
| 2013-04-11 07:49:00 | AAPL | Stock | 15.4479 | 15.4479 | 15.4414 | 15.4414 | 5600.0 |
| 2013-04-11 07:50:00 | AAPL | Stock | 15.4479 | 15.4643 | 15.4479 | 15.4571 | 148848.0 |
| 2013-04-11 07:51:00 | AAPL | Stock | 15.4536 | 15.4571 | 15.4536 | 15.4571 | 9688.0 |
| 2013-04-11 07:52:00 | AAPL | Stock | 15.4571 | 15.4643 | 15.4571 | 15.4643 | 26124.0 |
| 2013-04-11 07:53:00 | AAPL | Stock | 15.4643 | 15.4725 | 15.4643 | 15.4714 | 20608.0 |
| 2013-04-11 07:54:00 | AAPL | Stock | 15.465 | 15.4661 | 15.4539 | 15.4539 | 33292.0 |
| 2013-04-11 07:55:00 | AAPL | Stock | 15.4579 | 15.4579 | 15.4536 | 15.4575 | 20020.0 |
| 2013-04-11 07:56:00 | AAPL | Stock | 15.4539 | 15.4575 | 15.4536 | 15.4575 | 8400.0 |
> showing 50 of 968,581 rows — these rows as CSV