PREVIEW / stock_1min / 2020-04-29
file: by_date/stock_1min/2020/2020-04-29.parquet size: 21.8 MB rows: 1,403,173 symbols: 2,042
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-04-29 04:00:00 | AAPL | Stock | 70.58 | 70.58 | 70.58 | 70.58 | 2824.0 |
| 2020-04-29 04:01:00 | AAPL | Stock | 70.7 | 70.7 | 70.7 | 70.7 | 416.0 |
| 2020-04-29 04:13:00 | AAPL | Stock | 70.5025 | 70.5025 | 70.5025 | 70.5025 | 400.0 |
| 2020-04-29 04:26:00 | AAPL | Stock | 70.5275 | 70.5275 | 70.515 | 70.515 | 1360.0 |
| 2020-04-29 04:31:00 | AAPL | Stock | 70.6475 | 70.6475 | 70.6475 | 70.6475 | 400.0 |
| 2020-04-29 04:40:00 | AAPL | Stock | 70.68 | 70.7 | 70.68 | 70.7 | 800.0 |
| 2020-04-29 04:44:00 | AAPL | Stock | 70.675 | 70.675 | 70.675 | 70.675 | 916.0 |
| 2020-04-29 04:45:00 | AAPL | Stock | 70.695 | 70.695 | 70.695 | 70.695 | 400.0 |
| 2020-04-29 04:46:00 | AAPL | Stock | 70.7 | 70.7 | 70.7 | 70.7 | 576.0 |
| 2020-04-29 04:59:00 | AAPL | Stock | 70.7 | 70.7 | 70.7 | 70.7 | 460.0 |
| 2020-04-29 05:06:00 | AAPL | Stock | 70.63 | 70.63 | 70.63 | 70.63 | 400.0 |
| 2020-04-29 05:09:00 | AAPL | Stock | 70.5475 | 70.55 | 70.5475 | 70.55 | 1200.0 |
| 2020-04-29 05:12:00 | AAPL | Stock | 70.5475 | 70.5475 | 70.5475 | 70.5475 | 952.0 |
| 2020-04-29 05:13:00 | AAPL | Stock | 70.5475 | 70.5475 | 70.5475 | 70.5475 | 452.0 |
| 2020-04-29 05:27:00 | AAPL | Stock | 70.625 | 70.625 | 70.615 | 70.615 | 2684.0 |
| 2020-04-29 05:40:00 | AAPL | Stock | 70.63 | 70.63 | 70.625 | 70.625 | 4400.0 |
| 2020-04-29 05:44:00 | AAPL | Stock | 70.6 | 70.6 | 70.6 | 70.6 | 3968.0 |
| 2020-04-29 05:48:00 | AAPL | Stock | 70.5525 | 70.5525 | 70.5525 | 70.5525 | 400.0 |
| 2020-04-29 05:49:00 | AAPL | Stock | 70.5 | 70.5 | 70.5 | 70.5 | 2888.0 |
| 2020-04-29 05:53:00 | AAPL | Stock | 70.5 | 70.5 | 70.5 | 70.5 | 1200.0 |
| 2020-04-29 06:03:00 | AAPL | Stock | 70.375 | 70.375 | 70.375 | 70.375 | 2572.0 |
| 2020-04-29 06:07:00 | AAPL | Stock | 70.275 | 70.275 | 70.275 | 70.275 | 1600.0 |
| 2020-04-29 06:22:00 | AAPL | Stock | 70.29 | 70.29 | 70.29 | 70.29 | 1228.0 |
| 2020-04-29 06:30:00 | AAPL | Stock | 70.275 | 70.275 | 70.275 | 70.275 | 824.0 |
| 2020-04-29 06:34:00 | AAPL | Stock | 70.2875 | 70.2875 | 70.2875 | 70.2875 | 400.0 |
| 2020-04-29 06:36:00 | AAPL | Stock | 70.275 | 70.275 | 70.275 | 70.275 | 648.0 |
| 2020-04-29 06:42:00 | AAPL | Stock | 70.28 | 70.28 | 70.28 | 70.28 | 3028.0 |
| 2020-04-29 06:43:00 | AAPL | Stock | 70.2775 | 70.2775 | 70.2775 | 70.2775 | 2000.0 |
| 2020-04-29 06:47:00 | AAPL | Stock | 70.3 | 70.3 | 70.3 | 70.3 | 2000.0 |
| 2020-04-29 06:53:00 | AAPL | Stock | 70.3 | 70.3 | 70.3 | 70.3 | 1200.0 |
| 2020-04-29 06:56:00 | AAPL | Stock | 70.37 | 70.375 | 70.37 | 70.375 | 1760.0 |
| 2020-04-29 06:57:00 | AAPL | Stock | 70.365 | 70.37 | 70.365 | 70.37 | 2000.0 |
| 2020-04-29 06:58:00 | AAPL | Stock | 70.375 | 70.375 | 70.375 | 70.375 | 1240.0 |
| 2020-04-29 07:00:00 | AAPL | Stock | 70.3275 | 70.4 | 70.3025 | 70.3775 | 12316.0 |
| 2020-04-29 07:01:00 | AAPL | Stock | 70.3775 | 70.42 | 70.3775 | 70.42 | 4040.0 |
| 2020-04-29 07:02:00 | AAPL | Stock | 70.4225 | 70.425 | 70.4 | 70.4 | 5268.0 |
| 2020-04-29 07:03:00 | AAPL | Stock | 70.41 | 70.45 | 70.41 | 70.45 | 2640.0 |
| 2020-04-29 07:04:00 | AAPL | Stock | 70.4175 | 70.4175 | 70.385 | 70.385 | 8792.0 |
| 2020-04-29 07:05:00 | AAPL | Stock | 70.44 | 70.44 | 70.44 | 70.44 | 624.0 |
| 2020-04-29 07:06:00 | AAPL | Stock | 70.4275 | 70.4375 | 70.4125 | 70.4375 | 2720.0 |
| 2020-04-29 07:08:00 | AAPL | Stock | 70.4 | 70.4 | 70.38 | 70.38 | 3744.0 |
| 2020-04-29 07:09:00 | AAPL | Stock | 70.3575 | 70.3575 | 70.3375 | 70.3375 | 1600.0 |
| 2020-04-29 07:10:00 | AAPL | Stock | 70.35 | 70.365 | 70.35 | 70.365 | 6996.0 |
| 2020-04-29 07:11:00 | AAPL | Stock | 70.38 | 70.38 | 70.38 | 70.38 | 2800.0 |
| 2020-04-29 07:12:00 | AAPL | Stock | 70.3525 | 70.3525 | 70.35 | 70.35 | 1128.0 |
| 2020-04-29 07:13:00 | AAPL | Stock | 70.3825 | 70.3825 | 70.35 | 70.35 | 1536.0 |
| 2020-04-29 07:14:00 | AAPL | Stock | 70.3175 | 70.395 | 70.3175 | 70.3625 | 1624.0 |
| 2020-04-29 07:15:00 | AAPL | Stock | 70.3125 | 70.35 | 70.3025 | 70.305 | 5984.0 |
| 2020-04-29 07:17:00 | AAPL | Stock | 70.2875 | 70.3375 | 70.275 | 70.3375 | 6484.0 |
| 2020-04-29 07:18:00 | AAPL | Stock | 70.275 | 70.275 | 70.2575 | 70.2575 | 2704.0 |
> showing 50 of 1,403,173 rows — these rows as CSV