PREVIEW / stock_1min / 2019-08-27
file: by_date/stock_1min/2019/2019-08-27.parquet size: 15.7 MB rows: 1,089,702 symbols: 2,178
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 |
|---|---|---|---|---|---|---|---|
| 2019-08-27 04:00:00 | AAPL | Stock | 51.47 | 51.47 | 51.47 | 51.47 | 400.0 |
| 2019-08-27 04:03:00 | AAPL | Stock | 51.4275 | 51.4275 | 51.4275 | 51.4275 | 800.0 |
| 2019-08-27 04:14:00 | AAPL | Stock | 51.4925 | 51.4925 | 51.4925 | 51.4925 | 400.0 |
| 2019-08-27 04:23:00 | AAPL | Stock | 51.5 | 51.5 | 51.5 | 51.5 | 1200.0 |
| 2019-08-27 05:02:00 | AAPL | Stock | 51.495 | 51.5375 | 51.495 | 51.5375 | 2052.0 |
| 2019-08-27 05:03:00 | AAPL | Stock | 51.6175 | 51.625 | 51.6175 | 51.625 | 2184.0 |
| 2019-08-27 05:11:00 | AAPL | Stock | 51.5925 | 51.5925 | 51.5925 | 51.5925 | 6380.0 |
| 2019-08-27 05:27:00 | AAPL | Stock | 51.5625 | 51.5625 | 51.5625 | 51.5625 | 400.0 |
| 2019-08-27 05:28:00 | AAPL | Stock | 51.5625 | 51.5625 | 51.5125 | 51.5125 | 3876.0 |
| 2019-08-27 05:31:00 | AAPL | Stock | 51.5825 | 51.5825 | 51.5825 | 51.5825 | 2600.0 |
| 2019-08-27 05:35:00 | AAPL | Stock | 51.6025 | 51.6025 | 51.6025 | 51.6025 | 1544.0 |
| 2019-08-27 05:39:00 | AAPL | Stock | 51.6725 | 51.6725 | 51.6725 | 51.6725 | 400.0 |
| 2019-08-27 06:03:00 | AAPL | Stock | 51.6225 | 51.6225 | 51.6225 | 51.6225 | 400.0 |
| 2019-08-27 06:08:00 | AAPL | Stock | 51.66 | 51.6725 | 51.66 | 51.6725 | 3316.0 |
| 2019-08-27 06:10:00 | AAPL | Stock | 51.6975 | 51.6975 | 51.6975 | 51.6975 | 1200.0 |
| 2019-08-27 06:13:00 | AAPL | Stock | 51.7225 | 51.7225 | 51.7225 | 51.7225 | 800.0 |
| 2019-08-27 06:35:00 | AAPL | Stock | 51.71 | 51.71 | 51.71 | 51.71 | 824.0 |
| 2019-08-27 07:00:00 | AAPL | Stock | 51.715 | 51.725 | 51.6375 | 51.7125 | 7888.0 |
| 2019-08-27 07:06:00 | AAPL | Stock | 51.75 | 51.78 | 51.75 | 51.78 | 2384.0 |
| 2019-08-27 07:07:00 | AAPL | Stock | 51.75 | 51.75 | 51.75 | 51.75 | 4000.0 |
| 2019-08-27 07:08:00 | AAPL | Stock | 51.78 | 51.8375 | 51.78 | 51.82 | 4632.0 |
| 2019-08-27 07:12:00 | AAPL | Stock | 51.8175 | 51.8175 | 51.8175 | 51.8175 | 400.0 |
| 2019-08-27 07:17:00 | AAPL | Stock | 51.79 | 51.79 | 51.79 | 51.79 | 800.0 |
| 2019-08-27 07:19:00 | AAPL | Stock | 51.815 | 51.8175 | 51.815 | 51.8175 | 800.0 |
| 2019-08-27 07:21:00 | AAPL | Stock | 51.8 | 51.8 | 51.775 | 51.775 | 10792.0 |
| 2019-08-27 07:22:00 | AAPL | Stock | 51.77 | 51.77 | 51.77 | 51.77 | 400.0 |
| 2019-08-27 07:24:00 | AAPL | Stock | 51.8 | 51.8 | 51.8 | 51.8 | 400.0 |
| 2019-08-27 07:25:00 | AAPL | Stock | 51.7875 | 51.8125 | 51.7875 | 51.7875 | 2400.0 |
| 2019-08-27 07:26:00 | AAPL | Stock | 51.7875 | 51.7875 | 51.7875 | 51.7875 | 2000.0 |
| 2019-08-27 07:27:00 | AAPL | Stock | 51.765 | 51.7675 | 51.7625 | 51.7625 | 1200.0 |
| 2019-08-27 07:28:00 | AAPL | Stock | 51.7625 | 51.815 | 51.7625 | 51.815 | 1724.0 |
| 2019-08-27 07:29:00 | AAPL | Stock | 51.7925 | 51.7925 | 51.775 | 51.775 | 2000.0 |
| 2019-08-27 07:31:00 | AAPL | Stock | 51.7825 | 51.7825 | 51.7775 | 51.7775 | 800.0 |
| 2019-08-27 07:32:00 | AAPL | Stock | 51.7725 | 51.7725 | 51.7575 | 51.7575 | 800.0 |
| 2019-08-27 07:33:00 | AAPL | Stock | 51.75 | 51.75 | 51.75 | 51.75 | 940.0 |
| 2019-08-27 07:34:00 | AAPL | Stock | 51.75 | 51.75 | 51.75 | 51.75 | 412.0 |
| 2019-08-27 07:38:00 | AAPL | Stock | 51.7625 | 51.795 | 51.7625 | 51.775 | 2900.0 |
| 2019-08-27 07:45:00 | AAPL | Stock | 51.7725 | 51.7725 | 51.755 | 51.755 | 1600.0 |
| 2019-08-27 07:46:00 | AAPL | Stock | 51.75 | 51.75 | 51.7425 | 51.7425 | 3652.0 |
| 2019-08-27 07:48:00 | AAPL | Stock | 51.7625 | 51.7625 | 51.75 | 51.75 | 7600.0 |
| 2019-08-27 07:49:00 | AAPL | Stock | 51.7575 | 51.7575 | 51.75 | 51.75 | 20908.0 |
| 2019-08-27 07:53:00 | AAPL | Stock | 51.75 | 51.7625 | 51.75 | 51.7625 | 1284.0 |
| 2019-08-27 07:55:00 | AAPL | Stock | 51.775 | 51.775 | 51.775 | 51.775 | 800.0 |
| 2019-08-27 07:57:00 | AAPL | Stock | 51.775 | 51.775 | 51.775 | 51.775 | 7300.0 |
| 2019-08-27 08:00:00 | AAPL | Stock | 51.7325 | 51.8275 | 51.6525 | 51.75 | 101700.0 |
| 2019-08-27 08:01:00 | AAPL | Stock | 51.7725 | 51.7725 | 51.7725 | 51.7725 | 1764.0 |
| 2019-08-27 08:02:00 | AAPL | Stock | 51.7975 | 51.7975 | 51.7975 | 51.7975 | 2764.0 |
| 2019-08-27 08:03:00 | AAPL | Stock | 51.795 | 51.795 | 51.77 | 51.77 | 2596.0 |
| 2019-08-27 08:04:00 | AAPL | Stock | 51.7627 | 51.7627 | 51.7627 | 51.7627 | 800.0 |
| 2019-08-27 08:05:00 | AAPL | Stock | 51.7925 | 51.835 | 51.7775 | 51.7775 | 5120.0 |
> showing 50 of 1,089,702 rows — these rows as CSV