PREVIEW / stock_1min / 2012-07-26
file: by_date/stock_1min/2012/2012-07-26.parquet size: 12.6 MB rows: 936,441 symbols: 2,824
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-07-26 04:00:00 | AAPL | Stock | 20.6071 | 20.6071 | 20.6071 | 20.6071 | 5600.0 |
| 2012-07-26 04:01:00 | AAPL | Stock | 20.6071 | 20.6071 | 20.6071 | 20.6071 | 2800.0 |
| 2012-07-26 04:02:00 | AAPL | Stock | 20.6071 | 20.6071 | 20.6071 | 20.6071 | 8400.0 |
| 2012-07-26 04:03:00 | AAPL | Stock | 20.6071 | 20.6071 | 20.6071 | 20.6071 | 28980.0 |
| 2012-07-26 04:05:00 | AAPL | Stock | 20.6071 | 20.6071 | 20.6071 | 20.6071 | 2800.0 |
| 2012-07-26 04:06:00 | AAPL | Stock | 20.6071 | 20.6071 | 20.6071 | 20.6071 | 5600.0 |
| 2012-07-26 04:07:00 | AAPL | Stock | 20.5786 | 20.5786 | 20.5643 | 20.5643 | 16800.0 |
| 2012-07-26 04:10:00 | AAPL | Stock | 20.5643 | 20.5643 | 20.5643 | 20.5643 | 2800.0 |
| 2012-07-26 04:13:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.5536 | 20.5536 | 5600.0 |
| 2012-07-26 04:14:00 | AAPL | Stock | 20.5539 | 20.5539 | 20.5539 | 20.5539 | 2800.0 |
| 2012-07-26 04:16:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.5536 | 20.5536 | 2800.0 |
| 2012-07-26 04:35:00 | AAPL | Stock | 20.5714 | 20.5714 | 20.5714 | 20.5714 | 2800.0 |
| 2012-07-26 05:07:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.5536 | 20.5536 | 2800.0 |
| 2012-07-26 05:43:00 | AAPL | Stock | 20.5646 | 20.5646 | 20.5646 | 20.5646 | 8400.0 |
| 2012-07-26 05:55:00 | AAPL | Stock | 20.5607 | 20.5607 | 20.5607 | 20.5607 | 30800.0 |
| 2012-07-26 05:57:00 | AAPL | Stock | 20.55 | 20.55 | 20.55 | 20.55 | 2800.0 |
| 2012-07-26 05:58:00 | AAPL | Stock | 20.5432 | 20.5432 | 20.5432 | 20.5432 | 2800.0 |
| 2012-07-26 06:09:00 | AAPL | Stock | 20.5411 | 20.5411 | 20.5411 | 20.5411 | 5600.0 |
| 2012-07-26 06:10:00 | AAPL | Stock | 20.5586 | 20.5607 | 20.5429 | 20.5607 | 19740.0 |
| 2012-07-26 06:11:00 | AAPL | Stock | 20.5607 | 20.5607 | 20.5607 | 20.5607 | 8400.0 |
| 2012-07-26 06:12:00 | AAPL | Stock | 20.5607 | 20.5646 | 20.5607 | 20.5646 | 6328.0 |
| 2012-07-26 06:13:00 | AAPL | Stock | 20.5646 | 20.5646 | 20.5646 | 20.5646 | 2800.0 |
| 2012-07-26 06:15:00 | AAPL | Stock | 20.5646 | 20.5646 | 20.5646 | 20.5646 | 2800.0 |
| 2012-07-26 06:16:00 | AAPL | Stock | 20.5646 | 20.5646 | 20.5646 | 20.5646 | 11200.0 |
| 2012-07-26 06:17:00 | AAPL | Stock | 20.5707 | 20.5707 | 20.5707 | 20.5707 | 11200.0 |
| 2012-07-26 06:19:00 | AAPL | Stock | 20.5707 | 20.5711 | 20.5707 | 20.5711 | 19320.0 |
| 2012-07-26 06:23:00 | AAPL | Stock | 20.5893 | 20.5893 | 20.5893 | 20.5893 | 2800.0 |
| 2012-07-26 06:24:00 | AAPL | Stock | 20.6071 | 20.6071 | 20.6071 | 20.6071 | 50008.0 |
| 2012-07-26 06:26:00 | AAPL | Stock | 20.6071 | 20.6071 | 20.6071 | 20.6071 | 5600.0 |
| 2012-07-26 06:30:00 | AAPL | Stock | 20.6057 | 20.6057 | 20.6057 | 20.6057 | 2800.0 |
| 2012-07-26 06:36:00 | AAPL | Stock | 20.6071 | 20.6161 | 20.6071 | 20.6161 | 5600.0 |
| 2012-07-26 06:43:00 | AAPL | Stock | 20.6571 | 20.6571 | 20.6571 | 20.6571 | 6720.0 |
| 2012-07-26 06:46:00 | AAPL | Stock | 20.6379 | 20.6379 | 20.625 | 20.625 | 5600.0 |
| 2012-07-26 06:47:00 | AAPL | Stock | 20.625 | 20.625 | 20.625 | 20.625 | 14952.0 |
| 2012-07-26 06:48:00 | AAPL | Stock | 20.625 | 20.625 | 20.625 | 20.625 | 8400.0 |
| 2012-07-26 06:49:00 | AAPL | Stock | 20.625 | 20.625 | 20.625 | 20.625 | 2800.0 |
| 2012-07-26 06:52:00 | AAPL | Stock | 20.625 | 20.625 | 20.625 | 20.625 | 5600.0 |
| 2012-07-26 06:54:00 | AAPL | Stock | 20.6093 | 20.625 | 20.6093 | 20.625 | 8400.0 |
| 2012-07-26 06:55:00 | AAPL | Stock | 20.625 | 20.625 | 20.625 | 20.625 | 15400.0 |
| 2012-07-26 07:00:00 | AAPL | Stock | 20.625 | 20.625 | 20.625 | 20.625 | 2800.0 |
| 2012-07-26 07:01:00 | AAPL | Stock | 20.625 | 20.625 | 20.625 | 20.625 | 8400.0 |
| 2012-07-26 07:02:00 | AAPL | Stock | 20.6429 | 20.6429 | 20.6429 | 20.6429 | 23800.0 |
| 2012-07-26 07:04:00 | AAPL | Stock | 20.6571 | 20.6779 | 20.6571 | 20.6779 | 26320.0 |
| 2012-07-26 07:05:00 | AAPL | Stock | 20.6768 | 20.7143 | 20.6764 | 20.7143 | 147000.0 |
| 2012-07-26 07:06:00 | AAPL | Stock | 20.7143 | 20.7143 | 20.7139 | 20.7143 | 16800.0 |
| 2012-07-26 07:07:00 | AAPL | Stock | 20.7143 | 20.7221 | 20.6875 | 20.7211 | 75180.0 |
| 2012-07-26 07:08:00 | AAPL | Stock | 20.7143 | 20.7179 | 20.6882 | 20.6882 | 49980.0 |
| 2012-07-26 07:09:00 | AAPL | Stock | 20.7107 | 20.7132 | 20.7039 | 20.7039 | 42000.0 |
| 2012-07-26 07:10:00 | AAPL | Stock | 20.7039 | 20.7121 | 20.6786 | 20.6786 | 79100.0 |
| 2012-07-26 07:11:00 | AAPL | Stock | 20.6704 | 20.6704 | 20.6593 | 20.6593 | 32200.0 |
> showing 50 of 936,441 rows — these rows as CSV