PREVIEW / stock_1min / 2019-05-21
file: by_date/stock_1min/2019/2019-05-21.parquet size: 14.9 MB rows: 1,070,607 symbols: 2,188
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-05-21 04:35:00 | AAPL | Stock | 46.05 | 46.05 | 46.05 | 46.05 | 400.0 |
| 2019-05-21 04:38:00 | AAPL | Stock | 46.025 | 46.025 | 46.0 | 46.0 | 1200.0 |
| 2019-05-21 04:42:00 | AAPL | Stock | 46.0 | 46.0 | 46.0 | 46.0 | 1800.0 |
| 2019-05-21 04:43:00 | AAPL | Stock | 46.0 | 46.0 | 46.0 | 46.0 | 5840.0 |
| 2019-05-21 04:44:00 | AAPL | Stock | 45.97 | 45.97 | 45.9525 | 45.9525 | 2524.0 |
| 2019-05-21 05:02:00 | AAPL | Stock | 45.995 | 46.0125 | 45.995 | 46.0125 | 800.0 |
| 2019-05-21 05:03:00 | AAPL | Stock | 46.005 | 46.005 | 45.9925 | 46.0 | 2400.0 |
| 2019-05-21 05:05:00 | AAPL | Stock | 45.955 | 45.97 | 45.94 | 45.9675 | 7564.0 |
| 2019-05-21 05:12:00 | AAPL | Stock | 45.955 | 45.955 | 45.955 | 45.955 | 756.0 |
| 2019-05-21 05:16:00 | AAPL | Stock | 45.9625 | 45.9925 | 45.9625 | 45.9925 | 7240.0 |
| 2019-05-21 05:17:00 | AAPL | Stock | 45.9925 | 46.0 | 45.9425 | 46.0 | 5768.0 |
| 2019-05-21 05:18:00 | AAPL | Stock | 46.015 | 46.125 | 46.015 | 46.125 | 6608.0 |
| 2019-05-21 05:19:00 | AAPL | Stock | 46.165 | 46.165 | 46.165 | 46.165 | 800.0 |
| 2019-05-21 05:22:00 | AAPL | Stock | 46.14 | 46.14 | 46.14 | 46.14 | 400.0 |
| 2019-05-21 05:23:00 | AAPL | Stock | 46.14 | 46.14 | 46.14 | 46.14 | 800.0 |
| 2019-05-21 05:26:00 | AAPL | Stock | 46.14 | 46.14 | 46.13 | 46.13 | 1200.0 |
| 2019-05-21 05:28:00 | AAPL | Stock | 46.1 | 46.1 | 46.0875 | 46.0875 | 1904.0 |
| 2019-05-21 05:33:00 | AAPL | Stock | 46.1875 | 46.1875 | 46.1875 | 46.1875 | 800.0 |
| 2019-05-21 05:40:00 | AAPL | Stock | 46.1675 | 46.1825 | 46.125 | 46.125 | 3424.0 |
| 2019-05-21 05:41:00 | AAPL | Stock | 46.1875 | 46.1875 | 46.1875 | 46.1875 | 800.0 |
| 2019-05-21 05:44:00 | AAPL | Stock | 46.22 | 46.225 | 46.1975 | 46.225 | 8664.0 |
| 2019-05-21 05:51:00 | AAPL | Stock | 46.225 | 46.225 | 46.225 | 46.225 | 1896.0 |
| 2019-05-21 05:54:00 | AAPL | Stock | 46.23 | 46.2375 | 46.23 | 46.2375 | 1980.0 |
| 2019-05-21 05:55:00 | AAPL | Stock | 46.25 | 46.25 | 46.25 | 46.25 | 4316.0 |
| 2019-05-21 05:57:00 | AAPL | Stock | 46.2525 | 46.2525 | 46.2525 | 46.2525 | 1200.0 |
| 2019-05-21 05:58:00 | AAPL | Stock | 46.2775 | 46.2775 | 46.2775 | 46.2775 | 800.0 |
| 2019-05-21 05:59:00 | AAPL | Stock | 46.3 | 46.3 | 46.3 | 46.3 | 3844.0 |
| 2019-05-21 06:01:00 | AAPL | Stock | 46.35 | 46.35 | 46.35 | 46.35 | 1400.0 |
| 2019-05-21 06:02:00 | AAPL | Stock | 46.35 | 46.35 | 46.35 | 46.35 | 1400.0 |
| 2019-05-21 06:04:00 | AAPL | Stock | 46.375 | 46.375 | 46.375 | 46.375 | 1600.0 |
| 2019-05-21 06:10:00 | AAPL | Stock | 46.425 | 46.425 | 46.3925 | 46.3925 | 5836.0 |
| 2019-05-21 06:11:00 | AAPL | Stock | 46.375 | 46.375 | 46.375 | 46.375 | 400.0 |
| 2019-05-21 06:12:00 | AAPL | Stock | 46.375 | 46.375 | 46.3275 | 46.3275 | 7516.0 |
| 2019-05-21 06:16:00 | AAPL | Stock | 46.36 | 46.36 | 46.36 | 46.36 | 460.0 |
| 2019-05-21 06:20:00 | AAPL | Stock | 46.375 | 46.375 | 46.375 | 46.375 | 400.0 |
| 2019-05-21 06:21:00 | AAPL | Stock | 46.3875 | 46.3925 | 46.3875 | 46.3925 | 4000.0 |
| 2019-05-21 06:22:00 | AAPL | Stock | 46.365 | 46.365 | 46.365 | 46.365 | 400.0 |
| 2019-05-21 06:23:00 | AAPL | Stock | 46.3925 | 46.3925 | 46.3925 | 46.3925 | 1200.0 |
| 2019-05-21 06:26:00 | AAPL | Stock | 46.3925 | 46.3925 | 46.3925 | 46.3925 | 400.0 |
| 2019-05-21 06:31:00 | AAPL | Stock | 46.3825 | 46.3975 | 46.3775 | 46.3775 | 2840.0 |
| 2019-05-21 06:32:00 | AAPL | Stock | 46.3925 | 46.3925 | 46.3925 | 46.3925 | 1368.0 |
| 2019-05-21 06:34:00 | AAPL | Stock | 46.38 | 46.38 | 46.38 | 46.38 | 1780.0 |
| 2019-05-21 06:35:00 | AAPL | Stock | 46.3925 | 46.3925 | 46.3925 | 46.3925 | 3200.0 |
| 2019-05-21 06:36:00 | AAPL | Stock | 46.3925 | 46.3925 | 46.3925 | 46.3925 | 400.0 |
| 2019-05-21 06:39:00 | AAPL | Stock | 46.3925 | 46.3925 | 46.3925 | 46.3925 | 5636.0 |
| 2019-05-21 06:40:00 | AAPL | Stock | 46.3925 | 46.3925 | 46.3925 | 46.3925 | 3088.0 |
| 2019-05-21 06:43:00 | AAPL | Stock | 46.46 | 46.46 | 46.46 | 46.46 | 988.0 |
| 2019-05-21 06:44:00 | AAPL | Stock | 46.45 | 46.465 | 46.45 | 46.465 | 4000.0 |
| 2019-05-21 06:45:00 | AAPL | Stock | 46.45 | 46.45 | 46.45 | 46.45 | 520.0 |
| 2019-05-21 06:48:00 | AAPL | Stock | 46.405 | 46.405 | 46.405 | 46.405 | 400.0 |
> showing 50 of 1,070,607 rows — these rows as CSV