PREVIEW / stock_1min / 2012-03-12
file: by_date/stock_1min/2012/2012-03-12.parquet size: 12.6 MB rows: 946,320 symbols: 2,844
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-03-12 05:06:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 9800.0 |
| 2012-03-12 05:10:00 | AAPL | Stock | 19.4579 | 19.4579 | 19.4579 | 19.4579 | 2800.0 |
| 2012-03-12 05:12:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 5600.0 |
| 2012-03-12 05:26:00 | AAPL | Stock | 19.4418 | 19.4418 | 19.4414 | 19.4414 | 16408.0 |
| 2012-03-12 05:27:00 | AAPL | Stock | 19.4414 | 19.4414 | 19.4414 | 19.4414 | 11200.0 |
| 2012-03-12 05:47:00 | AAPL | Stock | 19.4568 | 19.4568 | 19.4568 | 19.4568 | 2800.0 |
| 2012-03-12 05:49:00 | AAPL | Stock | 19.4564 | 19.4564 | 19.4564 | 19.4564 | 2800.0 |
| 2012-03-12 05:50:00 | AAPL | Stock | 19.4564 | 19.4564 | 19.4564 | 19.4564 | 2800.0 |
| 2012-03-12 06:05:00 | AAPL | Stock | 19.4557 | 19.4557 | 19.4557 | 19.4557 | 28000.0 |
| 2012-03-12 06:06:00 | AAPL | Stock | 19.4557 | 19.4557 | 19.4557 | 19.4557 | 2800.0 |
| 2012-03-12 06:13:00 | AAPL | Stock | 19.4557 | 19.4557 | 19.4557 | 19.4557 | 2800.0 |
| 2012-03-12 06:14:00 | AAPL | Stock | 19.4536 | 19.4536 | 19.4536 | 19.4536 | 2800.0 |
| 2012-03-12 06:24:00 | AAPL | Stock | 19.4546 | 19.4546 | 19.4546 | 19.4546 | 2800.0 |
| 2012-03-12 07:00:00 | AAPL | Stock | 19.4607 | 19.4607 | 19.4607 | 19.4607 | 2800.0 |
| 2012-03-12 07:03:00 | AAPL | Stock | 19.4607 | 19.4679 | 19.4607 | 19.4679 | 21392.0 |
| 2012-03-12 07:04:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 8400.0 |
| 2012-03-12 07:05:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 14000.0 |
| 2012-03-12 07:07:00 | AAPL | Stock | 19.4643 | 19.4714 | 19.4643 | 19.4714 | 71260.0 |
| 2012-03-12 07:08:00 | AAPL | Stock | 19.4696 | 19.4732 | 19.4696 | 19.4714 | 49868.0 |
| 2012-03-12 07:09:00 | AAPL | Stock | 19.4679 | 19.4679 | 19.4679 | 19.4679 | 17332.0 |
| 2012-03-12 07:10:00 | AAPL | Stock | 19.4732 | 19.4732 | 19.4732 | 19.4732 | 8400.0 |
| 2012-03-12 07:11:00 | AAPL | Stock | 19.4714 | 19.4714 | 19.4714 | 19.4714 | 7868.0 |
| 2012-03-12 07:12:00 | AAPL | Stock | 19.4714 | 19.4732 | 19.4714 | 19.4732 | 19600.0 |
| 2012-03-12 07:14:00 | AAPL | Stock | 19.4786 | 19.4786 | 19.4786 | 19.4786 | 2800.0 |
| 2012-03-12 07:15:00 | AAPL | Stock | 19.4814 | 19.4929 | 19.4786 | 19.4839 | 64960.0 |
| 2012-03-12 07:16:00 | AAPL | Stock | 19.4843 | 19.4843 | 19.4843 | 19.4843 | 2800.0 |
| 2012-03-12 07:17:00 | AAPL | Stock | 19.4868 | 19.4896 | 19.4868 | 19.4896 | 5600.0 |
| 2012-03-12 07:18:00 | AAPL | Stock | 19.4929 | 19.4929 | 19.4929 | 19.4929 | 11200.0 |
| 2012-03-12 07:20:00 | AAPL | Stock | 19.4886 | 19.4993 | 19.4886 | 19.4993 | 5600.0 |
| 2012-03-12 07:21:00 | AAPL | Stock | 19.4857 | 19.4857 | 19.4821 | 19.4821 | 25200.0 |
| 2012-03-12 07:22:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 9800.0 |
| 2012-03-12 07:27:00 | AAPL | Stock | 19.4818 | 19.4821 | 19.4818 | 19.4821 | 8400.0 |
| 2012-03-12 07:29:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 62860.0 |
| 2012-03-12 07:32:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 2800.0 |
| 2012-03-12 07:36:00 | AAPL | Stock | 19.4818 | 19.4821 | 19.4796 | 19.4818 | 28000.0 |
| 2012-03-12 07:38:00 | AAPL | Stock | 19.4714 | 19.4714 | 19.4714 | 19.4714 | 8400.0 |
| 2012-03-12 07:43:00 | AAPL | Stock | 19.475 | 19.475 | 19.475 | 19.475 | 7560.0 |
| 2012-03-12 07:45:00 | AAPL | Stock | 19.4721 | 19.4721 | 19.4721 | 19.4721 | 13664.0 |
| 2012-03-12 07:47:00 | AAPL | Stock | 19.4714 | 19.4714 | 19.4714 | 19.4714 | 2800.0 |
| 2012-03-12 07:48:00 | AAPL | Stock | 19.4721 | 19.4721 | 19.4721 | 19.4721 | 5404.0 |
| 2012-03-12 07:51:00 | AAPL | Stock | 19.4721 | 19.4721 | 19.4686 | 19.4686 | 13440.0 |
| 2012-03-12 07:52:00 | AAPL | Stock | 19.4686 | 19.4732 | 19.4679 | 19.4732 | 60424.0 |
| 2012-03-12 07:54:00 | AAPL | Stock | 19.4668 | 19.4668 | 19.4668 | 19.4668 | 11256.0 |
| 2012-03-12 07:55:00 | AAPL | Stock | 19.4668 | 19.4732 | 19.4668 | 19.4729 | 91840.0 |
| 2012-03-12 07:56:00 | AAPL | Stock | 19.4693 | 19.4696 | 19.4693 | 19.4696 | 30800.0 |
| 2012-03-12 07:57:00 | AAPL | Stock | 19.4714 | 19.4729 | 19.4714 | 19.4729 | 33600.0 |
| 2012-03-12 07:58:00 | AAPL | Stock | 19.4668 | 19.475 | 19.4643 | 19.4746 | 73080.0 |
| 2012-03-12 07:59:00 | AAPL | Stock | 19.4793 | 19.4793 | 19.4793 | 19.4793 | 2800.0 |
| 2012-03-12 08:00:00 | AAPL | Stock | 19.4793 | 19.5014 | 19.4761 | 19.5 | 259252.0 |
| 2012-03-12 08:01:00 | AAPL | Stock | 19.5061 | 19.5168 | 19.5061 | 19.5075 | 178360.0 |
> showing 50 of 946,320 rows — these rows as CSV