PREVIEW / stock_1min / 2012-10-31
file: by_date/stock_1min/2012/2012-10-31.parquet size: 12.9 MB rows: 952,126 symbols: 2,829
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-10-31 04:37:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 5600.0 |
| 2012-10-31 04:46:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 2856.0 |
| 2012-10-31 05:33:00 | AAPL | Stock | 21.5482 | 21.5482 | 21.5482 | 21.5482 | 2800.0 |
| 2012-10-31 05:43:00 | AAPL | Stock | 21.5689 | 21.5689 | 21.5689 | 21.5689 | 10080.0 |
| 2012-10-31 06:07:00 | AAPL | Stock | 21.5482 | 21.5482 | 21.5157 | 21.5157 | 11900.0 |
| 2012-10-31 06:27:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 2800.0 |
| 2012-10-31 06:35:00 | AAPL | Stock | 21.5536 | 21.5536 | 21.5536 | 21.5536 | 14000.0 |
| 2012-10-31 06:55:00 | AAPL | Stock | 21.5536 | 21.5536 | 21.5536 | 21.5536 | 3164.0 |
| 2012-10-31 07:00:00 | AAPL | Stock | 21.5289 | 21.5289 | 21.5289 | 21.5289 | 5600.0 |
| 2012-10-31 07:01:00 | AAPL | Stock | 21.5207 | 21.5211 | 21.5107 | 21.5211 | 22400.0 |
| 2012-10-31 07:02:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5179 | 21.5179 | 8400.0 |
| 2012-10-31 07:03:00 | AAPL | Stock | 21.5061 | 21.5061 | 21.4857 | 21.4857 | 14308.0 |
| 2012-10-31 07:04:00 | AAPL | Stock | 21.4857 | 21.4857 | 21.4643 | 21.4643 | 11200.0 |
| 2012-10-31 07:05:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.4286 | 21.4286 | 8820.0 |
| 2012-10-31 07:06:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.4104 | 21.4107 | 52360.0 |
| 2012-10-31 07:07:00 | AAPL | Stock | 21.4107 | 21.4107 | 21.4004 | 21.4004 | 9520.0 |
| 2012-10-31 07:08:00 | AAPL | Stock | 21.3875 | 21.4107 | 21.3754 | 21.3754 | 69860.0 |
| 2012-10-31 07:10:00 | AAPL | Stock | 21.3932 | 21.3932 | 21.3929 | 21.3929 | 8400.0 |
| 2012-10-31 07:11:00 | AAPL | Stock | 21.4082 | 21.4082 | 21.3846 | 21.3846 | 19740.0 |
| 2012-10-31 07:12:00 | AAPL | Stock | 21.3929 | 21.4107 | 21.3929 | 21.4107 | 143696.0 |
| 2012-10-31 07:13:00 | AAPL | Stock | 21.4107 | 21.4107 | 21.4057 | 21.4057 | 5600.0 |
| 2012-10-31 07:14:00 | AAPL | Stock | 21.4275 | 21.4279 | 21.3968 | 21.3968 | 14000.0 |
| 2012-10-31 07:15:00 | AAPL | Stock | 21.4143 | 21.4196 | 21.4143 | 21.4196 | 11200.0 |
| 2012-10-31 07:16:00 | AAPL | Stock | 21.4282 | 21.4339 | 21.4282 | 21.4286 | 88816.0 |
| 2012-10-31 07:17:00 | AAPL | Stock | 21.4375 | 21.4375 | 21.4375 | 21.4375 | 2800.0 |
| 2012-10-31 07:18:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 9156.0 |
| 2012-10-31 07:20:00 | AAPL | Stock | 21.4289 | 21.4289 | 21.4107 | 21.4107 | 39200.0 |
| 2012-10-31 07:21:00 | AAPL | Stock | 21.4264 | 21.4268 | 21.3929 | 21.4054 | 30352.0 |
| 2012-10-31 07:22:00 | AAPL | Stock | 21.4143 | 21.4196 | 21.4054 | 21.4196 | 14560.0 |
| 2012-10-31 07:24:00 | AAPL | Stock | 21.4196 | 21.4196 | 21.4196 | 21.4196 | 2800.0 |
| 2012-10-31 07:25:00 | AAPL | Stock | 21.4193 | 21.4618 | 21.4193 | 21.4554 | 99792.0 |
| 2012-10-31 07:26:00 | AAPL | Stock | 21.4554 | 21.4643 | 21.4554 | 21.4554 | 55860.0 |
| 2012-10-31 07:27:00 | AAPL | Stock | 21.4554 | 21.4554 | 21.4286 | 21.4286 | 15400.0 |
| 2012-10-31 07:34:00 | AAPL | Stock | 21.4289 | 21.4289 | 21.4289 | 21.4289 | 2800.0 |
| 2012-10-31 07:35:00 | AAPL | Stock | 21.4586 | 21.4586 | 21.4586 | 21.4586 | 2800.0 |
| 2012-10-31 07:40:00 | AAPL | Stock | 21.45 | 21.45 | 21.45 | 21.45 | 2800.0 |
| 2012-10-31 07:42:00 | AAPL | Stock | 21.4339 | 21.4339 | 21.4286 | 21.4286 | 5600.0 |
| 2012-10-31 07:45:00 | AAPL | Stock | 21.4232 | 21.4232 | 21.4232 | 21.4232 | 4984.0 |
| 2012-10-31 07:50:00 | AAPL | Stock | 21.4036 | 21.4036 | 21.4036 | 21.4036 | 5600.0 |
| 2012-10-31 07:51:00 | AAPL | Stock | 21.4196 | 21.4196 | 21.4 | 21.4018 | 58800.0 |
| 2012-10-31 07:52:00 | AAPL | Stock | 21.3975 | 21.4 | 21.3929 | 21.3964 | 80528.0 |
| 2012-10-31 07:53:00 | AAPL | Stock | 21.4082 | 21.4082 | 21.3932 | 21.3932 | 8400.0 |
| 2012-10-31 07:54:00 | AAPL | Stock | 21.3982 | 21.4 | 21.3982 | 21.4 | 11200.0 |
| 2012-10-31 07:55:00 | AAPL | Stock | 21.4 | 21.4068 | 21.4 | 21.4068 | 8400.0 |
| 2012-10-31 07:56:00 | AAPL | Stock | 21.4161 | 21.4161 | 21.4161 | 21.4161 | 2800.0 |
| 2012-10-31 07:57:00 | AAPL | Stock | 21.4193 | 21.4193 | 21.4193 | 21.4193 | 2800.0 |
| 2012-10-31 07:58:00 | AAPL | Stock | 21.4232 | 21.4232 | 21.4021 | 21.4025 | 56644.0 |
| 2012-10-31 07:59:00 | AAPL | Stock | 21.4179 | 21.4179 | 21.4179 | 21.4179 | 2800.0 |
| 2012-10-31 08:00:00 | AAPL | Stock | 21.4161 | 21.4232 | 21.4054 | 21.4107 | 105616.0 |
| 2012-10-31 08:01:00 | AAPL | Stock | 21.4107 | 21.4229 | 21.3839 | 21.3929 | 127316.0 |
> showing 50 of 952,126 rows — these rows as CSV