PREVIEW / stock_1min / 2012-04-10
file: by_date/stock_1min/2012/2012-04-10.parquet size: 14.3 MB rows: 1,061,964 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 |
|---|---|---|---|---|---|---|---|
| 2012-04-10 04:00:00 | AAPL | Stock | 22.7779 | 22.7857 | 22.7779 | 22.7857 | 30660.0 |
| 2012-04-10 04:01:00 | AAPL | Stock | 22.8221 | 22.8221 | 22.8221 | 22.8221 | 2800.0 |
| 2012-04-10 04:07:00 | AAPL | Stock | 22.8368 | 22.8368 | 22.8368 | 22.8368 | 11200.0 |
| 2012-04-10 04:10:00 | AAPL | Stock | 22.8214 | 22.8214 | 22.8214 | 22.8214 | 11200.0 |
| 2012-04-10 04:11:00 | AAPL | Stock | 22.8214 | 22.8214 | 22.8214 | 22.8214 | 11200.0 |
| 2012-04-10 04:12:00 | AAPL | Stock | 22.8061 | 22.8061 | 22.8061 | 22.8061 | 11200.0 |
| 2012-04-10 04:13:00 | AAPL | Stock | 22.8061 | 22.8061 | 22.8061 | 22.8061 | 2800.0 |
| 2012-04-10 04:14:00 | AAPL | Stock | 22.8068 | 22.8068 | 22.8036 | 22.8036 | 11200.0 |
| 2012-04-10 04:17:00 | AAPL | Stock | 22.7932 | 22.7932 | 22.7857 | 22.7857 | 42000.0 |
| 2012-04-10 04:18:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 2800.0 |
| 2012-04-10 04:20:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 61600.0 |
| 2012-04-10 04:25:00 | AAPL | Stock | 22.7861 | 22.7861 | 22.7861 | 22.7861 | 2800.0 |
| 2012-04-10 04:26:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 16408.0 |
| 2012-04-10 04:27:00 | AAPL | Stock | 22.7821 | 22.7857 | 22.7821 | 22.7857 | 14840.0 |
| 2012-04-10 04:32:00 | AAPL | Stock | 22.7989 | 22.7989 | 22.7989 | 22.7989 | 2800.0 |
| 2012-04-10 04:33:00 | AAPL | Stock | 22.7964 | 22.7964 | 22.7857 | 22.7857 | 17080.0 |
| 2012-04-10 04:38:00 | AAPL | Stock | 22.7993 | 22.7993 | 22.7993 | 22.7993 | 16800.0 |
| 2012-04-10 04:40:00 | AAPL | Stock | 22.7864 | 22.7864 | 22.7861 | 22.7861 | 16800.0 |
| 2012-04-10 04:41:00 | AAPL | Stock | 22.7993 | 22.7993 | 22.7993 | 22.7993 | 3696.0 |
| 2012-04-10 04:43:00 | AAPL | Stock | 22.8007 | 22.8007 | 22.8007 | 22.8007 | 2800.0 |
| 2012-04-10 04:44:00 | AAPL | Stock | 22.7861 | 22.7875 | 22.7857 | 22.7857 | 23240.0 |
| 2012-04-10 04:45:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7804 | 22.7804 | 9688.0 |
| 2012-04-10 04:51:00 | AAPL | Stock | 22.7821 | 22.7821 | 22.7821 | 22.7821 | 11200.0 |
| 2012-04-10 04:52:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 5600.0 |
| 2012-04-10 05:04:00 | AAPL | Stock | 22.7768 | 22.7768 | 22.7768 | 22.7768 | 8400.0 |
| 2012-04-10 05:06:00 | AAPL | Stock | 22.7768 | 22.7768 | 22.7768 | 22.7768 | 4900.0 |
| 2012-04-10 05:15:00 | AAPL | Stock | 22.7682 | 22.7682 | 22.7682 | 22.7682 | 5180.0 |
| 2012-04-10 05:16:00 | AAPL | Stock | 22.7679 | 22.7679 | 22.7679 | 22.7679 | 2800.0 |
| 2012-04-10 05:22:00 | AAPL | Stock | 22.7718 | 22.7718 | 22.7718 | 22.7718 | 8400.0 |
| 2012-04-10 05:28:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 4200.0 |
| 2012-04-10 05:40:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 2800.0 |
| 2012-04-10 05:42:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 5600.0 |
| 2012-04-10 05:44:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.7857 | 22.7857 | 4760.0 |
| 2012-04-10 05:49:00 | AAPL | Stock | 22.8032 | 22.8036 | 22.8032 | 22.8036 | 33600.0 |
| 2012-04-10 05:50:00 | AAPL | Stock | 22.8211 | 22.8214 | 22.8211 | 22.8214 | 61600.0 |
| 2012-04-10 05:53:00 | AAPL | Stock | 22.8214 | 22.8214 | 22.8214 | 22.8214 | 2800.0 |
| 2012-04-10 06:08:00 | AAPL | Stock | 22.8125 | 22.8143 | 22.8125 | 22.8143 | 9240.0 |
| 2012-04-10 06:24:00 | AAPL | Stock | 22.8093 | 22.8093 | 22.8093 | 22.8093 | 2800.0 |
| 2012-04-10 06:25:00 | AAPL | Stock | 22.8143 | 22.8143 | 22.8143 | 22.8143 | 8400.0 |
| 2012-04-10 06:28:00 | AAPL | Stock | 22.8214 | 22.8214 | 22.8214 | 22.8214 | 2800.0 |
| 2012-04-10 06:36:00 | AAPL | Stock | 22.8214 | 22.8214 | 22.8214 | 22.8214 | 56000.0 |
| 2012-04-10 06:38:00 | AAPL | Stock | 22.8321 | 22.8321 | 22.8321 | 22.8321 | 2800.0 |
| 2012-04-10 06:39:00 | AAPL | Stock | 22.8518 | 22.8521 | 22.8518 | 22.8521 | 11200.0 |
| 2012-04-10 06:40:00 | AAPL | Stock | 22.8518 | 22.8564 | 22.8518 | 22.8518 | 16800.0 |
| 2012-04-10 06:41:00 | AAPL | Stock | 22.8518 | 22.8518 | 22.8518 | 22.8518 | 2800.0 |
| 2012-04-10 06:46:00 | AAPL | Stock | 22.8543 | 22.8543 | 22.8543 | 22.8543 | 14000.0 |
| 2012-04-10 06:47:00 | AAPL | Stock | 22.8543 | 22.8543 | 22.8543 | 22.8543 | 2800.0 |
| 2012-04-10 06:52:00 | AAPL | Stock | 22.8518 | 22.8571 | 22.8518 | 22.8568 | 19600.0 |
| 2012-04-10 06:53:00 | AAPL | Stock | 22.8571 | 22.8571 | 22.8571 | 22.8571 | 2800.0 |
| 2012-04-10 06:54:00 | AAPL | Stock | 22.8518 | 22.8518 | 22.8518 | 22.8518 | 5908.0 |
> showing 50 of 1,061,964 rows — these rows as CSV