PREVIEW / stock_1min / 2015-03-25
file: by_date/stock_1min/2015/2015-03-25.parquet size: 15.3 MB rows: 1,094,064 symbols: 2,857
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-25 04:00:00 | AAPL | Stock | 31.75 | 31.765 | 31.75 | 31.765 | 800.0 |
| 2015-03-25 04:03:00 | AAPL | Stock | 31.7775 | 31.7775 | 31.775 | 31.775 | 2000.0 |
| 2015-03-25 04:06:00 | AAPL | Stock | 31.75 | 31.75 | 31.75 | 31.75 | 400.0 |
| 2015-03-25 04:25:00 | AAPL | Stock | 31.785 | 31.785 | 31.785 | 31.785 | 400.0 |
| 2015-03-25 05:03:00 | AAPL | Stock | 31.7425 | 31.7425 | 31.7425 | 31.7425 | 400.0 |
| 2015-03-25 05:57:00 | AAPL | Stock | 31.7375 | 31.75 | 31.7375 | 31.75 | 2400.0 |
| 2015-03-25 06:08:00 | AAPL | Stock | 31.765 | 31.7725 | 31.765 | 31.7725 | 800.0 |
| 2015-03-25 06:09:00 | AAPL | Stock | 31.75 | 31.75 | 31.75 | 31.75 | 400.0 |
| 2015-03-25 06:42:00 | AAPL | Stock | 31.7425 | 31.7425 | 31.7425 | 31.7425 | 400.0 |
| 2015-03-25 07:07:00 | AAPL | Stock | 31.7075 | 31.7075 | 31.7075 | 31.7075 | 2000.0 |
| 2015-03-25 07:08:00 | AAPL | Stock | 31.7125 | 31.7125 | 31.7125 | 31.7125 | 6000.0 |
| 2015-03-25 07:09:00 | AAPL | Stock | 31.7125 | 31.7125 | 31.7125 | 31.7125 | 2800.0 |
| 2015-03-25 07:11:00 | AAPL | Stock | 31.685 | 31.685 | 31.6825 | 31.6825 | 2400.0 |
| 2015-03-25 07:18:00 | AAPL | Stock | 31.7125 | 31.7175 | 31.7125 | 31.7175 | 800.0 |
| 2015-03-25 07:20:00 | AAPL | Stock | 31.72 | 31.72 | 31.72 | 31.72 | 2400.0 |
| 2015-03-25 07:23:00 | AAPL | Stock | 31.715 | 31.715 | 31.715 | 31.715 | 800.0 |
| 2015-03-25 07:30:00 | AAPL | Stock | 31.7 | 31.7 | 31.7 | 31.7 | 1932.0 |
| 2015-03-25 07:32:00 | AAPL | Stock | 31.7 | 31.7 | 31.7 | 31.7 | 3932.0 |
| 2015-03-25 07:33:00 | AAPL | Stock | 31.6875 | 31.6875 | 31.6875 | 31.6875 | 1940.0 |
| 2015-03-25 07:35:00 | AAPL | Stock | 31.6875 | 31.6875 | 31.6875 | 31.6875 | 2800.0 |
| 2015-03-25 07:37:00 | AAPL | Stock | 31.6975 | 31.6975 | 31.6975 | 31.6975 | 800.0 |
| 2015-03-25 07:38:00 | AAPL | Stock | 31.6825 | 31.6825 | 31.6625 | 31.6625 | 26592.0 |
| 2015-03-25 07:40:00 | AAPL | Stock | 31.6625 | 31.6625 | 31.65 | 31.65 | 6080.0 |
| 2015-03-25 07:49:00 | AAPL | Stock | 31.665 | 31.665 | 31.665 | 31.665 | 1000.0 |
| 2015-03-25 07:50:00 | AAPL | Stock | 31.6525 | 31.6525 | 31.6525 | 31.6525 | 400.0 |
| 2015-03-25 07:53:00 | AAPL | Stock | 31.655 | 31.655 | 31.6525 | 31.6525 | 4840.0 |
| 2015-03-25 07:55:00 | AAPL | Stock | 31.645 | 31.645 | 31.645 | 31.645 | 2000.0 |
| 2015-03-25 07:56:00 | AAPL | Stock | 31.645 | 31.645 | 31.6325 | 31.6325 | 17640.0 |
| 2015-03-25 07:57:00 | AAPL | Stock | 31.625 | 31.6275 | 31.27 | 31.415 | 98924.0 |
| 2015-03-25 07:58:00 | AAPL | Stock | 31.4125 | 31.44 | 31.25 | 31.3 | 20792.0 |
| 2015-03-25 07:59:00 | AAPL | Stock | 31.2975 | 31.45 | 31.29 | 31.45 | 90208.0 |
| 2015-03-25 08:00:00 | AAPL | Stock | 31.4525 | 31.76 | 31.375 | 31.495 | 158456.0 |
| 2015-03-25 08:01:00 | AAPL | Stock | 31.4675 | 31.5 | 31.465 | 31.465 | 54904.0 |
| 2015-03-25 08:02:00 | AAPL | Stock | 31.47 | 31.475 | 31.44 | 31.45 | 71940.0 |
| 2015-03-25 08:03:00 | AAPL | Stock | 31.4625 | 31.4775 | 31.4625 | 31.475 | 13404.0 |
| 2015-03-25 08:04:00 | AAPL | Stock | 31.4825 | 31.4825 | 31.4625 | 31.475 | 26896.0 |
| 2015-03-25 08:05:00 | AAPL | Stock | 31.475 | 31.4875 | 31.4625 | 31.4875 | 46704.0 |
| 2015-03-25 08:06:00 | AAPL | Stock | 31.4875 | 31.5 | 31.4775 | 31.5 | 40624.0 |
| 2015-03-25 08:07:00 | AAPL | Stock | 31.5125 | 31.525 | 31.5125 | 31.525 | 41740.0 |
| 2015-03-25 08:08:00 | AAPL | Stock | 31.5375 | 31.5502 | 31.5225 | 31.5502 | 14000.0 |
| 2015-03-25 08:09:00 | AAPL | Stock | 31.5625 | 31.57 | 31.56 | 31.57 | 6600.0 |
| 2015-03-25 08:10:00 | AAPL | Stock | 31.57 | 31.57 | 31.55 | 31.56 | 30276.0 |
| 2015-03-25 08:11:00 | AAPL | Stock | 31.55 | 31.55 | 31.5275 | 31.5275 | 18996.0 |
| 2015-03-25 08:12:00 | AAPL | Stock | 31.545 | 31.5625 | 31.545 | 31.555 | 10800.0 |
| 2015-03-25 08:13:00 | AAPL | Stock | 31.5575 | 31.5625 | 31.54 | 31.555 | 38632.0 |
| 2015-03-25 08:14:00 | AAPL | Stock | 31.5625 | 31.5625 | 31.5525 | 31.5625 | 7448.0 |
| 2015-03-25 08:16:00 | AAPL | Stock | 31.57 | 31.57 | 31.55 | 31.55 | 3200.0 |
| 2015-03-25 08:17:00 | AAPL | Stock | 31.55 | 31.55 | 31.55 | 31.55 | 2800.0 |
| 2015-03-25 08:18:00 | AAPL | Stock | 31.5475 | 31.5475 | 31.5475 | 31.5475 | 800.0 |
| 2015-03-25 08:19:00 | AAPL | Stock | 31.5475 | 31.5475 | 31.5475 | 31.5475 | 3600.0 |
> showing 50 of 1,094,064 rows — these rows as CSV