PREVIEW / stock_1min / 2020-10-29
file: by_date/stock_1min/2020/2020-10-29.parquet size: 20.2 MB rows: 1,268,342 symbols: 2,110
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-10-29 04:00:00 | AAPL | Stock | 112.79 | 113.0 | 112.5 | 112.5 | 4133.0 |
| 2020-10-29 04:01:00 | AAPL | Stock | 112.87 | 113.0 | 112.87 | 113.0 | 1594.0 |
| 2020-10-29 04:02:00 | AAPL | Stock | 113.14 | 113.14 | 112.9 | 113.0 | 1763.0 |
| 2020-10-29 04:03:00 | AAPL | Stock | 113.0 | 113.0 | 113.0 | 113.0 | 200.0 |
| 2020-10-29 04:04:00 | AAPL | Stock | 113.0 | 113.04 | 113.0 | 113.01 | 3697.0 |
| 2020-10-29 04:05:00 | AAPL | Stock | 113.0 | 113.09 | 113.0 | 113.0 | 5008.0 |
| 2020-10-29 04:06:00 | AAPL | Stock | 113.02 | 113.06 | 112.83 | 112.83 | 2450.0 |
| 2020-10-29 04:07:00 | AAPL | Stock | 112.74 | 112.74 | 112.63 | 112.68 | 2775.0 |
| 2020-10-29 04:08:00 | AAPL | Stock | 112.86 | 112.94 | 112.86 | 112.94 | 1197.0 |
| 2020-10-29 04:09:00 | AAPL | Stock | 112.94 | 112.95 | 112.84 | 112.84 | 1518.0 |
| 2020-10-29 04:10:00 | AAPL | Stock | 112.87 | 112.88 | 112.87 | 112.88 | 200.0 |
| 2020-10-29 04:11:00 | AAPL | Stock | 112.8 | 112.88 | 112.8 | 112.8 | 2440.0 |
| 2020-10-29 04:12:00 | AAPL | Stock | 112.8 | 112.8 | 112.8 | 112.8 | 300.0 |
| 2020-10-29 04:13:00 | AAPL | Stock | 112.84 | 112.92 | 112.8 | 112.81 | 2139.0 |
| 2020-10-29 04:14:00 | AAPL | Stock | 112.79 | 112.79 | 112.66 | 112.66 | 979.0 |
| 2020-10-29 04:15:00 | AAPL | Stock | 112.64 | 112.65 | 112.64 | 112.65 | 850.0 |
| 2020-10-29 04:16:00 | AAPL | Stock | 112.63 | 112.63 | 112.55 | 112.55 | 500.0 |
| 2020-10-29 04:17:00 | AAPL | Stock | 112.55 | 112.55 | 112.55 | 112.55 | 800.0 |
| 2020-10-29 04:18:00 | AAPL | Stock | 112.6 | 112.94 | 112.6 | 112.74 | 640.0 |
| 2020-10-29 04:19:00 | AAPL | Stock | 112.7 | 112.7 | 112.6 | 112.65 | 841.0 |
| 2020-10-29 04:20:00 | AAPL | Stock | 112.65 | 112.65 | 112.65 | 112.65 | 2026.0 |
| 2020-10-29 04:21:00 | AAPL | Stock | 112.69 | 112.84 | 112.69 | 112.84 | 1443.0 |
| 2020-10-29 04:22:00 | AAPL | Stock | 112.81 | 112.91 | 112.75 | 112.91 | 1881.0 |
| 2020-10-29 04:23:00 | AAPL | Stock | 112.91 | 113.07 | 112.91 | 113.07 | 2912.0 |
| 2020-10-29 04:25:00 | AAPL | Stock | 112.96 | 112.96 | 112.95 | 112.95 | 200.0 |
| 2020-10-29 04:26:00 | AAPL | Stock | 112.99 | 112.99 | 112.99 | 112.99 | 100.0 |
| 2020-10-29 04:27:00 | AAPL | Stock | 112.98 | 113.0 | 112.98 | 113.0 | 1681.0 |
| 2020-10-29 04:28:00 | AAPL | Stock | 113.02 | 113.05 | 113.02 | 113.05 | 854.0 |
| 2020-10-29 04:29:00 | AAPL | Stock | 112.95 | 112.95 | 112.95 | 112.95 | 600.0 |
| 2020-10-29 04:30:00 | AAPL | Stock | 112.98 | 112.98 | 112.98 | 112.98 | 100.0 |
| 2020-10-29 04:33:00 | AAPL | Stock | 112.98 | 112.98 | 112.98 | 112.98 | 401.0 |
| 2020-10-29 04:34:00 | AAPL | Stock | 113.0 | 113.0 | 113.0 | 113.0 | 231.0 |
| 2020-10-29 04:37:00 | AAPL | Stock | 113.0 | 113.0 | 113.0 | 113.0 | 1046.0 |
| 2020-10-29 04:38:00 | AAPL | Stock | 113.0 | 113.01 | 113.0 | 113.01 | 550.0 |
| 2020-10-29 04:39:00 | AAPL | Stock | 113.05 | 113.07 | 112.99 | 112.99 | 800.0 |
| 2020-10-29 04:40:00 | AAPL | Stock | 113.06 | 113.06 | 113.06 | 113.06 | 220.0 |
| 2020-10-29 04:42:00 | AAPL | Stock | 113.03 | 113.03 | 113.0 | 113.0 | 433.0 |
| 2020-10-29 04:44:00 | AAPL | Stock | 113.02 | 113.02 | 113.02 | 113.02 | 100.0 |
| 2020-10-29 04:45:00 | AAPL | Stock | 113.0 | 113.0 | 112.95 | 112.95 | 434.0 |
| 2020-10-29 04:46:00 | AAPL | Stock | 112.88 | 112.89 | 112.88 | 112.89 | 589.0 |
| 2020-10-29 04:47:00 | AAPL | Stock | 112.84 | 112.92 | 112.83 | 112.92 | 350.0 |
| 2020-10-29 04:48:00 | AAPL | Stock | 112.92 | 112.92 | 112.92 | 112.92 | 100.0 |
| 2020-10-29 04:49:00 | AAPL | Stock | 112.92 | 112.92 | 112.92 | 112.92 | 100.0 |
| 2020-10-29 04:50:00 | AAPL | Stock | 112.92 | 112.92 | 112.92 | 112.92 | 354.0 |
| 2020-10-29 04:51:00 | AAPL | Stock | 112.79 | 112.79 | 112.78 | 112.78 | 799.0 |
| 2020-10-29 04:52:00 | AAPL | Stock | 112.8 | 112.82 | 112.8 | 112.82 | 1596.0 |
| 2020-10-29 04:55:00 | AAPL | Stock | 112.86 | 112.86 | 112.86 | 112.86 | 513.0 |
| 2020-10-29 04:56:00 | AAPL | Stock | 112.79 | 112.88 | 112.79 | 112.88 | 800.0 |
| 2020-10-29 04:57:00 | AAPL | Stock | 112.79 | 112.79 | 112.75 | 112.75 | 1761.0 |
| 2020-10-29 05:00:00 | AAPL | Stock | 112.82 | 112.82 | 112.82 | 112.82 | 900.0 |
> showing 50 of 1,268,342 rows — these rows as CSV