PREVIEW / stock_1min / 2020-08-26
file: by_date/stock_1min/2020/2020-08-26.parquet size: 19.7 MB rows: 1,221,667 symbols: 2,075
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-26 04:00:00 | AAPL | Stock | 125.005 | 125.005 | 125.0 | 125.0 | 2588.0 |
| 2020-08-26 04:02:00 | AAPL | Stock | 124.75 | 124.75 | 124.75 | 124.75 | 10812.0 |
| 2020-08-26 04:04:00 | AAPL | Stock | 124.7875 | 124.7875 | 124.775 | 124.775 | 1552.0 |
| 2020-08-26 04:05:00 | AAPL | Stock | 124.7875 | 124.7875 | 124.75 | 124.75 | 1600.0 |
| 2020-08-26 04:06:00 | AAPL | Stock | 124.75 | 124.75 | 124.75 | 124.75 | 1200.0 |
| 2020-08-26 04:20:00 | AAPL | Stock | 124.925 | 124.925 | 124.925 | 124.925 | 424.0 |
| 2020-08-26 04:36:00 | AAPL | Stock | 125.2125 | 125.2125 | 125.2 | 125.2 | 988.0 |
| 2020-08-26 04:38:00 | AAPL | Stock | 125.25 | 125.25 | 125.25 | 125.25 | 1960.0 |
| 2020-08-26 04:40:00 | AAPL | Stock | 125.285 | 125.285 | 125.285 | 125.285 | 400.0 |
| 2020-08-26 04:45:00 | AAPL | Stock | 125.25 | 125.25 | 125.25 | 125.25 | 1848.0 |
| 2020-08-26 04:46:00 | AAPL | Stock | 125.25 | 125.25 | 125.25 | 125.25 | 472.0 |
| 2020-08-26 04:50:00 | AAPL | Stock | 125.1875 | 125.1875 | 125.1875 | 125.1875 | 800.0 |
| 2020-08-26 04:51:00 | AAPL | Stock | 125.1875 | 125.1875 | 125.1875 | 125.1875 | 1468.0 |
| 2020-08-26 04:56:00 | AAPL | Stock | 125.25 | 125.25 | 125.25 | 125.25 | 1196.0 |
| 2020-08-26 04:57:00 | AAPL | Stock | 125.2875 | 125.2875 | 125.2875 | 125.2875 | 428.0 |
| 2020-08-26 04:59:00 | AAPL | Stock | 125.2625 | 125.2625 | 125.2625 | 125.2625 | 400.0 |
| 2020-08-26 05:00:00 | AAPL | Stock | 125.305 | 125.305 | 125.305 | 125.305 | 400.0 |
| 2020-08-26 05:02:00 | AAPL | Stock | 125.35 | 125.35 | 125.35 | 125.35 | 400.0 |
| 2020-08-26 05:04:00 | AAPL | Stock | 125.44 | 125.44 | 125.44 | 125.44 | 400.0 |
| 2020-08-26 05:05:00 | AAPL | Stock | 125.3875 | 125.3875 | 125.3875 | 125.3875 | 400.0 |
| 2020-08-26 05:06:00 | AAPL | Stock | 125.475 | 125.475 | 125.475 | 125.475 | 416.0 |
| 2020-08-26 05:07:00 | AAPL | Stock | 125.5 | 125.5175 | 125.5 | 125.5175 | 800.0 |
| 2020-08-26 05:09:00 | AAPL | Stock | 125.5 | 125.5175 | 125.5 | 125.5175 | 2424.0 |
| 2020-08-26 05:12:00 | AAPL | Stock | 125.45 | 125.45 | 125.275 | 125.275 | 3272.0 |
| 2020-08-26 05:16:00 | AAPL | Stock | 125.365 | 125.365 | 125.365 | 125.365 | 500.0 |
| 2020-08-26 05:18:00 | AAPL | Stock | 125.45 | 125.45 | 125.45 | 125.45 | 856.0 |
| 2020-08-26 05:19:00 | AAPL | Stock | 125.45 | 125.45 | 125.45 | 125.45 | 400.0 |
| 2020-08-26 05:22:00 | AAPL | Stock | 125.485 | 125.485 | 125.485 | 125.485 | 480.0 |
| 2020-08-26 05:31:00 | AAPL | Stock | 125.5 | 125.5 | 125.5 | 125.5 | 824.0 |
| 2020-08-26 05:33:00 | AAPL | Stock | 125.5 | 125.5 | 125.5 | 125.5 | 2684.0 |
| 2020-08-26 05:34:00 | AAPL | Stock | 125.5 | 125.5 | 125.5 | 125.5 | 2008.0 |
| 2020-08-26 05:36:00 | AAPL | Stock | 125.475 | 125.4875 | 125.475 | 125.4875 | 1000.0 |
| 2020-08-26 05:37:00 | AAPL | Stock | 125.4875 | 125.4875 | 125.4875 | 125.4875 | 432.0 |
| 2020-08-26 05:39:00 | AAPL | Stock | 125.415 | 125.415 | 125.415 | 125.415 | 800.0 |
| 2020-08-26 05:49:00 | AAPL | Stock | 125.3075 | 125.3075 | 125.3075 | 125.3075 | 456.0 |
| 2020-08-26 05:52:00 | AAPL | Stock | 125.385 | 125.385 | 125.385 | 125.385 | 400.0 |
| 2020-08-26 05:58:00 | AAPL | Stock | 125.325 | 125.325 | 125.325 | 125.325 | 852.0 |
| 2020-08-26 05:59:00 | AAPL | Stock | 125.325 | 125.325 | 125.325 | 125.325 | 680.0 |
| 2020-08-26 06:00:00 | AAPL | Stock | 125.375 | 125.375 | 125.375 | 125.375 | 796.0 |
| 2020-08-26 06:02:00 | AAPL | Stock | 125.315 | 125.315 | 125.315 | 125.315 | 624.0 |
| 2020-08-26 06:05:00 | AAPL | Stock | 125.415 | 125.435 | 125.415 | 125.435 | 3756.0 |
| 2020-08-26 06:07:00 | AAPL | Stock | 125.5 | 125.5 | 125.5 | 125.5 | 808.0 |
| 2020-08-26 06:13:00 | AAPL | Stock | 125.5 | 125.5 | 125.5 | 125.5 | 964.0 |
| 2020-08-26 06:15:00 | AAPL | Stock | 125.4875 | 125.5 | 125.4875 | 125.5 | 7144.0 |
| 2020-08-26 06:16:00 | AAPL | Stock | 125.5 | 125.75 | 125.5 | 125.75 | 10352.0 |
| 2020-08-26 06:17:00 | AAPL | Stock | 125.7375 | 125.75 | 125.7375 | 125.75 | 2780.0 |
| 2020-08-26 06:18:00 | AAPL | Stock | 125.6525 | 125.6525 | 125.5 | 125.61 | 14680.0 |
| 2020-08-26 06:19:00 | AAPL | Stock | 125.625 | 125.625 | 125.625 | 125.625 | 952.0 |
| 2020-08-26 06:20:00 | AAPL | Stock | 125.6175 | 125.625 | 125.6175 | 125.625 | 3080.0 |
| 2020-08-26 06:21:00 | AAPL | Stock | 125.7125 | 125.725 | 125.7125 | 125.725 | 4796.0 |
> showing 50 of 1,221,667 rows — these rows as CSV