PREVIEW / stock_1min / 2020-05-19
file: by_date/stock_1min/2020/2020-05-19.parquet size: 18.7 MB rows: 1,261,764 symbols: 2,021
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-05-19 04:00:00 | AAPL | Stock | 79.0025 | 79.0025 | 78.9375 | 78.9375 | 2316.0 |
| 2020-05-19 04:01:00 | AAPL | Stock | 79.0125 | 79.0125 | 79.0125 | 79.0125 | 1060.0 |
| 2020-05-19 04:03:00 | AAPL | Stock | 78.9375 | 78.9375 | 78.9375 | 78.9375 | 3792.0 |
| 2020-05-19 04:06:00 | AAPL | Stock | 78.875 | 78.875 | 78.875 | 78.875 | 1200.0 |
| 2020-05-19 04:07:00 | AAPL | Stock | 78.79 | 78.79 | 78.79 | 78.79 | 400.0 |
| 2020-05-19 04:08:00 | AAPL | Stock | 78.79 | 78.79 | 78.79 | 78.79 | 400.0 |
| 2020-05-19 04:12:00 | AAPL | Stock | 78.685 | 78.685 | 78.65 | 78.65 | 1960.0 |
| 2020-05-19 04:24:00 | AAPL | Stock | 78.625 | 78.625 | 78.625 | 78.625 | 3200.0 |
| 2020-05-19 04:26:00 | AAPL | Stock | 78.5275 | 78.5275 | 78.5275 | 78.5275 | 424.0 |
| 2020-05-19 04:28:00 | AAPL | Stock | 78.585 | 78.585 | 78.515 | 78.515 | 2808.0 |
| 2020-05-19 04:29:00 | AAPL | Stock | 78.5025 | 78.5025 | 78.5025 | 78.5025 | 800.0 |
| 2020-05-19 04:30:00 | AAPL | Stock | 78.5325 | 78.55 | 78.5325 | 78.55 | 1004.0 |
| 2020-05-19 04:31:00 | AAPL | Stock | 78.5825 | 78.5825 | 78.5825 | 78.5825 | 400.0 |
| 2020-05-19 04:32:00 | AAPL | Stock | 78.575 | 78.575 | 78.575 | 78.575 | 400.0 |
| 2020-05-19 04:35:00 | AAPL | Stock | 78.5725 | 78.5725 | 78.5725 | 78.5725 | 400.0 |
| 2020-05-19 04:43:00 | AAPL | Stock | 78.535 | 78.625 | 78.535 | 78.625 | 1600.0 |
| 2020-05-19 04:47:00 | AAPL | Stock | 78.6375 | 78.6375 | 78.6375 | 78.6375 | 800.0 |
| 2020-05-19 04:48:00 | AAPL | Stock | 78.6625 | 78.6625 | 78.6625 | 78.6625 | 800.0 |
| 2020-05-19 04:49:00 | AAPL | Stock | 78.625 | 78.625 | 78.625 | 78.625 | 400.0 |
| 2020-05-19 05:16:00 | AAPL | Stock | 78.6375 | 78.64 | 78.6375 | 78.64 | 1200.0 |
| 2020-05-19 05:23:00 | AAPL | Stock | 78.6175 | 78.6175 | 78.6175 | 78.6175 | 400.0 |
| 2020-05-19 05:41:00 | AAPL | Stock | 78.625 | 78.625 | 78.625 | 78.625 | 1488.0 |
| 2020-05-19 06:02:00 | AAPL | Stock | 78.5375 | 78.5375 | 78.52 | 78.52 | 2740.0 |
| 2020-05-19 06:10:00 | AAPL | Stock | 78.5 | 78.5 | 78.5 | 78.5 | 400.0 |
| 2020-05-19 06:15:00 | AAPL | Stock | 78.5 | 78.5 | 78.5 | 78.5 | 400.0 |
| 2020-05-19 06:19:00 | AAPL | Stock | 78.4125 | 78.4125 | 78.4125 | 78.4125 | 1160.0 |
| 2020-05-19 06:26:00 | AAPL | Stock | 78.3875 | 78.3875 | 78.3875 | 78.3875 | 800.0 |
| 2020-05-19 06:30:00 | AAPL | Stock | 78.425 | 78.425 | 78.425 | 78.425 | 400.0 |
| 2020-05-19 06:44:00 | AAPL | Stock | 78.58 | 78.58 | 78.58 | 78.58 | 400.0 |
| 2020-05-19 06:47:00 | AAPL | Stock | 78.575 | 78.575 | 78.575 | 78.575 | 400.0 |
| 2020-05-19 06:52:00 | AAPL | Stock | 78.61 | 78.61 | 78.575 | 78.575 | 800.0 |
| 2020-05-19 06:58:00 | AAPL | Stock | 78.575 | 78.575 | 78.575 | 78.575 | 600.0 |
| 2020-05-19 07:00:00 | AAPL | Stock | 78.575 | 78.575 | 78.525 | 78.55 | 5516.0 |
| 2020-05-19 07:01:00 | AAPL | Stock | 78.575 | 78.575 | 78.575 | 78.575 | 800.0 |
| 2020-05-19 07:04:00 | AAPL | Stock | 78.6225 | 78.7 | 78.6225 | 78.7 | 4132.0 |
| 2020-05-19 07:05:00 | AAPL | Stock | 78.7 | 78.725 | 78.7 | 78.725 | 2600.0 |
| 2020-05-19 07:06:00 | AAPL | Stock | 78.725 | 78.7375 | 78.725 | 78.7375 | 1204.0 |
| 2020-05-19 07:07:00 | AAPL | Stock | 78.7 | 78.7 | 78.7 | 78.7 | 400.0 |
| 2020-05-19 07:08:00 | AAPL | Stock | 78.72 | 78.7375 | 78.7 | 78.7 | 2636.0 |
| 2020-05-19 07:09:00 | AAPL | Stock | 78.74 | 78.74 | 78.735 | 78.735 | 1172.0 |
| 2020-05-19 07:10:00 | AAPL | Stock | 78.7975 | 78.7975 | 78.7975 | 78.7975 | 800.0 |
| 2020-05-19 07:11:00 | AAPL | Stock | 78.8 | 78.8 | 78.7525 | 78.755 | 2000.0 |
| 2020-05-19 07:12:00 | AAPL | Stock | 78.7925 | 78.7925 | 78.7925 | 78.7925 | 880.0 |
| 2020-05-19 07:14:00 | AAPL | Stock | 78.7775 | 78.7775 | 78.7775 | 78.7775 | 756.0 |
| 2020-05-19 07:16:00 | AAPL | Stock | 78.805 | 78.825 | 78.805 | 78.825 | 800.0 |
| 2020-05-19 07:17:00 | AAPL | Stock | 78.8375 | 78.8375 | 78.8375 | 78.8375 | 936.0 |
| 2020-05-19 07:18:00 | AAPL | Stock | 78.86 | 78.875 | 78.86 | 78.8625 | 5904.0 |
| 2020-05-19 07:19:00 | AAPL | Stock | 78.8625 | 78.8675 | 78.8625 | 78.8675 | 1320.0 |
| 2020-05-19 07:20:00 | AAPL | Stock | 78.9375 | 78.9375 | 78.8625 | 78.88 | 5444.0 |
| 2020-05-19 07:22:00 | AAPL | Stock | 78.9 | 78.905 | 78.9 | 78.905 | 3572.0 |
> showing 50 of 1,261,764 rows — these rows as CSV