PREVIEW / stock_1min / 2013-10-08
file: by_date/stock_1min/2013/2013-10-08.parquet size: 14.2 MB rows: 1,030,472 symbols: 2,860
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-08 04:14:00 | AAPL | Stock | 17.4196 | 17.4196 | 17.4196 | 17.4196 | 2800.0 |
| 2013-10-08 06:21:00 | AAPL | Stock | 17.4021 | 17.4021 | 17.4021 | 17.4021 | 2800.0 |
| 2013-10-08 06:26:00 | AAPL | Stock | 17.425 | 17.425 | 17.425 | 17.425 | 2800.0 |
| 2013-10-08 06:47:00 | AAPL | Stock | 17.4279 | 17.4279 | 17.4279 | 17.4279 | 2800.0 |
| 2013-10-08 07:00:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 8400.0 |
| 2013-10-08 07:13:00 | AAPL | Stock | 17.4289 | 17.4289 | 17.4282 | 17.4282 | 5600.0 |
| 2013-10-08 07:14:00 | AAPL | Stock | 17.4282 | 17.4282 | 17.4282 | 17.4282 | 2800.0 |
| 2013-10-08 07:17:00 | AAPL | Stock | 17.4196 | 17.4196 | 17.4196 | 17.4196 | 2800.0 |
| 2013-10-08 07:20:00 | AAPL | Stock | 17.4 | 17.4 | 17.4 | 17.4 | 8400.0 |
| 2013-10-08 07:22:00 | AAPL | Stock | 17.3929 | 17.3929 | 17.3929 | 17.3929 | 25200.0 |
| 2013-10-08 07:25:00 | AAPL | Stock | 17.4054 | 17.4054 | 17.4054 | 17.4054 | 2800.0 |
| 2013-10-08 07:26:00 | AAPL | Stock | 17.4032 | 17.4032 | 17.4032 | 17.4032 | 2800.0 |
| 2013-10-08 07:28:00 | AAPL | Stock | 17.4036 | 17.4036 | 17.4036 | 17.4036 | 8400.0 |
| 2013-10-08 07:31:00 | AAPL | Stock | 17.4154 | 17.4154 | 17.4154 | 17.4154 | 14000.0 |
| 2013-10-08 07:32:00 | AAPL | Stock | 17.4154 | 17.4232 | 17.4154 | 17.4211 | 11200.0 |
| 2013-10-08 07:34:00 | AAPL | Stock | 17.4221 | 17.4221 | 17.4221 | 17.4221 | 2800.0 |
| 2013-10-08 07:45:00 | AAPL | Stock | 17.4246 | 17.4246 | 17.4225 | 17.4225 | 19600.0 |
| 2013-10-08 07:46:00 | AAPL | Stock | 17.4118 | 17.4118 | 17.4118 | 17.4118 | 2800.0 |
| 2013-10-08 07:47:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 2800.0 |
| 2013-10-08 07:49:00 | AAPL | Stock | 17.4196 | 17.4232 | 17.4196 | 17.4232 | 25760.0 |
| 2013-10-08 07:50:00 | AAPL | Stock | 17.4339 | 17.4414 | 17.4339 | 17.4414 | 26628.0 |
| 2013-10-08 07:51:00 | AAPL | Stock | 17.4414 | 17.4414 | 17.4354 | 17.4354 | 37772.0 |
| 2013-10-08 07:55:00 | AAPL | Stock | 17.4404 | 17.4404 | 17.4404 | 17.4404 | 2800.0 |
| 2013-10-08 07:57:00 | AAPL | Stock | 17.4407 | 17.4407 | 17.4407 | 17.4407 | 5600.0 |
| 2013-10-08 07:58:00 | AAPL | Stock | 17.4414 | 17.4439 | 17.4414 | 17.4439 | 19880.0 |
| 2013-10-08 08:00:00 | AAPL | Stock | 17.4511 | 17.4554 | 17.4232 | 17.4539 | 103012.0 |
| 2013-10-08 08:01:00 | AAPL | Stock | 17.4514 | 17.4518 | 17.3929 | 17.4518 | 44296.0 |
| 2013-10-08 08:02:00 | AAPL | Stock | 17.4532 | 17.4729 | 17.4532 | 17.4643 | 56336.0 |
| 2013-10-08 08:03:00 | AAPL | Stock | 17.4636 | 17.4696 | 17.4636 | 17.4696 | 30800.0 |
| 2013-10-08 08:04:00 | AAPL | Stock | 17.4682 | 17.4682 | 17.4554 | 17.4554 | 41160.0 |
| 2013-10-08 08:05:00 | AAPL | Stock | 17.4554 | 17.4761 | 17.4554 | 17.4761 | 60536.0 |
| 2013-10-08 08:06:00 | AAPL | Stock | 17.4761 | 17.4807 | 17.4761 | 17.4807 | 8400.0 |
| 2013-10-08 08:07:00 | AAPL | Stock | 17.4818 | 17.5075 | 17.4814 | 17.495 | 147364.0 |
| 2013-10-08 08:08:00 | AAPL | Stock | 17.4946 | 17.4946 | 17.4771 | 17.4789 | 30800.0 |
| 2013-10-08 08:09:00 | AAPL | Stock | 17.4821 | 17.4821 | 17.4821 | 17.4821 | 2800.0 |
| 2013-10-08 08:10:00 | AAPL | Stock | 17.495 | 17.495 | 17.4843 | 17.4843 | 28000.0 |
| 2013-10-08 08:11:00 | AAPL | Stock | 17.4986 | 17.4986 | 17.4821 | 17.4821 | 36400.0 |
| 2013-10-08 08:12:00 | AAPL | Stock | 17.4821 | 17.4911 | 17.4821 | 17.4911 | 41356.0 |
| 2013-10-08 08:13:00 | AAPL | Stock | 17.4964 | 17.4964 | 17.4964 | 17.4964 | 3640.0 |
| 2013-10-08 08:14:00 | AAPL | Stock | 17.4886 | 17.4893 | 17.4886 | 17.4889 | 11704.0 |
| 2013-10-08 08:15:00 | AAPL | Stock | 17.4929 | 17.4964 | 17.475 | 17.475 | 138320.0 |
| 2013-10-08 08:16:00 | AAPL | Stock | 17.4754 | 17.4786 | 17.4643 | 17.4786 | 33600.0 |
| 2013-10-08 08:17:00 | AAPL | Stock | 17.4771 | 17.4771 | 17.4732 | 17.4732 | 8400.0 |
| 2013-10-08 08:18:00 | AAPL | Stock | 17.4768 | 17.4768 | 17.4768 | 17.4768 | 3332.0 |
| 2013-10-08 08:19:00 | AAPL | Stock | 17.4736 | 17.4821 | 17.4686 | 17.4821 | 18732.0 |
| 2013-10-08 08:20:00 | AAPL | Stock | 17.4839 | 17.4857 | 17.4839 | 17.4839 | 25200.0 |
| 2013-10-08 08:21:00 | AAPL | Stock | 17.4818 | 17.4839 | 17.4786 | 17.4839 | 39200.0 |
| 2013-10-08 08:25:00 | AAPL | Stock | 17.4854 | 17.4854 | 17.4836 | 17.4854 | 14000.0 |
| 2013-10-08 08:26:00 | AAPL | Stock | 17.4836 | 17.4875 | 17.4836 | 17.4857 | 61600.0 |
| 2013-10-08 08:27:00 | AAPL | Stock | 17.4854 | 17.4889 | 17.4829 | 17.4882 | 61600.0 |
> showing 50 of 1,030,472 rows — these rows as CSV