PREVIEW / stock_1min / 2013-05-07
file: by_date/stock_1min/2013/2013-05-07.parquet size: 13.4 MB rows: 980,872 symbols: 2,838
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-05-07 04:00:00 | AAPL | Stock | 16.5239 | 16.5239 | 16.5239 | 16.5239 | 14000.0 |
| 2013-05-07 04:01:00 | AAPL | Stock | 16.5239 | 16.5239 | 16.5239 | 16.5239 | 2800.0 |
| 2013-05-07 04:14:00 | AAPL | Stock | 16.5179 | 16.5179 | 16.5179 | 16.5179 | 11508.0 |
| 2013-05-07 04:24:00 | AAPL | Stock | 16.5118 | 16.5118 | 16.5118 | 16.5118 | 2800.0 |
| 2013-05-07 04:27:00 | AAPL | Stock | 16.5118 | 16.5118 | 16.5118 | 16.5118 | 2800.0 |
| 2013-05-07 04:32:00 | AAPL | Stock | 16.5239 | 16.5239 | 16.5239 | 16.5239 | 5600.0 |
| 2013-05-07 04:36:00 | AAPL | Stock | 16.5175 | 16.5175 | 16.5175 | 16.5175 | 5236.0 |
| 2013-05-07 04:46:00 | AAPL | Stock | 16.5239 | 16.5239 | 16.5239 | 16.5239 | 3332.0 |
| 2013-05-07 04:47:00 | AAPL | Stock | 16.5007 | 16.5007 | 16.4957 | 16.4957 | 6132.0 |
| 2013-05-07 04:49:00 | AAPL | Stock | 16.5071 | 16.5071 | 16.5071 | 16.5071 | 4200.0 |
| 2013-05-07 05:27:00 | AAPL | Stock | 16.5139 | 16.5139 | 16.5139 | 16.5139 | 2800.0 |
| 2013-05-07 05:30:00 | AAPL | Stock | 16.5143 | 16.5168 | 16.5143 | 16.5168 | 8400.0 |
| 2013-05-07 06:12:00 | AAPL | Stock | 16.5232 | 16.5232 | 16.5232 | 16.5232 | 5600.0 |
| 2013-05-07 06:17:00 | AAPL | Stock | 16.52 | 16.52 | 16.52 | 16.52 | 2800.0 |
| 2013-05-07 06:18:00 | AAPL | Stock | 16.5396 | 16.5396 | 16.5396 | 16.5396 | 3472.0 |
| 2013-05-07 06:23:00 | AAPL | Stock | 16.5475 | 16.5475 | 16.5475 | 16.5475 | 3780.0 |
| 2013-05-07 06:27:00 | AAPL | Stock | 16.5379 | 16.5379 | 16.5379 | 16.5379 | 2800.0 |
| 2013-05-07 06:31:00 | AAPL | Stock | 16.5443 | 16.5443 | 16.5443 | 16.5443 | 2800.0 |
| 2013-05-07 06:32:00 | AAPL | Stock | 16.5496 | 16.5496 | 16.5496 | 16.5496 | 2800.0 |
| 2013-05-07 06:52:00 | AAPL | Stock | 16.5379 | 16.5379 | 16.5379 | 16.5379 | 2800.0 |
| 2013-05-07 06:56:00 | AAPL | Stock | 16.5232 | 16.5232 | 16.5232 | 16.5232 | 2800.0 |
| 2013-05-07 07:00:00 | AAPL | Stock | 16.5232 | 16.5232 | 16.5229 | 16.5229 | 13020.0 |
| 2013-05-07 07:01:00 | AAPL | Stock | 16.5261 | 16.5261 | 16.5229 | 16.5229 | 22176.0 |
| 2013-05-07 07:02:00 | AAPL | Stock | 16.5257 | 16.5393 | 16.5257 | 16.5393 | 28000.0 |
| 2013-05-07 07:03:00 | AAPL | Stock | 16.5393 | 16.5393 | 16.5393 | 16.5393 | 2800.0 |
| 2013-05-07 07:04:00 | AAPL | Stock | 16.5446 | 16.5518 | 16.5411 | 16.5518 | 37800.0 |
| 2013-05-07 07:05:00 | AAPL | Stock | 16.5629 | 16.5629 | 16.5629 | 16.5629 | 5600.0 |
| 2013-05-07 07:06:00 | AAPL | Stock | 16.5554 | 16.5671 | 16.5554 | 16.5671 | 17920.0 |
| 2013-05-07 07:07:00 | AAPL | Stock | 16.5618 | 16.5679 | 16.5536 | 16.5671 | 22400.0 |
| 2013-05-07 07:08:00 | AAPL | Stock | 16.5686 | 16.5743 | 16.5675 | 16.5743 | 56000.0 |
| 2013-05-07 07:09:00 | AAPL | Stock | 16.5714 | 16.575 | 16.5714 | 16.575 | 19600.0 |
| 2013-05-07 07:10:00 | AAPL | Stock | 16.5804 | 16.5857 | 16.5804 | 16.5857 | 25200.0 |
| 2013-05-07 07:11:00 | AAPL | Stock | 16.5821 | 16.5821 | 16.5818 | 16.5821 | 15876.0 |
| 2013-05-07 07:12:00 | AAPL | Stock | 16.5893 | 16.5896 | 16.5893 | 16.5893 | 15400.0 |
| 2013-05-07 07:13:00 | AAPL | Stock | 16.59 | 16.59 | 16.59 | 16.59 | 2800.0 |
| 2013-05-07 07:14:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5821 | 16.5836 | 17584.0 |
| 2013-05-07 07:15:00 | AAPL | Stock | 16.5768 | 16.5964 | 16.5768 | 16.5964 | 20440.0 |
| 2013-05-07 07:16:00 | AAPL | Stock | 16.5964 | 16.5964 | 16.5964 | 16.5964 | 5600.0 |
| 2013-05-07 07:17:00 | AAPL | Stock | 16.5896 | 16.5896 | 16.5896 | 16.5896 | 2800.0 |
| 2013-05-07 07:18:00 | AAPL | Stock | 16.5896 | 16.5896 | 16.5896 | 16.5896 | 2800.0 |
| 2013-05-07 07:19:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5893 | 16.5893 | 16800.0 |
| 2013-05-07 07:20:00 | AAPL | Stock | 16.58 | 16.5929 | 16.58 | 16.5929 | 29512.0 |
| 2013-05-07 07:21:00 | AAPL | Stock | 16.5932 | 16.5964 | 16.5929 | 16.5929 | 16800.0 |
| 2013-05-07 07:25:00 | AAPL | Stock | 16.5964 | 16.6071 | 16.5964 | 16.605 | 36848.0 |
| 2013-05-07 07:26:00 | AAPL | Stock | 16.5964 | 16.5964 | 16.5893 | 16.5893 | 12712.0 |
| 2013-05-07 07:27:00 | AAPL | Stock | 16.5893 | 16.5964 | 16.5893 | 16.5964 | 8400.0 |
| 2013-05-07 07:30:00 | AAPL | Stock | 16.5954 | 16.5954 | 16.5954 | 16.5954 | 2800.0 |
| 2013-05-07 07:31:00 | AAPL | Stock | 16.5854 | 16.5864 | 16.5846 | 16.5864 | 19348.0 |
| 2013-05-07 07:34:00 | AAPL | Stock | 16.5779 | 16.5782 | 16.5643 | 16.5643 | 75628.0 |
| 2013-05-07 07:35:00 | AAPL | Stock | 16.5536 | 16.5661 | 16.5536 | 16.5661 | 38556.0 |
> showing 50 of 980,872 rows — these rows as CSV