PREVIEW / stock_1min / 2021-08-12
file: by_date/stock_1min/2021/2021-08-12.parquet size: 22.9 MB rows: 1,315,752 symbols: 2,395
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 |
|---|---|---|---|---|---|---|---|
| 2021-08-12 04:00:00 | AAPL | Stock | 145.61 | 145.67 | 145.61 | 145.67 | 1262.0 |
| 2021-08-12 04:02:00 | AAPL | Stock | 145.6 | 145.6 | 145.6 | 145.6 | 492.0 |
| 2021-08-12 04:03:00 | AAPL | Stock | 145.59 | 145.62 | 145.59 | 145.62 | 434.0 |
| 2021-08-12 04:09:00 | AAPL | Stock | 145.55 | 145.55 | 145.51 | 145.51 | 850.0 |
| 2021-08-12 04:12:00 | AAPL | Stock | 145.5 | 145.5 | 145.5 | 145.5 | 281.0 |
| 2021-08-12 04:31:00 | AAPL | Stock | 145.61 | 145.65 | 145.61 | 145.65 | 202.0 |
| 2021-08-12 04:34:00 | AAPL | Stock | 145.69 | 145.69 | 145.69 | 145.69 | 500.0 |
| 2021-08-12 04:35:00 | AAPL | Stock | 145.7 | 145.7 | 145.7 | 145.7 | 117.0 |
| 2021-08-12 04:40:00 | AAPL | Stock | 145.84 | 145.84 | 145.84 | 145.84 | 400.0 |
| 2021-08-12 05:04:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 100.0 |
| 2021-08-12 05:05:00 | AAPL | Stock | 145.76 | 145.76 | 145.76 | 145.76 | 168.0 |
| 2021-08-12 05:09:00 | AAPL | Stock | 145.82 | 145.82 | 145.82 | 145.82 | 100.0 |
| 2021-08-12 05:31:00 | AAPL | Stock | 145.78 | 145.78 | 145.78 | 145.78 | 931.0 |
| 2021-08-12 05:40:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 300.0 |
| 2021-08-12 05:41:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 495.0 |
| 2021-08-12 05:42:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 189.0 |
| 2021-08-12 05:43:00 | AAPL | Stock | 145.76 | 145.76 | 145.76 | 145.76 | 250.0 |
| 2021-08-12 06:14:00 | AAPL | Stock | 145.74 | 145.74 | 145.74 | 145.74 | 130.0 |
| 2021-08-12 06:29:00 | AAPL | Stock | 145.72 | 145.77 | 145.72 | 145.77 | 622.0 |
| 2021-08-12 06:32:00 | AAPL | Stock | 145.8 | 145.8 | 145.8 | 145.8 | 500.0 |
| 2021-08-12 06:40:00 | AAPL | Stock | 145.8 | 145.8 | 145.8 | 145.8 | 239.0 |
| 2021-08-12 06:47:00 | AAPL | Stock | 145.91 | 145.92 | 145.91 | 145.92 | 523.0 |
| 2021-08-12 06:50:00 | AAPL | Stock | 145.92 | 145.92 | 145.92 | 145.92 | 200.0 |
| 2021-08-12 06:56:00 | AAPL | Stock | 145.91 | 145.91 | 145.91 | 145.91 | 100.0 |
| 2021-08-12 06:57:00 | AAPL | Stock | 145.91 | 145.91 | 145.91 | 145.91 | 151.0 |
| 2021-08-12 07:00:00 | AAPL | Stock | 145.9 | 145.96 | 145.9 | 145.96 | 2585.0 |
| 2021-08-12 07:01:00 | AAPL | Stock | 145.85 | 145.85 | 145.85 | 145.85 | 200.0 |
| 2021-08-12 07:02:00 | AAPL | Stock | 145.85 | 145.85 | 145.85 | 145.85 | 780.0 |
| 2021-08-12 07:03:00 | AAPL | Stock | 145.91 | 145.91 | 145.85 | 145.86 | 620.0 |
| 2021-08-12 07:04:00 | AAPL | Stock | 145.85 | 145.85 | 145.85 | 145.85 | 300.0 |
| 2021-08-12 07:05:00 | AAPL | Stock | 145.87 | 145.87 | 145.87 | 145.87 | 100.0 |
| 2021-08-12 07:06:00 | AAPL | Stock | 145.86 | 145.87 | 145.86 | 145.87 | 472.0 |
| 2021-08-12 07:07:00 | AAPL | Stock | 145.91 | 145.99 | 145.91 | 145.99 | 5453.0 |
| 2021-08-12 07:08:00 | AAPL | Stock | 145.99 | 146.04 | 145.99 | 146.04 | 1696.0 |
| 2021-08-12 07:09:00 | AAPL | Stock | 146.05 | 146.05 | 146.05 | 146.05 | 201.0 |
| 2021-08-12 07:10:00 | AAPL | Stock | 146.04 | 146.04 | 146.0 | 146.03 | 1520.0 |
| 2021-08-12 07:11:00 | AAPL | Stock | 145.97 | 146.0 | 145.97 | 146.0 | 200.0 |
| 2021-08-12 07:12:00 | AAPL | Stock | 145.98 | 146.03 | 145.98 | 146.0 | 3711.0 |
| 2021-08-12 07:13:00 | AAPL | Stock | 146.04 | 146.04 | 146.03 | 146.03 | 600.0 |
| 2021-08-12 07:14:00 | AAPL | Stock | 146.01 | 146.01 | 146.0 | 146.0 | 1395.0 |
| 2021-08-12 07:15:00 | AAPL | Stock | 146.01 | 146.01 | 146.01 | 146.01 | 100.0 |
| 2021-08-12 07:17:00 | AAPL | Stock | 146.03 | 146.05 | 146.03 | 146.05 | 2400.0 |
| 2021-08-12 07:18:00 | AAPL | Stock | 146.07 | 146.09 | 146.07 | 146.09 | 1349.0 |
| 2021-08-12 07:19:00 | AAPL | Stock | 146.1 | 146.1 | 146.1 | 146.1 | 990.0 |
| 2021-08-12 07:20:00 | AAPL | Stock | 146.09 | 146.1 | 146.09 | 146.1 | 600.0 |
| 2021-08-12 07:21:00 | AAPL | Stock | 146.08 | 146.08 | 146.08 | 146.08 | 100.0 |
| 2021-08-12 07:22:00 | AAPL | Stock | 146.07 | 146.07 | 146.06 | 146.07 | 899.0 |
| 2021-08-12 07:23:00 | AAPL | Stock | 146.07 | 146.07 | 146.07 | 146.07 | 300.0 |
| 2021-08-12 07:27:00 | AAPL | Stock | 146.07 | 146.07 | 146.07 | 146.07 | 135.0 |
| 2021-08-12 07:28:00 | AAPL | Stock | 146.07 | 146.07 | 146.07 | 146.07 | 100.0 |
> showing 50 of 1,315,752 rows — these rows as CSV