PREVIEW / stock_1min / 2015-04-27
file: by_date/stock_1min/2015/2015-04-27.parquet size: 15.5 MB rows: 1,109,363 symbols: 2,878
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-04-27 04:00:00 | AAPL | Stock | 32.745 | 32.745 | 32.74 | 32.7425 | 11200.0 |
| 2015-04-27 04:01:00 | AAPL | Stock | 32.745 | 32.745 | 32.7 | 32.7 | 5448.0 |
| 2015-04-27 04:03:00 | AAPL | Stock | 32.725 | 32.725 | 32.725 | 32.725 | 400.0 |
| 2015-04-27 04:05:00 | AAPL | Stock | 32.7475 | 32.7475 | 32.7475 | 32.7475 | 400.0 |
| 2015-04-27 04:06:00 | AAPL | Stock | 32.75 | 32.7925 | 32.75 | 32.7925 | 3200.0 |
| 2015-04-27 04:07:00 | AAPL | Stock | 32.795 | 32.8 | 32.7675 | 32.8 | 10676.0 |
| 2015-04-27 04:09:00 | AAPL | Stock | 32.7775 | 32.78 | 32.7775 | 32.78 | 800.0 |
| 2015-04-27 04:10:00 | AAPL | Stock | 32.7975 | 32.7975 | 32.7975 | 32.7975 | 800.0 |
| 2015-04-27 04:12:00 | AAPL | Stock | 32.7975 | 32.7975 | 32.7975 | 32.7975 | 456.0 |
| 2015-04-27 04:14:00 | AAPL | Stock | 32.78 | 32.78 | 32.78 | 32.78 | 1200.0 |
| 2015-04-27 04:17:00 | AAPL | Stock | 32.7875 | 32.7875 | 32.7875 | 32.7875 | 800.0 |
| 2015-04-27 04:18:00 | AAPL | Stock | 32.7775 | 32.7775 | 32.775 | 32.775 | 800.0 |
| 2015-04-27 04:19:00 | AAPL | Stock | 32.7725 | 32.7725 | 32.7725 | 32.7725 | 2000.0 |
| 2015-04-27 04:20:00 | AAPL | Stock | 32.7725 | 32.7725 | 32.7725 | 32.7725 | 2820.0 |
| 2015-04-27 04:23:00 | AAPL | Stock | 32.775 | 32.775 | 32.755 | 32.755 | 7208.0 |
| 2015-04-27 04:36:00 | AAPL | Stock | 32.765 | 32.765 | 32.765 | 32.765 | 400.0 |
| 2015-04-27 04:45:00 | AAPL | Stock | 32.7525 | 32.7525 | 32.75 | 32.75 | 2800.0 |
| 2015-04-27 04:46:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 1648.0 |
| 2015-04-27 04:47:00 | AAPL | Stock | 32.7525 | 32.7525 | 32.7375 | 32.7375 | 2396.0 |
| 2015-04-27 04:48:00 | AAPL | Stock | 32.7525 | 32.7525 | 32.75 | 32.75 | 9652.0 |
| 2015-04-27 04:53:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 2000.0 |
| 2015-04-27 04:55:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 800.0 |
| 2015-04-27 04:56:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 21440.0 |
| 2015-04-27 05:01:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 8800.0 |
| 2015-04-27 05:03:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 400.0 |
| 2015-04-27 05:04:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 1600.0 |
| 2015-04-27 05:05:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 1200.0 |
| 2015-04-27 05:06:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 2000.0 |
| 2015-04-27 05:07:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 800.0 |
| 2015-04-27 05:09:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 800.0 |
| 2015-04-27 05:11:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 400.0 |
| 2015-04-27 05:12:00 | AAPL | Stock | 32.775 | 32.775 | 32.75 | 32.75 | 3656.0 |
| 2015-04-27 05:14:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 400.0 |
| 2015-04-27 05:17:00 | AAPL | Stock | 32.775 | 32.775 | 32.7725 | 32.7725 | 7140.0 |
| 2015-04-27 05:19:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 3932.0 |
| 2015-04-27 05:20:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 10264.0 |
| 2015-04-27 05:21:00 | AAPL | Stock | 32.7525 | 32.7525 | 32.75 | 32.75 | 2400.0 |
| 2015-04-27 05:22:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 400.0 |
| 2015-04-27 05:23:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 4900.0 |
| 2015-04-27 05:27:00 | AAPL | Stock | 32.75 | 32.75 | 32.7375 | 32.7375 | 2044.0 |
| 2015-04-27 05:30:00 | AAPL | Stock | 32.7375 | 32.7375 | 32.735 | 32.735 | 10000.0 |
| 2015-04-27 05:31:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 1588.0 |
| 2015-04-27 05:35:00 | AAPL | Stock | 32.75 | 32.75 | 32.75 | 32.75 | 1488.0 |
| 2015-04-27 05:46:00 | AAPL | Stock | 32.76 | 32.76 | 32.76 | 32.76 | 3200.0 |
| 2015-04-27 05:47:00 | AAPL | Stock | 32.76 | 32.76 | 32.76 | 32.76 | 800.0 |
| 2015-04-27 05:49:00 | AAPL | Stock | 32.7475 | 32.765 | 32.7475 | 32.765 | 6400.0 |
| 2015-04-27 05:51:00 | AAPL | Stock | 32.7675 | 32.7675 | 32.7475 | 32.7475 | 2400.0 |
| 2015-04-27 05:52:00 | AAPL | Stock | 32.7675 | 32.7675 | 32.7675 | 32.7675 | 1372.0 |
| 2015-04-27 05:53:00 | AAPL | Stock | 32.77 | 32.77 | 32.77 | 32.77 | 400.0 |
| 2015-04-27 06:00:00 | AAPL | Stock | 32.775 | 32.775 | 32.775 | 32.775 | 2212.0 |
> showing 50 of 1,109,363 rows — these rows as CSV