PREVIEW / stock_1min / 2012-08-17
file: by_date/stock_1min/2012/2012-08-17.parquet size: 11.7 MB rows: 878,166 symbols: 2,808
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-17 04:13:00 | AAPL | Stock | 22.7214 | 22.7214 | 22.7214 | 22.7214 | 2800.0 |
| 2012-08-17 04:26:00 | AAPL | Stock | 22.7214 | 22.7214 | 22.7214 | 22.7214 | 2800.0 |
| 2012-08-17 04:29:00 | AAPL | Stock | 22.7214 | 22.7214 | 22.7214 | 22.7214 | 5600.0 |
| 2012-08-17 04:36:00 | AAPL | Stock | 22.7214 | 22.7214 | 22.7214 | 22.7214 | 11200.0 |
| 2012-08-17 04:37:00 | AAPL | Stock | 22.7214 | 22.7214 | 22.7214 | 22.7214 | 2800.0 |
| 2012-08-17 04:39:00 | AAPL | Stock | 22.7214 | 22.7214 | 22.7214 | 22.7214 | 2800.0 |
| 2012-08-17 05:15:00 | AAPL | Stock | 22.7507 | 22.7507 | 22.7507 | 22.7507 | 8400.0 |
| 2012-08-17 05:22:00 | AAPL | Stock | 22.7493 | 22.7657 | 22.7493 | 22.7657 | 5600.0 |
| 2012-08-17 05:23:00 | AAPL | Stock | 22.7657 | 22.7657 | 22.7657 | 22.7657 | 2800.0 |
| 2012-08-17 05:24:00 | AAPL | Stock | 22.7657 | 22.7657 | 22.7657 | 22.7657 | 14000.0 |
| 2012-08-17 05:26:00 | AAPL | Stock | 22.7657 | 22.7657 | 22.7657 | 22.7657 | 2800.0 |
| 2012-08-17 05:29:00 | AAPL | Stock | 22.7657 | 22.7657 | 22.7589 | 22.7589 | 5600.0 |
| 2012-08-17 05:31:00 | AAPL | Stock | 22.7589 | 22.7589 | 22.7589 | 22.7589 | 26040.0 |
| 2012-08-17 05:32:00 | AAPL | Stock | 22.7657 | 22.7657 | 22.7657 | 22.7657 | 2800.0 |
| 2012-08-17 05:34:00 | AAPL | Stock | 22.7657 | 22.7657 | 22.7657 | 22.7657 | 12600.0 |
| 2012-08-17 05:36:00 | AAPL | Stock | 22.7836 | 22.7836 | 22.7836 | 22.7836 | 2800.0 |
| 2012-08-17 05:38:00 | AAPL | Stock | 22.7839 | 22.7839 | 22.7839 | 22.7839 | 5600.0 |
| 2012-08-17 05:39:00 | AAPL | Stock | 22.7839 | 22.7843 | 22.7839 | 22.7843 | 36400.0 |
| 2012-08-17 05:40:00 | AAPL | Stock | 22.7843 | 22.7843 | 22.7843 | 22.7843 | 5600.0 |
| 2012-08-17 05:42:00 | AAPL | Stock | 22.7843 | 22.7843 | 22.7843 | 22.7843 | 11200.0 |
| 2012-08-17 05:44:00 | AAPL | Stock | 22.7661 | 22.7661 | 22.7657 | 22.7657 | 13440.0 |
| 2012-08-17 05:45:00 | AAPL | Stock | 22.7843 | 22.7843 | 22.7843 | 22.7843 | 5600.0 |
| 2012-08-17 05:47:00 | AAPL | Stock | 22.7657 | 22.7657 | 22.7657 | 22.7657 | 2800.0 |
| 2012-08-17 05:48:00 | AAPL | Stock | 22.7596 | 22.7596 | 22.7596 | 22.7596 | 2800.0 |
| 2012-08-17 05:53:00 | AAPL | Stock | 22.7643 | 22.7643 | 22.7643 | 22.7643 | 8400.0 |
| 2012-08-17 05:54:00 | AAPL | Stock | 22.7643 | 22.7643 | 22.7643 | 22.7643 | 2800.0 |
| 2012-08-17 06:12:00 | AAPL | Stock | 22.7843 | 22.7843 | 22.7843 | 22.7843 | 2800.0 |
| 2012-08-17 06:14:00 | AAPL | Stock | 22.7843 | 22.7843 | 22.7843 | 22.7843 | 2800.0 |
| 2012-08-17 06:18:00 | AAPL | Stock | 22.7843 | 22.7843 | 22.7843 | 22.7843 | 2800.0 |
| 2012-08-17 06:19:00 | AAPL | Stock | 22.7939 | 22.7939 | 22.7939 | 22.7939 | 2800.0 |
| 2012-08-17 06:25:00 | AAPL | Stock | 22.7911 | 22.7943 | 22.7911 | 22.7943 | 5880.0 |
| 2012-08-17 06:26:00 | AAPL | Stock | 22.7943 | 22.7943 | 22.7943 | 22.7943 | 5600.0 |
| 2012-08-17 06:38:00 | AAPL | Stock | 22.8118 | 22.8118 | 22.8118 | 22.8118 | 5600.0 |
| 2012-08-17 06:39:00 | AAPL | Stock | 22.8118 | 22.8118 | 22.8118 | 22.8118 | 5600.0 |
| 2012-08-17 07:00:00 | AAPL | Stock | 22.7911 | 22.7911 | 22.7911 | 22.7911 | 3892.0 |
| 2012-08-17 07:02:00 | AAPL | Stock | 22.7964 | 22.7964 | 22.7911 | 22.7911 | 29680.0 |
| 2012-08-17 07:03:00 | AAPL | Stock | 22.7893 | 22.7893 | 22.7893 | 22.7893 | 25200.0 |
| 2012-08-17 07:04:00 | AAPL | Stock | 22.7911 | 22.7911 | 22.7911 | 22.7911 | 2800.0 |
| 2012-08-17 07:05:00 | AAPL | Stock | 22.7911 | 22.7911 | 22.7911 | 22.7911 | 5600.0 |
| 2012-08-17 07:06:00 | AAPL | Stock | 22.7804 | 22.7804 | 22.7804 | 22.7804 | 42000.0 |
| 2012-08-17 07:08:00 | AAPL | Stock | 22.7804 | 22.7804 | 22.7804 | 22.7804 | 5600.0 |
| 2012-08-17 07:11:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 26460.0 |
| 2012-08-17 07:13:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 2800.0 |
| 2012-08-17 07:17:00 | AAPL | Stock | 22.775 | 22.7804 | 22.775 | 22.7804 | 13916.0 |
| 2012-08-17 07:20:00 | AAPL | Stock | 22.79 | 22.7911 | 22.79 | 22.7911 | 26992.0 |
| 2012-08-17 07:23:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 11200.0 |
| 2012-08-17 07:25:00 | AAPL | Stock | 22.7839 | 22.7857 | 22.7839 | 22.7857 | 20944.0 |
| 2012-08-17 07:28:00 | AAPL | Stock | 22.7854 | 22.7854 | 22.7854 | 22.7854 | 14000.0 |
| 2012-08-17 07:32:00 | AAPL | Stock | 22.7821 | 22.7821 | 22.7818 | 22.7821 | 11200.0 |
| 2012-08-17 07:33:00 | AAPL | Stock | 22.7818 | 22.7818 | 22.7818 | 22.7818 | 4060.0 |
> showing 50 of 878,166 rows — these rows as CSV