PREVIEW / stock_1min / 2012-12-14
file: by_date/stock_1min/2012/2012-12-14.parquet size: 12.4 MB rows: 926,715 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-12-14 04:12:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 11200.0 |
| 2012-12-14 04:16:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 2800.0 |
| 2012-12-14 04:17:00 | AAPL | Stock | 18.8914 | 18.8921 | 18.8914 | 18.8921 | 8400.0 |
| 2012-12-14 04:38:00 | AAPL | Stock | 18.8911 | 18.8911 | 18.8911 | 18.8911 | 2800.0 |
| 2012-12-14 05:06:00 | AAPL | Stock | 18.875 | 18.875 | 18.875 | 18.875 | 5600.0 |
| 2012-12-14 05:09:00 | AAPL | Stock | 18.8736 | 18.8736 | 18.8725 | 18.8725 | 14000.0 |
| 2012-12-14 05:13:00 | AAPL | Stock | 18.8871 | 18.8871 | 18.8871 | 18.8871 | 2800.0 |
| 2012-12-14 05:22:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8857 | 18.8857 | 2800.0 |
| 2012-12-14 05:24:00 | AAPL | Stock | 18.8775 | 18.8775 | 18.8775 | 18.8775 | 2800.0 |
| 2012-12-14 05:26:00 | AAPL | Stock | 18.8661 | 18.875 | 18.8661 | 18.8661 | 18984.0 |
| 2012-12-14 05:27:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8661 | 18.8661 | 2800.0 |
| 2012-12-14 05:28:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8661 | 18.8661 | 2800.0 |
| 2012-12-14 05:29:00 | AAPL | Stock | 18.8661 | 18.8661 | 18.8661 | 18.8661 | 2800.0 |
| 2012-12-14 05:32:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2012-12-14 05:34:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 4900.0 |
| 2012-12-14 05:36:00 | AAPL | Stock | 18.8407 | 18.8407 | 18.8407 | 18.8407 | 2800.0 |
| 2012-12-14 05:38:00 | AAPL | Stock | 18.8393 | 18.8393 | 18.8393 | 18.8393 | 2800.0 |
| 2012-12-14 05:40:00 | AAPL | Stock | 18.8232 | 18.8232 | 18.8232 | 18.8232 | 2800.0 |
| 2012-12-14 05:50:00 | AAPL | Stock | 18.8225 | 18.8225 | 18.8225 | 18.8225 | 2800.0 |
| 2012-12-14 05:54:00 | AAPL | Stock | 18.8225 | 18.8225 | 18.8225 | 18.8225 | 5600.0 |
| 2012-12-14 05:56:00 | AAPL | Stock | 18.8225 | 18.8225 | 18.8225 | 18.8225 | 2800.0 |
| 2012-12-14 05:58:00 | AAPL | Stock | 18.8221 | 18.8221 | 18.8221 | 18.8221 | 2800.0 |
| 2012-12-14 06:01:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 5180.0 |
| 2012-12-14 06:02:00 | AAPL | Stock | 18.8289 | 18.8289 | 18.8289 | 18.8289 | 2800.0 |
| 2012-12-14 06:05:00 | AAPL | Stock | 18.8229 | 18.8354 | 18.8229 | 18.8354 | 5600.0 |
| 2012-12-14 06:11:00 | AAPL | Stock | 18.8189 | 18.8189 | 18.8189 | 18.8189 | 2800.0 |
| 2012-12-14 06:12:00 | AAPL | Stock | 18.8225 | 18.8225 | 18.8225 | 18.8225 | 2800.0 |
| 2012-12-14 06:19:00 | AAPL | Stock | 18.8089 | 18.8089 | 18.7857 | 18.7857 | 8400.0 |
| 2012-12-14 06:20:00 | AAPL | Stock | 18.7857 | 18.7946 | 18.7857 | 18.7946 | 5600.0 |
| 2012-12-14 06:25:00 | AAPL | Stock | 18.7943 | 18.7943 | 18.7943 | 18.7943 | 5600.0 |
| 2012-12-14 06:34:00 | AAPL | Stock | 18.7929 | 18.7929 | 18.7929 | 18.7929 | 2800.0 |
| 2012-12-14 06:36:00 | AAPL | Stock | 18.7946 | 18.7971 | 18.7946 | 18.7946 | 28000.0 |
| 2012-12-14 06:41:00 | AAPL | Stock | 18.7843 | 18.7843 | 18.7843 | 18.7843 | 7000.0 |
| 2012-12-14 06:43:00 | AAPL | Stock | 18.7811 | 18.7811 | 18.7811 | 18.7811 | 2800.0 |
| 2012-12-14 06:44:00 | AAPL | Stock | 18.7682 | 18.7682 | 18.7679 | 18.7679 | 5600.0 |
| 2012-12-14 06:47:00 | AAPL | Stock | 18.7779 | 18.7779 | 18.7739 | 18.7739 | 7952.0 |
| 2012-12-14 06:56:00 | AAPL | Stock | 18.7836 | 18.7889 | 18.7836 | 18.7889 | 14000.0 |
| 2012-12-14 06:58:00 | AAPL | Stock | 18.7739 | 18.7739 | 18.7739 | 18.7739 | 2800.0 |
| 2012-12-14 07:00:00 | AAPL | Stock | 18.7739 | 18.7739 | 18.7671 | 18.7671 | 11200.0 |
| 2012-12-14 07:01:00 | AAPL | Stock | 18.7704 | 18.7704 | 18.7704 | 18.7704 | 2800.0 |
| 2012-12-14 07:03:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7679 | 18.7679 | 11200.0 |
| 2012-12-14 07:04:00 | AAPL | Stock | 18.7682 | 18.7814 | 18.7682 | 18.7686 | 18200.0 |
| 2012-12-14 07:05:00 | AAPL | Stock | 18.775 | 18.775 | 18.7725 | 18.7725 | 5600.0 |
| 2012-12-14 07:06:00 | AAPL | Stock | 18.7857 | 18.7864 | 18.7786 | 18.7786 | 30520.0 |
| 2012-12-14 07:07:00 | AAPL | Stock | 18.7768 | 18.7768 | 18.7768 | 18.7768 | 2800.0 |
| 2012-12-14 07:08:00 | AAPL | Stock | 18.775 | 18.775 | 18.7714 | 18.7714 | 5600.0 |
| 2012-12-14 07:09:00 | AAPL | Stock | 18.75 | 18.7518 | 18.7464 | 18.7496 | 60200.0 |
| 2012-12-14 07:10:00 | AAPL | Stock | 18.75 | 18.75 | 18.7425 | 18.7479 | 58016.0 |
| 2012-12-14 07:11:00 | AAPL | Stock | 18.7393 | 18.7479 | 18.7375 | 18.7479 | 16800.0 |
| 2012-12-14 07:12:00 | AAPL | Stock | 18.7396 | 18.7396 | 18.7393 | 18.7393 | 8400.0 |
> showing 50 of 926,715 rows — these rows as CSV