PREVIEW / stock_5min / 2014-04-11
file: by_date/stock_5min/2014/2014-04-11.parquet size: 5.5 MB rows: 362,434 symbols: 3,546
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-11 04:00:00 | AAPL | Stock | 18.6729 | 18.6729 | 18.6729 | 18.6729 | 2800.0 |
| 2014-04-11 04:35:00 | AAPL | Stock | 18.6889 | 18.6889 | 18.6889 | 18.6889 | 2800.0 |
| 2014-04-11 04:50:00 | AAPL | Stock | 18.6771 | 18.6771 | 18.6771 | 18.6771 | 8400.0 |
| 2014-04-11 05:00:00 | AAPL | Stock | 18.6736 | 18.6736 | 18.6736 | 18.6736 | 2800.0 |
| 2014-04-11 05:30:00 | AAPL | Stock | 18.6821 | 18.6821 | 18.6821 | 18.6821 | 2800.0 |
| 2014-04-11 06:10:00 | AAPL | Stock | 18.695 | 18.695 | 18.695 | 18.695 | 5600.0 |
| 2014-04-11 06:55:00 | AAPL | Stock | 18.65 | 18.65 | 18.65 | 18.65 | 2800.0 |
| 2014-04-11 07:00:00 | AAPL | Stock | 18.6654 | 18.6654 | 18.6654 | 18.6654 | 2800.0 |
| 2014-04-11 07:05:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6368 | 18.6368 | 11200.0 |
| 2014-04-11 07:15:00 | AAPL | Stock | 18.6179 | 18.6179 | 18.575 | 18.575 | 28000.0 |
| 2014-04-11 07:20:00 | AAPL | Stock | 18.575 | 18.575 | 18.5443 | 18.5714 | 33600.0 |
| 2014-04-11 07:25:00 | AAPL | Stock | 18.5625 | 18.6071 | 18.5625 | 18.6071 | 14000.0 |
| 2014-04-11 07:30:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5443 | 18.5443 | 27104.0 |
| 2014-04-11 07:35:00 | AAPL | Stock | 18.5282 | 18.5536 | 18.5264 | 18.5393 | 60116.0 |
| 2014-04-11 07:40:00 | AAPL | Stock | 18.5536 | 18.5625 | 18.5414 | 18.5414 | 19320.0 |
| 2014-04-11 07:45:00 | AAPL | Stock | 18.5625 | 18.5893 | 18.5625 | 18.5893 | 15400.0 |
| 2014-04-11 07:50:00 | AAPL | Stock | 18.5625 | 18.5732 | 18.5536 | 18.5714 | 53200.0 |
| 2014-04-11 07:55:00 | AAPL | Stock | 18.5729 | 18.5982 | 18.5714 | 18.5982 | 15400.0 |
| 2014-04-11 08:00:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.5536 | 18.5714 | 208684.0 |
| 2014-04-11 08:05:00 | AAPL | Stock | 18.5714 | 18.5789 | 18.5507 | 18.5507 | 128044.0 |
| 2014-04-11 08:10:00 | AAPL | Stock | 18.5357 | 18.5554 | 18.5357 | 18.5482 | 66836.0 |
| 2014-04-11 08:15:00 | AAPL | Stock | 18.55 | 18.555 | 18.5393 | 18.555 | 85540.0 |
| 2014-04-11 08:20:00 | AAPL | Stock | 18.555 | 18.5554 | 18.555 | 18.5554 | 22400.0 |
| 2014-04-11 08:25:00 | AAPL | Stock | 18.5586 | 18.5714 | 18.5514 | 18.5646 | 100688.0 |
| 2014-04-11 08:30:00 | AAPL | Stock | 18.5679 | 18.5732 | 18.5536 | 18.5679 | 93996.0 |
| 2014-04-11 08:35:00 | AAPL | Stock | 18.5707 | 18.5711 | 18.5707 | 18.5711 | 8400.0 |
| 2014-04-11 08:40:00 | AAPL | Stock | 18.5564 | 18.5564 | 18.5564 | 18.5564 | 2800.0 |
| 2014-04-11 08:45:00 | AAPL | Stock | 18.57 | 18.5732 | 18.5593 | 18.5732 | 116424.0 |
| 2014-04-11 08:50:00 | AAPL | Stock | 18.5732 | 18.575 | 18.5732 | 18.575 | 65800.0 |
| 2014-04-11 08:55:00 | AAPL | Stock | 18.5639 | 18.5661 | 18.5625 | 18.5661 | 20160.0 |
| 2014-04-11 09:00:00 | AAPL | Stock | 18.5625 | 18.5625 | 18.5607 | 18.5607 | 39172.0 |
| 2014-04-11 09:05:00 | AAPL | Stock | 18.5696 | 18.5714 | 18.5561 | 18.5561 | 50232.0 |
| 2014-04-11 09:10:00 | AAPL | Stock | 18.5621 | 18.5639 | 18.5539 | 18.5582 | 62104.0 |
| 2014-04-11 09:15:00 | AAPL | Stock | 18.5607 | 18.5686 | 18.5582 | 18.5604 | 38388.0 |
| 2014-04-11 09:20:00 | AAPL | Stock | 18.5611 | 18.5625 | 18.5418 | 18.5418 | 98700.0 |
| 2014-04-11 09:25:00 | AAPL | Stock | 18.5414 | 18.5611 | 18.5321 | 18.5357 | 218008.0 |
| 2014-04-11 09:30:00 | AAPL | Stock | 18.5357 | 18.6571 | 18.5346 | 18.5693 | 13521172.0 |
| 2014-04-11 09:35:00 | AAPL | Stock | 18.5671 | 18.6321 | 18.5432 | 18.6118 | 5892460.0 |
| 2014-04-11 09:40:00 | AAPL | Stock | 18.6064 | 18.625 | 18.5761 | 18.6036 | 2846564.0 |
| 2014-04-11 09:45:00 | AAPL | Stock | 18.6036 | 18.6043 | 18.5579 | 18.5832 | 3825976.0 |
| 2014-04-11 09:50:00 | AAPL | Stock | 18.5836 | 18.6246 | 18.5786 | 18.615 | 3935876.0 |
| 2014-04-11 09:55:00 | AAPL | Stock | 18.6096 | 18.6225 | 18.5632 | 18.5679 | 2320668.0 |
| 2014-04-11 10:00:00 | AAPL | Stock | 18.5682 | 18.5818 | 18.5389 | 18.5389 | 4218004.0 |
| 2014-04-11 10:05:00 | AAPL | Stock | 18.5389 | 18.5621 | 18.5196 | 18.5239 | 5495504.0 |
| 2014-04-11 10:10:00 | AAPL | Stock | 18.5214 | 18.5439 | 18.4821 | 18.4882 | 6051752.0 |
| 2014-04-11 10:15:00 | AAPL | Stock | 18.4854 | 18.5046 | 18.4779 | 18.4893 | 5006400.0 |
| 2014-04-11 10:20:00 | AAPL | Stock | 18.4904 | 18.5111 | 18.4693 | 18.5022 | 4174184.0 |
| 2014-04-11 10:25:00 | AAPL | Stock | 18.5077 | 18.5493 | 18.5054 | 18.5386 | 3938984.0 |
| 2014-04-11 10:30:00 | AAPL | Stock | 18.5386 | 18.5482 | 18.5186 | 18.5404 | 2808792.0 |
| 2014-04-11 10:35:00 | AAPL | Stock | 18.5368 | 18.5614 | 18.5354 | 18.5454 | 3813880.0 |
> showing 50 of 362,434 rows — these rows as CSV