PREVIEW / stock_1min / 2012-08-15
file: by_date/stock_1min/2012/2012-08-15.parquet size: 11.6 MB rows: 871,046 symbols: 2,799
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-08-15 04:09:00 | AAPL | Stock | 22.5357 | 22.5464 | 22.5357 | 22.5464 | 5600.0 |
| 2012-08-15 04:11:00 | AAPL | Stock | 22.5468 | 22.5468 | 22.5443 | 22.5443 | 5600.0 |
| 2012-08-15 04:13:00 | AAPL | Stock | 22.5396 | 22.5396 | 22.5396 | 22.5396 | 2800.0 |
| 2012-08-15 04:21:00 | AAPL | Stock | 22.5464 | 22.5464 | 22.5464 | 22.5464 | 2800.0 |
| 2012-08-15 04:25:00 | AAPL | Stock | 22.5464 | 22.5464 | 22.5464 | 22.5464 | 11200.0 |
| 2012-08-15 04:57:00 | AAPL | Stock | 22.5786 | 22.5786 | 22.5786 | 22.5786 | 2800.0 |
| 2012-08-15 05:29:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 2800.0 |
| 2012-08-15 05:40:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 9716.0 |
| 2012-08-15 05:44:00 | AAPL | Stock | 22.6107 | 22.6107 | 22.6107 | 22.6107 | 5600.0 |
| 2012-08-15 05:47:00 | AAPL | Stock | 22.6107 | 22.6107 | 22.6107 | 22.6107 | 8400.0 |
| 2012-08-15 05:57:00 | AAPL | Stock | 22.6107 | 22.6107 | 22.6107 | 22.6107 | 11200.0 |
| 2012-08-15 05:58:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.5893 | 22.5893 | 5600.0 |
| 2012-08-15 06:08:00 | AAPL | Stock | 22.5786 | 22.5786 | 22.5786 | 22.5786 | 2800.0 |
| 2012-08-15 06:15:00 | AAPL | Stock | 22.5679 | 22.5679 | 22.5679 | 22.5679 | 5600.0 |
| 2012-08-15 06:22:00 | AAPL | Stock | 22.5571 | 22.5571 | 22.5571 | 22.5571 | 2800.0 |
| 2012-08-15 06:25:00 | AAPL | Stock | 22.54 | 22.54 | 22.5393 | 22.5393 | 5600.0 |
| 2012-08-15 06:43:00 | AAPL | Stock | 22.5464 | 22.5464 | 22.5464 | 22.5464 | 4788.0 |
| 2012-08-15 06:45:00 | AAPL | Stock | 22.5714 | 22.5714 | 22.5714 | 22.5714 | 4200.0 |
| 2012-08-15 07:00:00 | AAPL | Stock | 22.5711 | 22.5714 | 22.5711 | 22.5714 | 21000.0 |
| 2012-08-15 07:01:00 | AAPL | Stock | 22.5714 | 22.5714 | 22.5714 | 22.5714 | 5600.0 |
| 2012-08-15 07:06:00 | AAPL | Stock | 22.5679 | 22.5679 | 22.5679 | 22.5679 | 2800.0 |
| 2012-08-15 07:07:00 | AAPL | Stock | 22.5629 | 22.5629 | 22.5629 | 22.5629 | 2800.0 |
| 2012-08-15 07:10:00 | AAPL | Stock | 22.5625 | 22.5625 | 22.5571 | 22.5571 | 8400.0 |
| 2012-08-15 07:14:00 | AAPL | Stock | 22.5354 | 22.5354 | 22.5354 | 22.5354 | 2800.0 |
| 2012-08-15 07:20:00 | AAPL | Stock | 22.5218 | 22.5218 | 22.5196 | 22.5196 | 11200.0 |
| 2012-08-15 07:23:00 | AAPL | Stock | 22.5221 | 22.5236 | 22.5221 | 22.5236 | 5600.0 |
| 2012-08-15 07:24:00 | AAPL | Stock | 22.5357 | 22.5357 | 22.5357 | 22.5357 | 2800.0 |
| 2012-08-15 07:26:00 | AAPL | Stock | 22.5429 | 22.5429 | 22.5429 | 22.5429 | 2800.0 |
| 2012-08-15 07:30:00 | AAPL | Stock | 22.5493 | 22.5493 | 22.5339 | 22.5339 | 16604.0 |
| 2012-08-15 07:33:00 | AAPL | Stock | 22.52 | 22.52 | 22.5118 | 22.5118 | 39200.0 |
| 2012-08-15 07:35:00 | AAPL | Stock | 22.5179 | 22.5179 | 22.5179 | 22.5179 | 12460.0 |
| 2012-08-15 07:36:00 | AAPL | Stock | 22.5207 | 22.5243 | 22.5125 | 22.5243 | 96040.0 |
| 2012-08-15 07:37:00 | AAPL | Stock | 22.5136 | 22.5357 | 22.5071 | 22.5071 | 127988.0 |
| 2012-08-15 07:43:00 | AAPL | Stock | 22.5118 | 22.5118 | 22.5089 | 22.5089 | 5600.0 |
| 2012-08-15 07:45:00 | AAPL | Stock | 22.5179 | 22.5179 | 22.5179 | 22.5179 | 8400.0 |
| 2012-08-15 07:47:00 | AAPL | Stock | 22.5161 | 22.5161 | 22.5161 | 22.5161 | 2800.0 |
| 2012-08-15 07:48:00 | AAPL | Stock | 22.5229 | 22.5232 | 22.5229 | 22.5232 | 22848.0 |
| 2012-08-15 07:52:00 | AAPL | Stock | 22.5325 | 22.5357 | 22.5325 | 22.5357 | 18788.0 |
| 2012-08-15 07:54:00 | AAPL | Stock | 22.5518 | 22.5614 | 22.5518 | 22.5614 | 47600.0 |
| 2012-08-15 07:58:00 | AAPL | Stock | 22.5439 | 22.5439 | 22.5439 | 22.5439 | 5600.0 |
| 2012-08-15 08:00:00 | AAPL | Stock | 22.5475 | 22.5546 | 22.5475 | 22.5546 | 5600.0 |
| 2012-08-15 08:02:00 | AAPL | Stock | 22.5529 | 22.5529 | 22.5529 | 22.5529 | 2800.0 |
| 2012-08-15 08:03:00 | AAPL | Stock | 22.54 | 22.5464 | 22.5357 | 22.5429 | 14756.0 |
| 2012-08-15 08:06:00 | AAPL | Stock | 22.5514 | 22.5514 | 22.5514 | 22.5514 | 2800.0 |
| 2012-08-15 08:09:00 | AAPL | Stock | 22.5454 | 22.5454 | 22.5454 | 22.5454 | 2800.0 |
| 2012-08-15 08:10:00 | AAPL | Stock | 22.5482 | 22.5482 | 22.5446 | 22.5446 | 14392.0 |
| 2012-08-15 08:12:00 | AAPL | Stock | 22.5493 | 22.5571 | 22.5493 | 22.5571 | 44520.0 |
| 2012-08-15 08:13:00 | AAPL | Stock | 22.5675 | 22.5725 | 22.5675 | 22.5725 | 36400.0 |
| 2012-08-15 08:14:00 | AAPL | Stock | 22.5775 | 22.5775 | 22.5264 | 22.5264 | 58800.0 |
| 2012-08-15 08:15:00 | AAPL | Stock | 22.5836 | 22.5839 | 22.5743 | 22.5821 | 14000.0 |
> showing 50 of 871,046 rows — these rows as CSV