PREVIEW / stock_5min / 2022-09-02
file: by_date/stock_5min/2022/2022-09-02.parquet size: 6.7 MB rows: 417,302 symbols: 2,211
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-09-02 04:00:00 | AAPL | Stock | 157.86 | 158.35 | 157.55 | 158.35 | 6954.0 |
| 2022-09-02 04:05:00 | AAPL | Stock | 158.2 | 158.22 | 158.17 | 158.22 | 1248.0 |
| 2022-09-02 04:10:00 | AAPL | Stock | 158.2 | 158.29 | 158.2 | 158.22 | 2157.0 |
| 2022-09-02 04:15:00 | AAPL | Stock | 158.2 | 158.3 | 158.2 | 158.3 | 1824.0 |
| 2022-09-02 04:20:00 | AAPL | Stock | 158.25 | 158.25 | 158.25 | 158.25 | 1246.0 |
| 2022-09-02 04:25:00 | AAPL | Stock | 158.2 | 158.2 | 158.19 | 158.19 | 461.0 |
| 2022-09-02 04:30:00 | AAPL | Stock | 158.28 | 158.3 | 158.28 | 158.3 | 1700.0 |
| 2022-09-02 04:35:00 | AAPL | Stock | 158.26 | 158.26 | 158.26 | 158.26 | 200.0 |
| 2022-09-02 04:40:00 | AAPL | Stock | 158.42 | 158.43 | 158.39 | 158.39 | 742.0 |
| 2022-09-02 04:45:00 | AAPL | Stock | 158.32 | 158.43 | 158.23 | 158.43 | 2008.0 |
| 2022-09-02 04:50:00 | AAPL | Stock | 158.4 | 158.55 | 158.4 | 158.55 | 1874.0 |
| 2022-09-02 04:55:00 | AAPL | Stock | 158.48 | 158.48 | 158.48 | 158.48 | 100.0 |
| 2022-09-02 05:05:00 | AAPL | Stock | 158.26 | 158.28 | 158.2 | 158.2 | 3419.0 |
| 2022-09-02 05:10:00 | AAPL | Stock | 158.23 | 158.25 | 158.21 | 158.22 | 590.0 |
| 2022-09-02 05:15:00 | AAPL | Stock | 158.22 | 158.22 | 158.22 | 158.22 | 821.0 |
| 2022-09-02 05:20:00 | AAPL | Stock | 158.12 | 158.18 | 158.08 | 158.18 | 543.0 |
| 2022-09-02 05:25:00 | AAPL | Stock | 158.15 | 158.15 | 158.1 | 158.1 | 525.0 |
| 2022-09-02 05:30:00 | AAPL | Stock | 158.07 | 158.07 | 158.07 | 158.07 | 100.0 |
| 2022-09-02 05:35:00 | AAPL | Stock | 158.07 | 158.09 | 158.01 | 158.08 | 3068.0 |
| 2022-09-02 05:40:00 | AAPL | Stock | 158.13 | 158.13 | 158.02 | 158.05 | 1759.0 |
| 2022-09-02 05:55:00 | AAPL | Stock | 158.1 | 158.1 | 158.1 | 158.1 | 150.0 |
| 2022-09-02 06:00:00 | AAPL | Stock | 158.17 | 158.17 | 158.17 | 158.17 | 125.0 |
| 2022-09-02 06:05:00 | AAPL | Stock | 158.17 | 158.19 | 158.05 | 158.05 | 5432.0 |
| 2022-09-02 06:10:00 | AAPL | Stock | 158.02 | 158.05 | 158.0 | 158.05 | 2204.0 |
| 2022-09-02 06:15:00 | AAPL | Stock | 158.02 | 158.02 | 157.91 | 157.95 | 5138.0 |
| 2022-09-02 06:20:00 | AAPL | Stock | 157.86 | 157.86 | 157.85 | 157.85 | 290.0 |
| 2022-09-02 06:25:00 | AAPL | Stock | 157.85 | 157.85 | 157.85 | 157.85 | 1383.0 |
| 2022-09-02 06:30:00 | AAPL | Stock | 157.76 | 157.76 | 157.69 | 157.75 | 2623.0 |
| 2022-09-02 06:35:00 | AAPL | Stock | 157.75 | 157.78 | 157.75 | 157.78 | 557.0 |
| 2022-09-02 06:40:00 | AAPL | Stock | 157.79 | 157.8 | 157.79 | 157.8 | 1156.0 |
| 2022-09-02 06:45:00 | AAPL | Stock | 157.85 | 157.85 | 157.85 | 157.85 | 100.0 |
| 2022-09-02 06:55:00 | AAPL | Stock | 157.86 | 157.86 | 157.86 | 157.86 | 250.0 |
| 2022-09-02 07:00:00 | AAPL | Stock | 157.96 | 158.03 | 157.95 | 157.99 | 4584.0 |
| 2022-09-02 07:05:00 | AAPL | Stock | 157.94 | 158.05 | 157.94 | 158.04 | 5515.0 |
| 2022-09-02 07:10:00 | AAPL | Stock | 158.04 | 158.04 | 157.89 | 157.89 | 3497.0 |
| 2022-09-02 07:20:00 | AAPL | Stock | 157.99 | 157.99 | 157.92 | 157.94 | 3484.0 |
| 2022-09-02 07:25:00 | AAPL | Stock | 157.99 | 158.0 | 157.99 | 158.0 | 350.0 |
| 2022-09-02 07:30:00 | AAPL | Stock | 158.03 | 158.03 | 157.98 | 157.98 | 420.0 |
| 2022-09-02 07:35:00 | AAPL | Stock | 158.05 | 158.2 | 158.03 | 158.2 | 4571.0 |
| 2022-09-02 07:40:00 | AAPL | Stock | 158.2 | 158.25 | 158.2 | 158.25 | 3553.0 |
| 2022-09-02 07:45:00 | AAPL | Stock | 158.25 | 158.26 | 158.16 | 158.26 | 2648.0 |
| 2022-09-02 07:50:00 | AAPL | Stock | 158.25 | 158.26 | 158.18 | 158.2 | 14387.0 |
| 2022-09-02 07:55:00 | AAPL | Stock | 158.2 | 158.2 | 158.15 | 158.18 | 2278.0 |
| 2022-09-02 08:00:00 | AAPL | Stock | 158.0 | 158.3 | 157.566 | 158.21 | 70853.0 |
| 2022-09-02 08:05:00 | AAPL | Stock | 158.2 | 158.26 | 158.2 | 158.26 | 17877.0 |
| 2022-09-02 08:10:00 | AAPL | Stock | 158.26 | 158.26 | 158.12 | 158.12 | 11785.0 |
| 2022-09-02 08:15:00 | AAPL | Stock | 158.13 | 158.24 | 158.12 | 158.24 | 13331.0 |
| 2022-09-02 08:20:00 | AAPL | Stock | 158.18 | 158.39 | 158.18 | 158.35 | 14428.0 |
| 2022-09-02 08:25:00 | AAPL | Stock | 158.35 | 158.35 | 158.05 | 158.05 | 14833.0 |
| 2022-09-02 08:30:00 | AAPL | Stock | 158.36 | 159.74 | 158.0 | 159.5 | 193987.0 |
> showing 50 of 417,302 rows — these rows as CSV