PREVIEW / stock_1min / 2011-09-08
file: by_date/stock_1min/2011/2011-09-08.parquet size: 13.2 MB rows: 994,610 symbols: 2,834
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-08 05:48:00 | AAPL | Stock | 13.7679 | 13.7679 | 13.7679 | 13.7679 | 8400.0 |
| 2011-09-08 05:49:00 | AAPL | Stock | 13.7679 | 13.7679 | 13.7679 | 13.7679 | 5600.0 |
| 2011-09-08 05:59:00 | AAPL | Stock | 13.7571 | 13.7571 | 13.7571 | 13.7571 | 2800.0 |
| 2011-09-08 06:02:00 | AAPL | Stock | 13.75 | 13.75 | 13.75 | 13.75 | 11200.0 |
| 2011-09-08 06:21:00 | AAPL | Stock | 13.7679 | 13.7732 | 13.7679 | 13.7732 | 47600.0 |
| 2011-09-08 06:22:00 | AAPL | Stock | 13.7789 | 13.7821 | 13.7789 | 13.7821 | 33600.0 |
| 2011-09-08 06:23:00 | AAPL | Stock | 13.7732 | 13.7732 | 13.7732 | 13.7732 | 2800.0 |
| 2011-09-08 06:24:00 | AAPL | Stock | 13.7732 | 13.7732 | 13.7732 | 13.7732 | 11200.0 |
| 2011-09-08 06:26:00 | AAPL | Stock | 13.7732 | 13.7839 | 13.7732 | 13.7839 | 5600.0 |
| 2011-09-08 06:30:00 | AAPL | Stock | 13.7857 | 13.7857 | 13.7857 | 13.7857 | 2800.0 |
| 2011-09-08 06:39:00 | AAPL | Stock | 13.775 | 13.775 | 13.775 | 13.775 | 2800.0 |
| 2011-09-08 07:01:00 | AAPL | Stock | 13.7607 | 13.7607 | 13.7607 | 13.7607 | 2800.0 |
| 2011-09-08 07:03:00 | AAPL | Stock | 13.7661 | 13.7661 | 13.7607 | 13.7607 | 14000.0 |
| 2011-09-08 07:04:00 | AAPL | Stock | 13.7675 | 13.7768 | 13.7675 | 13.7768 | 33320.0 |
| 2011-09-08 07:08:00 | AAPL | Stock | 13.7764 | 13.7764 | 13.7764 | 13.7764 | 2800.0 |
| 2011-09-08 07:10:00 | AAPL | Stock | 13.7804 | 13.7804 | 13.7804 | 13.7804 | 2800.0 |
| 2011-09-08 07:11:00 | AAPL | Stock | 13.7696 | 13.7696 | 13.7696 | 13.7696 | 6384.0 |
| 2011-09-08 07:13:00 | AAPL | Stock | 13.7682 | 13.7682 | 13.7679 | 13.7679 | 8400.0 |
| 2011-09-08 07:15:00 | AAPL | Stock | 13.7675 | 13.7857 | 13.7675 | 13.7857 | 64624.0 |
| 2011-09-08 07:16:00 | AAPL | Stock | 13.7854 | 13.7854 | 13.7789 | 13.7821 | 36400.0 |
| 2011-09-08 07:18:00 | AAPL | Stock | 13.7743 | 13.7743 | 13.7732 | 13.7732 | 8400.0 |
| 2011-09-08 07:20:00 | AAPL | Stock | 13.7736 | 13.7736 | 13.7736 | 13.7736 | 2800.0 |
| 2011-09-08 07:21:00 | AAPL | Stock | 13.7693 | 13.7693 | 13.7679 | 13.7682 | 18200.0 |
| 2011-09-08 07:22:00 | AAPL | Stock | 13.7804 | 13.7811 | 13.7804 | 13.7811 | 14000.0 |
| 2011-09-08 07:23:00 | AAPL | Stock | 13.7689 | 13.7768 | 13.7689 | 13.7768 | 5600.0 |
| 2011-09-08 07:26:00 | AAPL | Stock | 13.7686 | 13.7686 | 13.7643 | 13.7643 | 148120.0 |
| 2011-09-08 07:28:00 | AAPL | Stock | 13.7625 | 13.7625 | 13.7625 | 13.7625 | 2800.0 |
| 2011-09-08 07:31:00 | AAPL | Stock | 13.7604 | 13.7657 | 13.7604 | 13.7657 | 22400.0 |
| 2011-09-08 07:32:00 | AAPL | Stock | 13.7714 | 13.7714 | 13.7714 | 13.7714 | 2800.0 |
| 2011-09-08 07:34:00 | AAPL | Stock | 13.7593 | 13.7593 | 13.7593 | 13.7593 | 28000.0 |
| 2011-09-08 07:40:00 | AAPL | Stock | 13.7646 | 13.7646 | 13.7646 | 13.7646 | 4200.0 |
| 2011-09-08 07:42:00 | AAPL | Stock | 13.7618 | 13.7618 | 13.7618 | 13.7618 | 2800.0 |
| 2011-09-08 07:45:00 | AAPL | Stock | 13.7646 | 13.765 | 13.7543 | 13.7543 | 40460.0 |
| 2011-09-08 07:46:00 | AAPL | Stock | 13.7507 | 13.7507 | 13.75 | 13.75 | 14000.0 |
| 2011-09-08 07:48:00 | AAPL | Stock | 13.73 | 13.73 | 13.73 | 13.73 | 5600.0 |
| 2011-09-08 07:49:00 | AAPL | Stock | 13.7289 | 13.7289 | 13.715 | 13.7186 | 23800.0 |
| 2011-09-08 07:50:00 | AAPL | Stock | 13.7107 | 13.7186 | 13.7096 | 13.7186 | 81340.0 |
| 2011-09-08 07:51:00 | AAPL | Stock | 13.7146 | 13.7146 | 13.7146 | 13.7146 | 2800.0 |
| 2011-09-08 07:52:00 | AAPL | Stock | 13.7154 | 13.7261 | 13.7143 | 13.7261 | 11200.0 |
| 2011-09-08 07:53:00 | AAPL | Stock | 13.7146 | 13.7286 | 13.7146 | 13.7286 | 8400.0 |
| 2011-09-08 07:55:00 | AAPL | Stock | 13.7232 | 13.7364 | 13.7232 | 13.7364 | 25060.0 |
| 2011-09-08 07:56:00 | AAPL | Stock | 13.7271 | 13.7271 | 13.715 | 13.715 | 19600.0 |
| 2011-09-08 07:57:00 | AAPL | Stock | 13.715 | 13.7154 | 13.7143 | 13.715 | 16800.0 |
| 2011-09-08 07:58:00 | AAPL | Stock | 13.7146 | 13.7146 | 13.71 | 13.71 | 22400.0 |
| 2011-09-08 07:59:00 | AAPL | Stock | 13.7143 | 13.7143 | 13.7136 | 13.7136 | 5600.0 |
| 2011-09-08 08:00:00 | AAPL | Stock | 13.7143 | 13.7229 | 13.7071 | 13.7104 | 142408.0 |
| 2011-09-08 08:01:00 | AAPL | Stock | 13.7082 | 13.7096 | 13.7036 | 13.7096 | 56224.0 |
| 2011-09-08 08:02:00 | AAPL | Stock | 13.7118 | 13.7129 | 13.7064 | 13.7129 | 25200.0 |
| 2011-09-08 08:03:00 | AAPL | Stock | 13.7071 | 13.7071 | 13.7071 | 13.7071 | 5600.0 |
| 2011-09-08 08:04:00 | AAPL | Stock | 13.7054 | 13.7071 | 13.7043 | 13.7071 | 22400.0 |
> showing 50 of 994,610 rows — these rows as CSV