PREVIEW / stock_1min / 2013-10-14
file: by_date/stock_1min/2013/2013-10-14.parquet size: 12.9 MB rows: 947,295 symbols: 2,847
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-10-14 04:00:00 | AAPL | Stock | 17.2789 | 17.5361 | 17.2789 | 17.5 | 19180.0 |
| 2013-10-14 04:07:00 | AAPL | Stock | 17.5289 | 17.5304 | 17.5289 | 17.5304 | 5600.0 |
| 2013-10-14 04:08:00 | AAPL | Stock | 17.5007 | 17.5007 | 17.5007 | 17.5007 | 22400.0 |
| 2013-10-14 04:17:00 | AAPL | Stock | 17.5043 | 17.5043 | 17.5043 | 17.5043 | 2800.0 |
| 2013-10-14 04:19:00 | AAPL | Stock | 17.5179 | 17.5179 | 17.5179 | 17.5179 | 8400.0 |
| 2013-10-14 04:30:00 | AAPL | Stock | 17.5014 | 17.5014 | 17.5007 | 17.5007 | 22120.0 |
| 2013-10-14 04:33:00 | AAPL | Stock | 17.5007 | 17.5054 | 17.5007 | 17.5054 | 16324.0 |
| 2013-10-14 04:34:00 | AAPL | Stock | 17.5054 | 17.5054 | 17.4946 | 17.4946 | 30800.0 |
| 2013-10-14 04:35:00 | AAPL | Stock | 17.4946 | 17.4946 | 17.4936 | 17.4936 | 29120.0 |
| 2013-10-14 04:38:00 | AAPL | Stock | 17.4893 | 17.4893 | 17.4893 | 17.4893 | 5600.0 |
| 2013-10-14 04:44:00 | AAPL | Stock | 17.4718 | 17.4718 | 17.4718 | 17.4718 | 4200.0 |
| 2013-10-14 04:51:00 | AAPL | Stock | 17.4825 | 17.4893 | 17.4825 | 17.4893 | 5600.0 |
| 2013-10-14 04:56:00 | AAPL | Stock | 17.4754 | 17.4754 | 17.4732 | 17.4732 | 12600.0 |
| 2013-10-14 05:04:00 | AAPL | Stock | 17.4746 | 17.4746 | 17.4746 | 17.4746 | 5600.0 |
| 2013-10-14 05:05:00 | AAPL | Stock | 17.4739 | 17.4739 | 17.4739 | 17.4739 | 5600.0 |
| 2013-10-14 05:06:00 | AAPL | Stock | 17.4739 | 17.4739 | 17.4739 | 17.4739 | 16800.0 |
| 2013-10-14 05:17:00 | AAPL | Stock | 17.4886 | 17.4886 | 17.4886 | 17.4886 | 2800.0 |
| 2013-10-14 05:19:00 | AAPL | Stock | 17.4939 | 17.4939 | 17.4939 | 17.4939 | 2800.0 |
| 2013-10-14 06:07:00 | AAPL | Stock | 17.5054 | 17.5054 | 17.5054 | 17.5054 | 2800.0 |
| 2013-10-14 06:14:00 | AAPL | Stock | 17.4968 | 17.4968 | 17.4968 | 17.4968 | 2800.0 |
| 2013-10-14 06:19:00 | AAPL | Stock | 17.4964 | 17.4964 | 17.4964 | 17.4964 | 7840.0 |
| 2013-10-14 06:21:00 | AAPL | Stock | 17.5114 | 17.5118 | 17.5114 | 17.5118 | 14000.0 |
| 2013-10-14 06:23:00 | AAPL | Stock | 17.5118 | 17.5118 | 17.5118 | 17.5118 | 2800.0 |
| 2013-10-14 07:00:00 | AAPL | Stock | 17.5054 | 17.5054 | 17.5039 | 17.5039 | 14000.0 |
| 2013-10-14 07:01:00 | AAPL | Stock | 17.5039 | 17.5071 | 17.5039 | 17.5071 | 14000.0 |
| 2013-10-14 07:02:00 | AAPL | Stock | 17.5089 | 17.5164 | 17.5036 | 17.5164 | 23800.0 |
| 2013-10-14 07:14:00 | AAPL | Stock | 17.5082 | 17.5082 | 17.5082 | 17.5082 | 9100.0 |
| 2013-10-14 07:15:00 | AAPL | Stock | 17.5082 | 17.5082 | 17.5082 | 17.5082 | 4200.0 |
| 2013-10-14 07:18:00 | AAPL | Stock | 17.5089 | 17.5089 | 17.5089 | 17.5089 | 8400.0 |
| 2013-10-14 07:20:00 | AAPL | Stock | 17.5111 | 17.5193 | 17.5111 | 17.5193 | 5600.0 |
| 2013-10-14 07:25:00 | AAPL | Stock | 17.5 | 17.5 | 17.4946 | 17.4946 | 57876.0 |
| 2013-10-14 07:27:00 | AAPL | Stock | 17.5 | 17.5004 | 17.5 | 17.5004 | 11200.0 |
| 2013-10-14 07:28:00 | AAPL | Stock | 17.5014 | 17.5014 | 17.5014 | 17.5014 | 2800.0 |
| 2013-10-14 07:31:00 | AAPL | Stock | 17.5075 | 17.5075 | 17.5075 | 17.5075 | 11200.0 |
| 2013-10-14 07:38:00 | AAPL | Stock | 17.5039 | 17.5039 | 17.5039 | 17.5039 | 5600.0 |
| 2013-10-14 07:45:00 | AAPL | Stock | 17.4943 | 17.4943 | 17.4936 | 17.4936 | 5600.0 |
| 2013-10-14 07:46:00 | AAPL | Stock | 17.4839 | 17.4839 | 17.4754 | 17.4754 | 33600.0 |
| 2013-10-14 07:47:00 | AAPL | Stock | 17.4739 | 17.475 | 17.4732 | 17.4732 | 35840.0 |
| 2013-10-14 07:48:00 | AAPL | Stock | 17.4646 | 17.4646 | 17.4643 | 17.4643 | 17500.0 |
| 2013-10-14 07:49:00 | AAPL | Stock | 17.4629 | 17.4643 | 17.4629 | 17.4639 | 13412.0 |
| 2013-10-14 07:50:00 | AAPL | Stock | 17.4664 | 17.4718 | 17.4518 | 17.4589 | 48860.0 |
| 2013-10-14 07:51:00 | AAPL | Stock | 17.4643 | 17.4693 | 17.4643 | 17.4643 | 103600.0 |
| 2013-10-14 07:52:00 | AAPL | Stock | 17.4904 | 17.4904 | 17.4904 | 17.4904 | 2800.0 |
| 2013-10-14 07:53:00 | AAPL | Stock | 17.4679 | 17.4679 | 17.4625 | 17.4625 | 27300.0 |
| 2013-10-14 07:56:00 | AAPL | Stock | 17.4718 | 17.4718 | 17.4718 | 17.4718 | 7280.0 |
| 2013-10-14 07:57:00 | AAPL | Stock | 17.4818 | 17.4839 | 17.4818 | 17.4839 | 28000.0 |
| 2013-10-14 08:00:00 | AAPL | Stock | 17.4714 | 17.5089 | 17.4643 | 17.4682 | 248360.0 |
| 2013-10-14 08:01:00 | AAPL | Stock | 17.4686 | 17.4686 | 17.4504 | 17.4504 | 121240.0 |
| 2013-10-14 08:02:00 | AAPL | Stock | 17.4489 | 17.4532 | 17.4464 | 17.4532 | 68768.0 |
| 2013-10-14 08:03:00 | AAPL | Stock | 17.4518 | 17.4543 | 17.4379 | 17.4543 | 82712.0 |
> showing 50 of 947,295 rows — these rows as CSV