PREVIEW / stock_1min / 2014-06-20
file: by_date/stock_1min/2014/2014-06-20.parquet size: 14.3 MB rows: 1,058,685 symbols: 2,915
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-20 04:01:00 | AAPL | Stock | 22.925 | 22.925 | 22.925 | 22.925 | 400.0 |
| 2014-06-20 04:15:00 | AAPL | Stock | 22.9275 | 22.9275 | 22.9275 | 22.9275 | 1200.0 |
| 2014-06-20 04:17:00 | AAPL | Stock | 22.93 | 22.93 | 22.93 | 22.93 | 2320.0 |
| 2014-06-20 04:37:00 | AAPL | Stock | 22.945 | 22.945 | 22.945 | 22.945 | 400.0 |
| 2014-06-20 05:11:00 | AAPL | Stock | 22.935 | 22.935 | 22.935 | 22.935 | 400.0 |
| 2014-06-20 05:14:00 | AAPL | Stock | 22.945 | 22.945 | 22.945 | 22.945 | 3600.0 |
| 2014-06-20 05:16:00 | AAPL | Stock | 22.945 | 22.945 | 22.945 | 22.945 | 1600.0 |
| 2014-06-20 05:35:00 | AAPL | Stock | 22.945 | 22.945 | 22.945 | 22.945 | 420.0 |
| 2014-06-20 05:45:00 | AAPL | Stock | 22.94 | 22.945 | 22.94 | 22.945 | 3012.0 |
| 2014-06-20 05:53:00 | AAPL | Stock | 22.945 | 22.9475 | 22.945 | 22.9475 | 7320.0 |
| 2014-06-20 06:37:00 | AAPL | Stock | 22.9575 | 22.9575 | 22.9575 | 22.9575 | 1100.0 |
| 2014-06-20 06:39:00 | AAPL | Stock | 22.9575 | 22.9575 | 22.9575 | 22.9575 | 1200.0 |
| 2014-06-20 06:54:00 | AAPL | Stock | 22.94 | 22.94 | 22.94 | 22.94 | 2000.0 |
| 2014-06-20 07:01:00 | AAPL | Stock | 22.95 | 22.95 | 22.94 | 22.94 | 4400.0 |
| 2014-06-20 07:05:00 | AAPL | Stock | 22.955 | 22.955 | 22.955 | 22.955 | 2000.0 |
| 2014-06-20 07:07:00 | AAPL | Stock | 22.9625 | 22.965 | 22.9625 | 22.965 | 16448.0 |
| 2014-06-20 07:08:00 | AAPL | Stock | 22.9625 | 22.9625 | 22.9625 | 22.9625 | 400.0 |
| 2014-06-20 07:13:00 | AAPL | Stock | 22.9625 | 22.9625 | 22.9625 | 22.9625 | 400.0 |
| 2014-06-20 07:15:00 | AAPL | Stock | 22.9625 | 22.9625 | 22.9625 | 22.9625 | 1440.0 |
| 2014-06-20 07:20:00 | AAPL | Stock | 22.9625 | 22.9625 | 22.9625 | 22.9625 | 1780.0 |
| 2014-06-20 07:23:00 | AAPL | Stock | 22.9625 | 22.9625 | 22.9625 | 22.9625 | 1600.0 |
| 2014-06-20 07:24:00 | AAPL | Stock | 22.95 | 22.95 | 22.95 | 22.95 | 400.0 |
| 2014-06-20 07:32:00 | AAPL | Stock | 22.95 | 22.95 | 22.95 | 22.95 | 4000.0 |
| 2014-06-20 07:34:00 | AAPL | Stock | 22.95 | 22.95 | 22.95 | 22.95 | 784.0 |
| 2014-06-20 07:35:00 | AAPL | Stock | 22.95 | 22.95 | 22.95 | 22.95 | 2000.0 |
| 2014-06-20 07:36:00 | AAPL | Stock | 22.95 | 22.95 | 22.95 | 22.95 | 2520.0 |
| 2014-06-20 07:39:00 | AAPL | Stock | 22.9525 | 22.955 | 22.9525 | 22.955 | 2400.0 |
| 2014-06-20 07:40:00 | AAPL | Stock | 22.9625 | 22.9625 | 22.95 | 22.95 | 7444.0 |
| 2014-06-20 07:41:00 | AAPL | Stock | 22.9475 | 22.9475 | 22.9425 | 22.9425 | 9336.0 |
| 2014-06-20 07:42:00 | AAPL | Stock | 22.9425 | 22.9425 | 22.9425 | 22.9425 | 2000.0 |
| 2014-06-20 07:43:00 | AAPL | Stock | 22.96 | 22.9625 | 22.96 | 22.9625 | 4000.0 |
| 2014-06-20 07:46:00 | AAPL | Stock | 22.96 | 22.96 | 22.96 | 22.96 | 800.0 |
| 2014-06-20 07:47:00 | AAPL | Stock | 22.96 | 22.96 | 22.96 | 22.96 | 2800.0 |
| 2014-06-20 07:50:00 | AAPL | Stock | 22.96 | 22.97 | 22.96 | 22.97 | 7200.0 |
| 2014-06-20 07:51:00 | AAPL | Stock | 22.97 | 22.98 | 22.97 | 22.98 | 11520.0 |
| 2014-06-20 07:52:00 | AAPL | Stock | 22.985 | 22.99 | 22.9825 | 22.9875 | 11612.0 |
| 2014-06-20 07:53:00 | AAPL | Stock | 22.985 | 22.985 | 22.9675 | 22.97 | 10868.0 |
| 2014-06-20 07:58:00 | AAPL | Stock | 22.97 | 22.97 | 22.97 | 22.97 | 480.0 |
| 2014-06-20 08:00:00 | AAPL | Stock | 22.9625 | 22.985 | 22.9525 | 22.9625 | 24244.0 |
| 2014-06-20 08:01:00 | AAPL | Stock | 22.955 | 22.96 | 22.9525 | 22.955 | 8800.0 |
| 2014-06-20 08:02:00 | AAPL | Stock | 22.9575 | 22.9575 | 22.945 | 22.9475 | 16052.0 |
| 2014-06-20 08:03:00 | AAPL | Stock | 22.95 | 22.95 | 22.945 | 22.95 | 6732.0 |
| 2014-06-20 08:04:00 | AAPL | Stock | 22.9575 | 22.9575 | 22.9575 | 22.9575 | 400.0 |
| 2014-06-20 08:05:00 | AAPL | Stock | 22.95 | 22.95 | 22.95 | 22.95 | 1532.0 |
| 2014-06-20 08:06:00 | AAPL | Stock | 22.95 | 22.95 | 22.95 | 22.95 | 2000.0 |
| 2014-06-20 08:09:00 | AAPL | Stock | 22.95 | 22.95 | 22.95 | 22.95 | 6036.0 |
| 2014-06-20 08:10:00 | AAPL | Stock | 22.95 | 22.9525 | 22.95 | 22.95 | 4160.0 |
| 2014-06-20 08:13:00 | AAPL | Stock | 22.955 | 22.955 | 22.95 | 22.95 | 4000.0 |
| 2014-06-20 08:18:00 | AAPL | Stock | 22.97 | 22.9725 | 22.97 | 22.9725 | 2000.0 |
| 2014-06-20 08:22:00 | AAPL | Stock | 22.9725 | 22.9725 | 22.9625 | 22.9625 | 1600.0 |
> showing 50 of 1,058,685 rows — these rows as CSV