PREVIEW / stock_5min / 2022-09-19
file: by_date/stock_5min/2022/2022-09-19.parquet size: 6.9 MB rows: 427,893 symbols: 2,237
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-19 04:00:00 | AAPL | Stock | 149.97 | 149.97 | 149.02 | 149.39 | 16203.0 |
| 2022-09-19 04:05:00 | AAPL | Stock | 149.32 | 149.44 | 149.23 | 149.44 | 3752.0 |
| 2022-09-19 04:10:00 | AAPL | Stock | 149.48 | 149.53 | 149.48 | 149.51 | 4174.0 |
| 2022-09-19 04:15:00 | AAPL | Stock | 149.51 | 149.51 | 149.43 | 149.46 | 1852.0 |
| 2022-09-19 04:20:00 | AAPL | Stock | 149.48 | 149.48 | 149.38 | 149.38 | 925.0 |
| 2022-09-19 04:25:00 | AAPL | Stock | 149.52 | 149.55 | 149.52 | 149.55 | 469.0 |
| 2022-09-19 04:30:00 | AAPL | Stock | 149.5 | 149.5 | 149.5 | 149.5 | 464.0 |
| 2022-09-19 04:35:00 | AAPL | Stock | 149.42 | 149.42 | 149.35 | 149.35 | 600.0 |
| 2022-09-19 04:40:00 | AAPL | Stock | 149.35 | 149.35 | 149.3 | 149.3 | 500.0 |
| 2022-09-19 04:45:00 | AAPL | Stock | 149.15 | 149.2 | 149.15 | 149.2 | 828.0 |
| 2022-09-19 04:50:00 | AAPL | Stock | 149.2 | 149.2 | 149.19 | 149.2 | 1125.0 |
| 2022-09-19 05:05:00 | AAPL | Stock | 149.24 | 149.31 | 149.2 | 149.27 | 2290.0 |
| 2022-09-19 05:10:00 | AAPL | Stock | 149.21 | 149.3 | 149.21 | 149.26 | 2738.0 |
| 2022-09-19 05:15:00 | AAPL | Stock | 149.25 | 149.3 | 149.04 | 149.04 | 4888.0 |
| 2022-09-19 05:20:00 | AAPL | Stock | 149.04 | 149.16 | 149.01 | 149.16 | 3406.0 |
| 2022-09-19 05:25:00 | AAPL | Stock | 149.16 | 149.16 | 149.16 | 149.16 | 130.0 |
| 2022-09-19 05:30:00 | AAPL | Stock | 149.09 | 149.1 | 149.04 | 149.04 | 2920.0 |
| 2022-09-19 05:35:00 | AAPL | Stock | 149.04 | 149.15 | 149.04 | 149.08 | 1164.0 |
| 2022-09-19 05:40:00 | AAPL | Stock | 149.08 | 149.19 | 149.08 | 149.1 | 807.0 |
| 2022-09-19 05:45:00 | AAPL | Stock | 149.1 | 149.1 | 149.05 | 149.05 | 300.0 |
| 2022-09-19 05:50:00 | AAPL | Stock | 149.11 | 149.18 | 149.06 | 149.18 | 936.0 |
| 2022-09-19 05:55:00 | AAPL | Stock | 149.09 | 149.17 | 149.05 | 149.17 | 8594.0 |
| 2022-09-19 06:00:00 | AAPL | Stock | 149.09 | 149.09 | 149.0 | 149.0 | 2140.0 |
| 2022-09-19 06:05:00 | AAPL | Stock | 148.88 | 148.92 | 148.82 | 148.91 | 1749.0 |
| 2022-09-19 06:10:00 | AAPL | Stock | 148.92 | 148.92 | 148.89 | 148.89 | 690.0 |
| 2022-09-19 06:15:00 | AAPL | Stock | 148.86 | 148.86 | 148.71 | 148.8 | 9761.0 |
| 2022-09-19 06:20:00 | AAPL | Stock | 148.8 | 148.87 | 148.8 | 148.87 | 1182.0 |
| 2022-09-19 06:25:00 | AAPL | Stock | 148.92 | 148.93 | 148.92 | 148.92 | 4641.0 |
| 2022-09-19 06:30:00 | AAPL | Stock | 148.85 | 149.09 | 148.85 | 149.09 | 1565.0 |
| 2022-09-19 06:35:00 | AAPL | Stock | 149.07 | 149.07 | 149.07 | 149.07 | 100.0 |
| 2022-09-19 06:45:00 | AAPL | Stock | 148.97 | 149.04 | 148.97 | 149.04 | 557.0 |
| 2022-09-19 06:50:00 | AAPL | Stock | 149.05 | 149.05 | 149.05 | 149.05 | 100.0 |
| 2022-09-19 06:55:00 | AAPL | Stock | 149.05 | 149.2 | 149.05 | 149.2 | 12954.0 |
| 2022-09-19 07:00:00 | AAPL | Stock | 149.2 | 149.31 | 149.1 | 149.22 | 21460.0 |
| 2022-09-19 07:05:00 | AAPL | Stock | 149.17 | 149.29 | 149.04 | 149.2 | 32231.0 |
| 2022-09-19 07:10:00 | AAPL | Stock | 149.21 | 149.29 | 149.17 | 149.29 | 3226.0 |
| 2022-09-19 07:15:00 | AAPL | Stock | 149.25 | 149.31 | 149.25 | 149.3 | 1513.0 |
| 2022-09-19 07:20:00 | AAPL | Stock | 149.29 | 149.29 | 149.15 | 149.15 | 19573.0 |
| 2022-09-19 07:25:00 | AAPL | Stock | 149.16 | 149.2 | 149.15 | 149.15 | 4435.0 |
| 2022-09-19 07:30:00 | AAPL | Stock | 149.16 | 149.25 | 149.14 | 149.25 | 3812.0 |
| 2022-09-19 07:35:00 | AAPL | Stock | 149.27 | 149.42 | 149.27 | 149.32 | 972.0 |
| 2022-09-19 07:40:00 | AAPL | Stock | 149.32 | 149.32 | 149.18 | 149.2 | 3143.0 |
| 2022-09-19 07:45:00 | AAPL | Stock | 149.19 | 149.26 | 149.19 | 149.22 | 1829.0 |
| 2022-09-19 07:50:00 | AAPL | Stock | 149.2 | 149.4 | 149.19 | 149.37 | 6034.0 |
| 2022-09-19 07:55:00 | AAPL | Stock | 149.31 | 149.35 | 149.1 | 149.15 | 7093.0 |
| 2022-09-19 08:00:00 | AAPL | Stock | 149.17 | 149.42 | 149.0412 | 149.26 | 71828.0 |
| 2022-09-19 08:05:00 | AAPL | Stock | 149.31 | 149.47 | 149.28 | 149.46 | 20705.0 |
| 2022-09-19 08:10:00 | AAPL | Stock | 149.46 | 149.59 | 149.39 | 149.44 | 15165.0 |
| 2022-09-19 08:15:00 | AAPL | Stock | 149.43 | 149.43 | 149.3131 | 149.35 | 4026.0 |
| 2022-09-19 08:20:00 | AAPL | Stock | 149.38 | 149.48 | 149.35 | 149.47 | 6176.0 |
> showing 50 of 427,893 rows — these rows as CSV