PREVIEW / stock_1min / 2012-09-25
file: by_date/stock_1min/2012/2012-09-25.parquet size: 13.3 MB rows: 976,448 symbols: 2,830
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-09-25 04:00:00 | AAPL | Stock | 24.5625 | 24.5893 | 24.5625 | 24.5893 | 286272.0 |
| 2012-09-25 04:01:00 | AAPL | Stock | 24.5768 | 24.5768 | 24.5539 | 24.5539 | 134400.0 |
| 2012-09-25 04:02:00 | AAPL | Stock | 24.5857 | 24.5857 | 24.5857 | 24.5857 | 5600.0 |
| 2012-09-25 04:03:00 | AAPL | Stock | 24.575 | 24.575 | 24.5714 | 24.5714 | 8400.0 |
| 2012-09-25 04:04:00 | AAPL | Stock | 24.575 | 24.575 | 24.575 | 24.575 | 2800.0 |
| 2012-09-25 04:19:00 | AAPL | Stock | 24.5718 | 24.5718 | 24.5718 | 24.5718 | 2800.0 |
| 2012-09-25 04:34:00 | AAPL | Stock | 24.5464 | 24.5464 | 24.5464 | 24.5464 | 11200.0 |
| 2012-09-25 04:37:00 | AAPL | Stock | 24.5536 | 24.5536 | 24.5536 | 24.5536 | 14000.0 |
| 2012-09-25 04:39:00 | AAPL | Stock | 24.5536 | 24.5536 | 24.5536 | 24.5536 | 14000.0 |
| 2012-09-25 04:45:00 | AAPL | Stock | 24.5571 | 24.5571 | 24.5571 | 24.5571 | 2800.0 |
| 2012-09-25 04:47:00 | AAPL | Stock | 24.5679 | 24.5679 | 24.5679 | 24.5679 | 2800.0 |
| 2012-09-25 05:49:00 | AAPL | Stock | 24.515 | 24.5161 | 24.515 | 24.5161 | 16800.0 |
| 2012-09-25 06:01:00 | AAPL | Stock | 24.5357 | 24.5357 | 24.5357 | 24.5357 | 11200.0 |
| 2012-09-25 06:02:00 | AAPL | Stock | 24.5357 | 24.5357 | 24.5357 | 24.5357 | 2800.0 |
| 2012-09-25 06:03:00 | AAPL | Stock | 24.5357 | 24.5357 | 24.5357 | 24.5357 | 5600.0 |
| 2012-09-25 06:04:00 | AAPL | Stock | 24.5357 | 24.5357 | 24.5357 | 24.5357 | 8260.0 |
| 2012-09-25 06:14:00 | AAPL | Stock | 24.5629 | 24.5679 | 24.5629 | 24.5679 | 12740.0 |
| 2012-09-25 06:16:00 | AAPL | Stock | 24.5679 | 24.5679 | 24.5679 | 24.5679 | 5600.0 |
| 2012-09-25 06:25:00 | AAPL | Stock | 24.5679 | 24.5679 | 24.5679 | 24.5679 | 2800.0 |
| 2012-09-25 06:43:00 | AAPL | Stock | 24.5675 | 24.5714 | 24.5675 | 24.5714 | 36400.0 |
| 2012-09-25 07:00:00 | AAPL | Stock | 24.5714 | 24.5714 | 24.5714 | 24.5714 | 11200.0 |
| 2012-09-25 07:01:00 | AAPL | Stock | 24.5714 | 24.5714 | 24.5357 | 24.5357 | 50400.0 |
| 2012-09-25 07:05:00 | AAPL | Stock | 24.5446 | 24.5446 | 24.5357 | 24.5357 | 14000.0 |
| 2012-09-25 07:06:00 | AAPL | Stock | 24.5293 | 24.5293 | 24.5264 | 24.5275 | 47600.0 |
| 2012-09-25 07:10:00 | AAPL | Stock | 24.5143 | 24.5179 | 24.5143 | 24.5179 | 16800.0 |
| 2012-09-25 07:11:00 | AAPL | Stock | 24.5321 | 24.5321 | 24.5311 | 24.5311 | 8400.0 |
| 2012-09-25 07:12:00 | AAPL | Stock | 24.5321 | 24.5454 | 24.5321 | 24.5357 | 44800.0 |
| 2012-09-25 07:13:00 | AAPL | Stock | 24.5461 | 24.5461 | 24.5461 | 24.5461 | 8092.0 |
| 2012-09-25 07:14:00 | AAPL | Stock | 24.545 | 24.545 | 24.545 | 24.545 | 2800.0 |
| 2012-09-25 07:16:00 | AAPL | Stock | 24.545 | 24.545 | 24.5411 | 24.5411 | 5600.0 |
| 2012-09-25 07:17:00 | AAPL | Stock | 24.5443 | 24.5504 | 24.5443 | 24.5504 | 11200.0 |
| 2012-09-25 07:18:00 | AAPL | Stock | 24.55 | 24.5564 | 24.55 | 24.5564 | 11200.0 |
| 2012-09-25 07:19:00 | AAPL | Stock | 24.5564 | 24.56 | 24.5564 | 24.56 | 5600.0 |
| 2012-09-25 07:20:00 | AAPL | Stock | 24.5661 | 24.5714 | 24.5661 | 24.5714 | 30800.0 |
| 2012-09-25 07:21:00 | AAPL | Stock | 24.5804 | 24.5825 | 24.5804 | 24.5825 | 8708.0 |
| 2012-09-25 07:23:00 | AAPL | Stock | 24.5893 | 24.5893 | 24.5786 | 24.5786 | 14196.0 |
| 2012-09-25 07:24:00 | AAPL | Stock | 24.5825 | 24.5825 | 24.5821 | 24.5821 | 5600.0 |
| 2012-09-25 07:25:00 | AAPL | Stock | 24.5811 | 24.5811 | 24.5714 | 24.5714 | 15120.0 |
| 2012-09-25 07:26:00 | AAPL | Stock | 24.5714 | 24.5714 | 24.5714 | 24.5714 | 5600.0 |
| 2012-09-25 07:27:00 | AAPL | Stock | 24.5657 | 24.5657 | 24.5657 | 24.5657 | 28000.0 |
| 2012-09-25 07:30:00 | AAPL | Stock | 24.5804 | 24.5821 | 24.5804 | 24.5821 | 33600.0 |
| 2012-09-25 07:31:00 | AAPL | Stock | 24.5854 | 24.5854 | 24.5854 | 24.5854 | 14000.0 |
| 2012-09-25 07:33:00 | AAPL | Stock | 24.5839 | 24.5839 | 24.5839 | 24.5839 | 5600.0 |
| 2012-09-25 07:36:00 | AAPL | Stock | 24.5771 | 24.5771 | 24.5768 | 24.5768 | 5600.0 |
| 2012-09-25 07:38:00 | AAPL | Stock | 24.5679 | 24.5679 | 24.5679 | 24.5679 | 14000.0 |
| 2012-09-25 07:40:00 | AAPL | Stock | 24.5707 | 24.5707 | 24.5707 | 24.5707 | 2800.0 |
| 2012-09-25 07:42:00 | AAPL | Stock | 24.5554 | 24.5554 | 24.5554 | 24.5554 | 2800.0 |
| 2012-09-25 07:44:00 | AAPL | Stock | 24.5536 | 24.5536 | 24.5446 | 24.5446 | 5600.0 |
| 2012-09-25 07:45:00 | AAPL | Stock | 24.5446 | 24.5446 | 24.5357 | 24.5357 | 19600.0 |
| 2012-09-25 07:46:00 | AAPL | Stock | 24.5307 | 24.5307 | 24.5282 | 24.5282 | 28000.0 |
> showing 50 of 976,448 rows — these rows as CSV