PREVIEW / stock_1min / 2022-10-20
file: by_date/stock_1min/2022/2022-10-20.parquet size: 20.3 MB rows: 1,281,199 symbols: 1,930
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 |
|---|---|---|---|---|---|---|---|
| 2022-10-20 04:00:00 | AAPL | Stock | 142.49 | 142.49 | 142.2 | 142.3 | 5249.0 |
| 2022-10-20 04:03:00 | AAPL | Stock | 142.48 | 142.48 | 142.48 | 142.48 | 101.0 |
| 2022-10-20 04:04:00 | AAPL | Stock | 142.51 | 142.69 | 142.51 | 142.69 | 1176.0 |
| 2022-10-20 04:05:00 | AAPL | Stock | 142.73 | 142.73 | 142.73 | 142.73 | 829.0 |
| 2022-10-20 04:06:00 | AAPL | Stock | 142.8 | 142.8 | 142.8 | 142.8 | 460.0 |
| 2022-10-20 04:07:00 | AAPL | Stock | 142.89 | 142.89 | 142.89 | 142.89 | 113.0 |
| 2022-10-20 04:08:00 | AAPL | Stock | 142.72 | 142.72 | 142.72 | 142.72 | 180.0 |
| 2022-10-20 04:10:00 | AAPL | Stock | 142.75 | 142.75 | 142.69 | 142.69 | 200.0 |
| 2022-10-20 04:11:00 | AAPL | Stock | 142.64 | 142.64 | 142.57 | 142.57 | 662.0 |
| 2022-10-20 04:13:00 | AAPL | Stock | 142.61 | 142.68 | 142.56 | 142.56 | 576.0 |
| 2022-10-20 04:14:00 | AAPL | Stock | 142.52 | 142.54 | 142.52 | 142.54 | 1515.0 |
| 2022-10-20 04:15:00 | AAPL | Stock | 142.55 | 142.55 | 142.55 | 142.55 | 250.0 |
| 2022-10-20 04:16:00 | AAPL | Stock | 142.57 | 142.57 | 142.57 | 142.57 | 100.0 |
| 2022-10-20 04:17:00 | AAPL | Stock | 142.64 | 142.64 | 142.62 | 142.62 | 245.0 |
| 2022-10-20 04:19:00 | AAPL | Stock | 142.77 | 142.79 | 142.77 | 142.79 | 210.0 |
| 2022-10-20 04:21:00 | AAPL | Stock | 142.74 | 142.74 | 142.74 | 142.74 | 100.0 |
| 2022-10-20 04:36:00 | AAPL | Stock | 142.79 | 142.79 | 142.79 | 142.79 | 150.0 |
| 2022-10-20 04:41:00 | AAPL | Stock | 142.79 | 142.79 | 142.79 | 142.79 | 200.0 |
| 2022-10-20 04:42:00 | AAPL | Stock | 142.85 | 142.85 | 142.85 | 142.85 | 157.0 |
| 2022-10-20 04:50:00 | AAPL | Stock | 142.89 | 142.89 | 142.89 | 142.89 | 499.0 |
| 2022-10-20 04:51:00 | AAPL | Stock | 142.87 | 142.9 | 142.87 | 142.9 | 790.0 |
| 2022-10-20 04:54:00 | AAPL | Stock | 142.82 | 142.82 | 142.82 | 142.82 | 191.0 |
| 2022-10-20 05:06:00 | AAPL | Stock | 142.85 | 142.85 | 142.83 | 142.84 | 462.0 |
| 2022-10-20 05:09:00 | AAPL | Stock | 142.95 | 142.95 | 142.95 | 142.95 | 146.0 |
| 2022-10-20 05:17:00 | AAPL | Stock | 142.98 | 143.0 | 142.96 | 143.0 | 901.0 |
| 2022-10-20 05:18:00 | AAPL | Stock | 143.01 | 143.01 | 143.01 | 143.01 | 100.0 |
| 2022-10-20 05:26:00 | AAPL | Stock | 142.86 | 142.86 | 142.86 | 142.86 | 100.0 |
| 2022-10-20 05:27:00 | AAPL | Stock | 142.85 | 142.86 | 142.85 | 142.86 | 2037.0 |
| 2022-10-20 05:32:00 | AAPL | Stock | 142.93 | 142.93 | 142.93 | 142.93 | 100.0 |
| 2022-10-20 05:33:00 | AAPL | Stock | 142.99 | 143.12 | 142.99 | 143.12 | 274.0 |
| 2022-10-20 05:37:00 | AAPL | Stock | 143.03 | 143.12 | 143.03 | 143.12 | 668.0 |
| 2022-10-20 05:38:00 | AAPL | Stock | 143.05 | 143.05 | 143.05 | 143.05 | 160.0 |
| 2022-10-20 05:39:00 | AAPL | Stock | 142.99 | 143.09 | 142.99 | 142.99 | 1667.0 |
| 2022-10-20 05:40:00 | AAPL | Stock | 142.96 | 142.96 | 142.96 | 142.96 | 200.0 |
| 2022-10-20 05:45:00 | AAPL | Stock | 142.92 | 143.0 | 142.92 | 143.0 | 350.0 |
| 2022-10-20 05:46:00 | AAPL | Stock | 143.0 | 143.1 | 142.97 | 143.1 | 2088.0 |
| 2022-10-20 05:50:00 | AAPL | Stock | 143.15 | 143.15 | 143.15 | 143.15 | 400.0 |
| 2022-10-20 05:55:00 | AAPL | Stock | 143.04 | 143.04 | 143.04 | 143.04 | 500.0 |
| 2022-10-20 05:57:00 | AAPL | Stock | 142.99 | 143.0 | 142.99 | 143.0 | 505.0 |
| 2022-10-20 06:02:00 | AAPL | Stock | 143.0 | 143.0 | 143.0 | 143.0 | 100.0 |
| 2022-10-20 06:04:00 | AAPL | Stock | 142.94 | 142.94 | 142.85 | 142.85 | 250.0 |
| 2022-10-20 06:09:00 | AAPL | Stock | 142.9 | 142.9 | 142.87 | 142.87 | 250.0 |
| 2022-10-20 06:10:00 | AAPL | Stock | 142.85 | 142.85 | 142.85 | 142.85 | 160.0 |
| 2022-10-20 06:13:00 | AAPL | Stock | 142.84 | 142.85 | 142.84 | 142.85 | 350.0 |
| 2022-10-20 06:14:00 | AAPL | Stock | 142.8 | 142.8 | 142.8 | 142.8 | 118.0 |
| 2022-10-20 06:15:00 | AAPL | Stock | 142.85 | 142.85 | 142.85 | 142.85 | 100.0 |
| 2022-10-20 06:16:00 | AAPL | Stock | 142.8 | 142.8 | 142.8 | 142.8 | 300.0 |
| 2022-10-20 06:17:00 | AAPL | Stock | 142.8 | 142.81 | 142.8 | 142.81 | 219.0 |
| 2022-10-20 06:23:00 | AAPL | Stock | 142.86 | 142.88 | 142.86 | 142.88 | 300.0 |
| 2022-10-20 06:25:00 | AAPL | Stock | 143.05 | 143.14 | 143.05 | 143.14 | 1919.0 |
> showing 50 of 1,281,199 rows — these rows as CSV