PREVIEW / stock_1min / 2019-08-28
file: by_date/stock_1min/2019/2019-08-28.parquet size: 15.0 MB rows: 1,071,435 symbols: 2,158
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-28 04:00:00 | AAPL | Stock | 51.1625 | 51.1625 | 51.1625 | 51.1625 | 448.0 |
| 2019-08-28 04:01:00 | AAPL | Stock | 51.1325 | 51.1325 | 51.1325 | 51.1325 | 600.0 |
| 2019-08-28 04:05:00 | AAPL | Stock | 51.12 | 51.1675 | 51.12 | 51.1675 | 4768.0 |
| 2019-08-28 04:28:00 | AAPL | Stock | 51.23 | 51.23 | 51.23 | 51.23 | 1080.0 |
| 2019-08-28 04:30:00 | AAPL | Stock | 51.27 | 51.27 | 51.27 | 51.27 | 400.0 |
| 2019-08-28 04:35:00 | AAPL | Stock | 51.235 | 51.235 | 51.235 | 51.235 | 400.0 |
| 2019-08-28 04:36:00 | AAPL | Stock | 51.23 | 51.23 | 51.23 | 51.23 | 30788.0 |
| 2019-08-28 04:37:00 | AAPL | Stock | 51.1675 | 51.1675 | 51.1675 | 51.1675 | 800.0 |
| 2019-08-28 04:39:00 | AAPL | Stock | 51.0875 | 51.0875 | 51.01 | 51.01 | 5000.0 |
| 2019-08-28 04:40:00 | AAPL | Stock | 50.97 | 50.97 | 50.97 | 50.97 | 400.0 |
| 2019-08-28 04:51:00 | AAPL | Stock | 51.03 | 51.03 | 51.03 | 51.03 | 400.0 |
| 2019-08-28 05:09:00 | AAPL | Stock | 51.1275 | 51.1275 | 51.1275 | 51.1275 | 3680.0 |
| 2019-08-28 05:20:00 | AAPL | Stock | 51.1475 | 51.1525 | 51.1475 | 51.1525 | 2400.0 |
| 2019-08-28 05:34:00 | AAPL | Stock | 51.025 | 51.025 | 51.01 | 51.01 | 1200.0 |
| 2019-08-28 05:55:00 | AAPL | Stock | 51.105 | 51.105 | 51.105 | 51.105 | 7520.0 |
| 2019-08-28 05:58:00 | AAPL | Stock | 51.065 | 51.065 | 51.065 | 51.065 | 400.0 |
| 2019-08-28 06:01:00 | AAPL | Stock | 51.16 | 51.16 | 51.16 | 51.16 | 400.0 |
| 2019-08-28 06:02:00 | AAPL | Stock | 51.185 | 51.2 | 51.185 | 51.2 | 1040.0 |
| 2019-08-28 06:18:00 | AAPL | Stock | 51.115 | 51.115 | 51.0625 | 51.0625 | 3400.0 |
| 2019-08-28 06:20:00 | AAPL | Stock | 51.04 | 51.04 | 51.04 | 51.04 | 2000.0 |
| 2019-08-28 06:56:00 | AAPL | Stock | 51.04 | 51.04 | 51.04 | 51.04 | 1800.0 |
| 2019-08-28 07:00:00 | AAPL | Stock | 51.075 | 51.1225 | 51.05 | 51.1225 | 4132.0 |
| 2019-08-28 07:02:00 | AAPL | Stock | 51.0625 | 51.0625 | 51.04 | 51.04 | 2000.0 |
| 2019-08-28 07:03:00 | AAPL | Stock | 51.04 | 51.04 | 51.04 | 51.04 | 1200.0 |
| 2019-08-28 07:07:00 | AAPL | Stock | 51.025 | 51.025 | 51.025 | 51.025 | 400.0 |
| 2019-08-28 07:08:00 | AAPL | Stock | 51.0125 | 51.0125 | 51.005 | 51.005 | 2684.0 |
| 2019-08-28 07:18:00 | AAPL | Stock | 51.0125 | 51.0125 | 50.985 | 50.985 | 18008.0 |
| 2019-08-28 07:20:00 | AAPL | Stock | 50.98 | 51.0 | 50.98 | 50.995 | 8872.0 |
| 2019-08-28 07:21:00 | AAPL | Stock | 50.985 | 50.985 | 50.985 | 50.985 | 2568.0 |
| 2019-08-28 07:26:00 | AAPL | Stock | 51.025 | 51.025 | 51.025 | 51.025 | 400.0 |
| 2019-08-28 07:29:00 | AAPL | Stock | 50.9775 | 50.9825 | 50.9275 | 50.9275 | 5160.0 |
| 2019-08-28 07:30:00 | AAPL | Stock | 50.9075 | 50.9075 | 50.82 | 50.82 | 15720.0 |
| 2019-08-28 07:33:00 | AAPL | Stock | 50.8975 | 50.8975 | 50.8625 | 50.8625 | 7168.0 |
| 2019-08-28 07:34:00 | AAPL | Stock | 50.875 | 50.9 | 50.875 | 50.9 | 2400.0 |
| 2019-08-28 07:36:00 | AAPL | Stock | 50.9025 | 50.9025 | 50.9025 | 50.9025 | 1392.0 |
| 2019-08-28 07:37:00 | AAPL | Stock | 50.905 | 50.905 | 50.875 | 50.875 | 3120.0 |
| 2019-08-28 07:38:00 | AAPL | Stock | 50.855 | 50.855 | 50.855 | 50.855 | 400.0 |
| 2019-08-28 07:39:00 | AAPL | Stock | 50.9075 | 50.9075 | 50.9075 | 50.9075 | 800.0 |
| 2019-08-28 07:43:00 | AAPL | Stock | 50.9425 | 50.95 | 50.9425 | 50.95 | 2400.0 |
| 2019-08-28 07:44:00 | AAPL | Stock | 50.9425 | 50.98 | 50.9425 | 50.9475 | 4400.0 |
| 2019-08-28 07:45:00 | AAPL | Stock | 50.97 | 50.975 | 50.97 | 50.975 | 1200.0 |
| 2019-08-28 07:46:00 | AAPL | Stock | 50.95 | 50.95 | 50.95 | 50.95 | 800.0 |
| 2019-08-28 07:47:00 | AAPL | Stock | 50.93 | 50.93 | 50.93 | 50.93 | 1400.0 |
| 2019-08-28 07:48:00 | AAPL | Stock | 50.9725 | 50.9725 | 50.95 | 50.95 | 800.0 |
| 2019-08-28 07:49:00 | AAPL | Stock | 50.95 | 50.95 | 50.945 | 50.945 | 1360.0 |
| 2019-08-28 07:52:00 | AAPL | Stock | 50.9325 | 50.945 | 50.9325 | 50.945 | 1600.0 |
| 2019-08-28 07:53:00 | AAPL | Stock | 50.9725 | 50.9725 | 50.9725 | 50.9725 | 400.0 |
| 2019-08-28 07:54:00 | AAPL | Stock | 50.965 | 50.965 | 50.94 | 50.94 | 2248.0 |
| 2019-08-28 07:57:00 | AAPL | Stock | 50.8775 | 50.8775 | 50.8775 | 50.8775 | 1200.0 |
| 2019-08-28 07:58:00 | AAPL | Stock | 50.9 | 50.9 | 50.9 | 50.9 | 400.0 |
> showing 50 of 1,071,435 rows — these rows as CSV