PREVIEW / stock_1min / 2012-03-19
file: by_date/stock_1min/2012/2012-03-19.parquet size: 13.4 MB rows: 999,494 symbols: 2,862
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-19 04:00:00 | AAPL | Stock | 21.625 | 21.625 | 21.2321 | 21.2321 | 53844.0 |
| 2012-03-19 04:01:00 | AAPL | Stock | 21.2321 | 21.2321 | 21.2321 | 21.2321 | 2800.0 |
| 2012-03-19 04:02:00 | AAPL | Stock | 21.2818 | 21.2818 | 21.2818 | 21.2818 | 5460.0 |
| 2012-03-19 04:03:00 | AAPL | Stock | 21.2818 | 21.2818 | 21.25 | 21.25 | 25872.0 |
| 2012-03-19 04:04:00 | AAPL | Stock | 21.3314 | 21.3393 | 21.3282 | 21.3393 | 11200.0 |
| 2012-03-19 04:05:00 | AAPL | Stock | 21.3425 | 21.3707 | 21.3425 | 21.3707 | 19600.0 |
| 2012-03-19 04:06:00 | AAPL | Stock | 21.3929 | 21.3929 | 21.3929 | 21.3929 | 2800.0 |
| 2012-03-19 04:07:00 | AAPL | Stock | 21.4204 | 21.4486 | 21.4204 | 21.4375 | 57596.0 |
| 2012-03-19 04:08:00 | AAPL | Stock | 21.4539 | 21.4643 | 21.4539 | 21.4643 | 21616.0 |
| 2012-03-19 04:09:00 | AAPL | Stock | 21.4643 | 21.5 | 21.4286 | 21.4286 | 54124.0 |
| 2012-03-19 04:10:00 | AAPL | Stock | 21.4325 | 21.4821 | 21.4325 | 21.4821 | 8400.0 |
| 2012-03-19 04:11:00 | AAPL | Stock | 21.4464 | 21.5 | 21.4464 | 21.5 | 78344.0 |
| 2012-03-19 04:12:00 | AAPL | Stock | 21.5161 | 21.5357 | 21.4643 | 21.4643 | 43148.0 |
| 2012-03-19 04:13:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.4286 | 21.4286 | 76048.0 |
| 2012-03-19 04:14:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4018 | 21.4018 | 12600.0 |
| 2012-03-19 04:15:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4161 | 21.4286 | 40600.0 |
| 2012-03-19 04:16:00 | AAPL | Stock | 21.4286 | 21.4464 | 21.4271 | 21.4286 | 47320.0 |
| 2012-03-19 04:17:00 | AAPL | Stock | 21.4464 | 21.4464 | 21.4286 | 21.4286 | 21000.0 |
| 2012-03-19 04:18:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 26152.0 |
| 2012-03-19 04:19:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 27160.0 |
| 2012-03-19 04:20:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.425 | 21.4286 | 40488.0 |
| 2012-03-19 04:21:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 4004.0 |
| 2012-03-19 04:22:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 36400.0 |
| 2012-03-19 04:24:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 25200.0 |
| 2012-03-19 04:25:00 | AAPL | Stock | 21.425 | 21.425 | 21.425 | 21.425 | 7000.0 |
| 2012-03-19 04:26:00 | AAPL | Stock | 21.4179 | 21.4179 | 21.4179 | 21.4179 | 2800.0 |
| 2012-03-19 04:27:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.425 | 21.4286 | 22400.0 |
| 2012-03-19 04:28:00 | AAPL | Stock | 21.4179 | 21.4179 | 21.4125 | 21.4125 | 19600.0 |
| 2012-03-19 04:29:00 | AAPL | Stock | 21.4107 | 21.4107 | 21.4107 | 21.4107 | 2800.0 |
| 2012-03-19 04:30:00 | AAPL | Stock | 21.4107 | 21.4107 | 21.4107 | 21.4107 | 5600.0 |
| 2012-03-19 04:31:00 | AAPL | Stock | 21.4107 | 21.4107 | 21.4071 | 21.4071 | 8400.0 |
| 2012-03-19 04:32:00 | AAPL | Stock | 21.4107 | 21.4107 | 21.4089 | 21.4107 | 29400.0 |
| 2012-03-19 04:34:00 | AAPL | Stock | 21.4196 | 21.4282 | 21.4196 | 21.4282 | 8400.0 |
| 2012-03-19 04:35:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 33600.0 |
| 2012-03-19 04:37:00 | AAPL | Stock | 21.4196 | 21.4286 | 21.4196 | 21.4196 | 16800.0 |
| 2012-03-19 04:38:00 | AAPL | Stock | 21.415 | 21.415 | 21.4143 | 21.4143 | 13188.0 |
| 2012-03-19 04:39:00 | AAPL | Stock | 21.4143 | 21.4143 | 21.4036 | 21.4036 | 16800.0 |
| 2012-03-19 04:41:00 | AAPL | Stock | 21.425 | 21.425 | 21.425 | 21.425 | 2800.0 |
| 2012-03-19 04:42:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 2800.0 |
| 2012-03-19 04:43:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 2800.0 |
| 2012-03-19 04:44:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 2800.0 |
| 2012-03-19 04:45:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 5600.0 |
| 2012-03-19 04:46:00 | AAPL | Stock | 21.4154 | 21.4286 | 21.4046 | 21.4286 | 11200.0 |
| 2012-03-19 04:48:00 | AAPL | Stock | 21.4268 | 21.4375 | 21.4268 | 21.4375 | 14000.0 |
| 2012-03-19 04:49:00 | AAPL | Stock | 21.4375 | 21.4375 | 21.4375 | 21.4375 | 14000.0 |
| 2012-03-19 04:50:00 | AAPL | Stock | 21.4375 | 21.4375 | 21.4375 | 21.4375 | 11200.0 |
| 2012-03-19 04:51:00 | AAPL | Stock | 21.4375 | 21.4375 | 21.4375 | 21.4375 | 5600.0 |
| 2012-03-19 04:52:00 | AAPL | Stock | 21.4364 | 21.4375 | 21.4364 | 21.4375 | 5600.0 |
| 2012-03-19 04:54:00 | AAPL | Stock | 21.4354 | 21.4354 | 21.4354 | 21.4354 | 2800.0 |
| 2012-03-19 04:55:00 | AAPL | Stock | 21.4375 | 21.4375 | 21.4375 | 21.4375 | 25200.0 |
> showing 50 of 999,494 rows — these rows as CSV