PREVIEW / stock_1min / 2014-11-13
file: by_date/stock_1min/2014/2014-11-13.parquet size: 14.5 MB rows: 1,058,399 symbols: 2,883
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-11-13 04:00:00 | AAPL | Stock | 27.875 | 27.9 | 27.875 | 27.9 | 4800.0 |
| 2014-11-13 04:05:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 2000.0 |
| 2014-11-13 04:07:00 | AAPL | Stock | 27.9075 | 27.9125 | 27.9075 | 27.9125 | 4800.0 |
| 2014-11-13 04:09:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 1600.0 |
| 2014-11-13 04:10:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 2800.0 |
| 2014-11-13 04:22:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 3200.0 |
| 2014-11-13 04:23:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 636.0 |
| 2014-11-13 04:31:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 1200.0 |
| 2014-11-13 04:36:00 | AAPL | Stock | 27.91 | 27.91 | 27.91 | 27.91 | 1836.0 |
| 2014-11-13 04:39:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 400.0 |
| 2014-11-13 05:06:00 | AAPL | Stock | 27.9525 | 27.9525 | 27.9525 | 27.9525 | 400.0 |
| 2014-11-13 05:10:00 | AAPL | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 400.0 |
| 2014-11-13 05:22:00 | AAPL | Stock | 27.9325 | 27.9325 | 27.9325 | 27.9325 | 1200.0 |
| 2014-11-13 05:34:00 | AAPL | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 800.0 |
| 2014-11-13 05:36:00 | AAPL | Stock | 27.945 | 27.945 | 27.945 | 27.945 | 400.0 |
| 2014-11-13 05:40:00 | AAPL | Stock | 27.925 | 27.925 | 27.915 | 27.915 | 3632.0 |
| 2014-11-13 05:42:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 400.0 |
| 2014-11-13 05:48:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 672.0 |
| 2014-11-13 05:49:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 8488.0 |
| 2014-11-13 05:56:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 2400.0 |
| 2014-11-13 06:00:00 | AAPL | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 4000.0 |
| 2014-11-13 06:01:00 | AAPL | Stock | 27.955 | 27.955 | 27.955 | 27.955 | 1000.0 |
| 2014-11-13 06:10:00 | AAPL | Stock | 27.9525 | 27.955 | 27.9525 | 27.955 | 8000.0 |
| 2014-11-13 06:11:00 | AAPL | Stock | 27.955 | 27.955 | 27.955 | 27.955 | 3240.0 |
| 2014-11-13 06:13:00 | AAPL | Stock | 27.975 | 27.9825 | 27.975 | 27.9825 | 2800.0 |
| 2014-11-13 06:14:00 | AAPL | Stock | 27.98 | 27.98 | 27.98 | 27.98 | 400.0 |
| 2014-11-13 06:15:00 | AAPL | Stock | 27.975 | 27.975 | 27.975 | 27.975 | 1028.0 |
| 2014-11-13 06:17:00 | AAPL | Stock | 27.975 | 27.975 | 27.975 | 27.975 | 456.0 |
| 2014-11-13 06:18:00 | AAPL | Stock | 27.9625 | 27.9725 | 27.9625 | 27.9725 | 4400.0 |
| 2014-11-13 06:19:00 | AAPL | Stock | 27.965 | 27.975 | 27.965 | 27.975 | 1716.0 |
| 2014-11-13 06:21:00 | AAPL | Stock | 27.9425 | 27.9425 | 27.9275 | 27.9275 | 800.0 |
| 2014-11-13 06:24:00 | AAPL | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 800.0 |
| 2014-11-13 06:26:00 | AAPL | Stock | 27.95 | 27.95 | 27.9475 | 27.9475 | 4632.0 |
| 2014-11-13 06:30:00 | AAPL | Stock | 27.945 | 27.945 | 27.945 | 27.945 | 400.0 |
| 2014-11-13 06:31:00 | AAPL | Stock | 27.9375 | 27.9375 | 27.9375 | 27.9375 | 1200.0 |
| 2014-11-13 06:32:00 | AAPL | Stock | 27.9425 | 27.9425 | 27.9425 | 27.9425 | 600.0 |
| 2014-11-13 06:33:00 | AAPL | Stock | 27.9175 | 27.9175 | 27.9175 | 27.9175 | 400.0 |
| 2014-11-13 06:34:00 | AAPL | Stock | 27.9125 | 27.925 | 27.9125 | 27.925 | 4456.0 |
| 2014-11-13 06:38:00 | AAPL | Stock | 27.925 | 27.925 | 27.9125 | 27.9125 | 17200.0 |
| 2014-11-13 06:39:00 | AAPL | Stock | 27.9125 | 27.9125 | 27.9125 | 27.9125 | 4000.0 |
| 2014-11-13 06:44:00 | AAPL | Stock | 27.9225 | 27.9225 | 27.9225 | 27.9225 | 400.0 |
| 2014-11-13 06:46:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 640.0 |
| 2014-11-13 06:51:00 | AAPL | Stock | 27.9075 | 27.9075 | 27.9075 | 27.9075 | 800.0 |
| 2014-11-13 07:00:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 4000.0 |
| 2014-11-13 07:01:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 8000.0 |
| 2014-11-13 07:02:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 5172.0 |
| 2014-11-13 07:03:00 | AAPL | Stock | 27.925 | 27.935 | 27.925 | 27.925 | 7932.0 |
| 2014-11-13 07:04:00 | AAPL | Stock | 27.9225 | 27.9225 | 27.9225 | 27.9225 | 10000.0 |
| 2014-11-13 07:05:00 | AAPL | Stock | 27.92 | 27.9225 | 27.9125 | 27.9125 | 13200.0 |
| 2014-11-13 07:06:00 | AAPL | Stock | 27.9225 | 27.9225 | 27.9125 | 27.9125 | 4100.0 |
> showing 50 of 1,058,399 rows — these rows as CSV