PREVIEW / stock_1min / 2020-08-12
file: by_date/stock_1min/2020/2020-08-12.parquet size: 20.7 MB rows: 1,293,456 symbols: 2,064
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-12 04:00:00 | AAPL | Stock | 110.35 | 110.35 | 110.3475 | 110.3475 | 1944.0 |
| 2020-08-12 04:03:00 | AAPL | Stock | 110.4975 | 110.4975 | 110.4975 | 110.4975 | 452.0 |
| 2020-08-12 04:04:00 | AAPL | Stock | 110.54 | 110.54 | 110.54 | 110.54 | 592.0 |
| 2020-08-12 04:05:00 | AAPL | Stock | 110.5375 | 110.5375 | 110.5375 | 110.5375 | 600.0 |
| 2020-08-12 04:08:00 | AAPL | Stock | 110.43 | 110.43 | 110.4225 | 110.4225 | 4000.0 |
| 2020-08-12 04:19:00 | AAPL | Stock | 110.5 | 110.5 | 110.3625 | 110.3625 | 956.0 |
| 2020-08-12 04:22:00 | AAPL | Stock | 110.565 | 110.565 | 110.565 | 110.565 | 400.0 |
| 2020-08-12 04:29:00 | AAPL | Stock | 110.5375 | 110.5375 | 110.5375 | 110.5375 | 1196.0 |
| 2020-08-12 04:32:00 | AAPL | Stock | 110.55 | 110.55 | 110.55 | 110.55 | 400.0 |
| 2020-08-12 04:40:00 | AAPL | Stock | 110.65 | 110.655 | 110.65 | 110.655 | 1600.0 |
| 2020-08-12 05:07:00 | AAPL | Stock | 110.625 | 110.625 | 110.6 | 110.6 | 4640.0 |
| 2020-08-12 05:08:00 | AAPL | Stock | 110.5975 | 110.6 | 110.55 | 110.55 | 2848.0 |
| 2020-08-12 05:11:00 | AAPL | Stock | 110.55 | 110.55 | 110.55 | 110.55 | 760.0 |
| 2020-08-12 05:35:00 | AAPL | Stock | 110.5775 | 110.5775 | 110.5775 | 110.5775 | 400.0 |
| 2020-08-12 05:37:00 | AAPL | Stock | 110.6075 | 110.6075 | 110.6075 | 110.6075 | 400.0 |
| 2020-08-12 05:57:00 | AAPL | Stock | 110.545 | 110.545 | 110.545 | 110.545 | 412.0 |
| 2020-08-12 06:01:00 | AAPL | Stock | 110.515 | 110.515 | 110.515 | 110.515 | 400.0 |
| 2020-08-12 06:05:00 | AAPL | Stock | 110.555 | 110.555 | 110.555 | 110.555 | 400.0 |
| 2020-08-12 06:10:00 | AAPL | Stock | 110.5825 | 110.5825 | 110.5825 | 110.5825 | 480.0 |
| 2020-08-12 06:12:00 | AAPL | Stock | 110.61 | 110.625 | 110.61 | 110.625 | 3804.0 |
| 2020-08-12 06:13:00 | AAPL | Stock | 110.6575 | 110.6575 | 110.6575 | 110.6575 | 528.0 |
| 2020-08-12 06:17:00 | AAPL | Stock | 110.71 | 110.71 | 110.71 | 110.71 | 400.0 |
| 2020-08-12 06:18:00 | AAPL | Stock | 110.63 | 110.63 | 110.575 | 110.575 | 6220.0 |
| 2020-08-12 06:19:00 | AAPL | Stock | 110.57 | 110.57 | 110.55 | 110.55 | 1200.0 |
| 2020-08-12 06:21:00 | AAPL | Stock | 110.5 | 110.5 | 110.5 | 110.5 | 440.0 |
| 2020-08-12 06:22:00 | AAPL | Stock | 110.5 | 110.5 | 110.5 | 110.5 | 2764.0 |
| 2020-08-12 06:23:00 | AAPL | Stock | 110.49 | 110.49 | 110.49 | 110.49 | 408.0 |
| 2020-08-12 06:24:00 | AAPL | Stock | 110.495 | 110.5 | 110.495 | 110.5 | 2800.0 |
| 2020-08-12 06:26:00 | AAPL | Stock | 110.5 | 110.5725 | 110.4975 | 110.5025 | 9340.0 |
| 2020-08-12 06:27:00 | AAPL | Stock | 110.5 | 110.5025 | 110.5 | 110.5 | 5868.0 |
| 2020-08-12 06:29:00 | AAPL | Stock | 110.475 | 110.4875 | 110.475 | 110.4875 | 1200.0 |
| 2020-08-12 06:30:00 | AAPL | Stock | 110.485 | 110.4925 | 110.485 | 110.4925 | 1768.0 |
| 2020-08-12 06:37:00 | AAPL | Stock | 110.545 | 110.55 | 110.495 | 110.495 | 3200.0 |
| 2020-08-12 06:46:00 | AAPL | Stock | 110.5625 | 110.5625 | 110.5625 | 110.5625 | 400.0 |
| 2020-08-12 06:49:00 | AAPL | Stock | 110.5625 | 110.5625 | 110.5625 | 110.5625 | 400.0 |
| 2020-08-12 06:56:00 | AAPL | Stock | 110.6175 | 110.6175 | 110.6175 | 110.6175 | 400.0 |
| 2020-08-12 07:00:00 | AAPL | Stock | 110.615 | 110.625 | 110.5625 | 110.5625 | 16916.0 |
| 2020-08-12 07:01:00 | AAPL | Stock | 110.58 | 110.62 | 110.55 | 110.55 | 9032.0 |
| 2020-08-12 07:02:00 | AAPL | Stock | 110.5675 | 110.6075 | 110.5125 | 110.525 | 8232.0 |
| 2020-08-12 07:03:00 | AAPL | Stock | 110.52 | 110.5625 | 110.5125 | 110.5175 | 8448.0 |
| 2020-08-12 07:04:00 | AAPL | Stock | 110.5025 | 110.5025 | 110.4525 | 110.495 | 20000.0 |
| 2020-08-12 07:05:00 | AAPL | Stock | 110.4975 | 110.5 | 110.4975 | 110.5 | 2616.0 |
| 2020-08-12 07:06:00 | AAPL | Stock | 110.4975 | 110.5 | 110.495 | 110.5 | 2680.0 |
| 2020-08-12 07:07:00 | AAPL | Stock | 110.4875 | 110.4875 | 110.475 | 110.475 | 3528.0 |
| 2020-08-12 07:08:00 | AAPL | Stock | 110.4775 | 110.4775 | 110.475 | 110.475 | 1252.0 |
| 2020-08-12 07:09:00 | AAPL | Stock | 110.475 | 110.5 | 110.475 | 110.5 | 4284.0 |
| 2020-08-12 07:10:00 | AAPL | Stock | 110.5125 | 110.5175 | 110.5 | 110.5175 | 3200.0 |
| 2020-08-12 07:11:00 | AAPL | Stock | 110.5175 | 110.56 | 110.5175 | 110.5175 | 3760.0 |
| 2020-08-12 07:12:00 | AAPL | Stock | 110.55 | 110.555 | 110.55 | 110.555 | 800.0 |
| 2020-08-12 07:13:00 | AAPL | Stock | 110.5525 | 110.5525 | 110.55 | 110.5525 | 6200.0 |
> showing 50 of 1,293,456 rows — these rows as CSV