PREVIEW / stock_5min / 2022-09-30
file: by_date/stock_5min/2022/2022-09-30.parquet size: 6.8 MB rows: 427,406 symbols: 2,223
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-30 04:00:00 | AAPL | Stock | 143.59 | 143.59 | 143.1 | 143.32 | 7768.0 |
| 2022-09-30 04:05:00 | AAPL | Stock | 143.38 | 143.39 | 143.0 | 143.02 | 5058.0 |
| 2022-09-30 04:10:00 | AAPL | Stock | 143.13 | 143.2 | 143.13 | 143.2 | 295.0 |
| 2022-09-30 04:15:00 | AAPL | Stock | 143.25 | 143.39 | 143.2 | 143.31 | 11258.0 |
| 2022-09-30 04:20:00 | AAPL | Stock | 143.31 | 143.35 | 143.2 | 143.3 | 5600.0 |
| 2022-09-30 04:25:00 | AAPL | Stock | 143.35 | 143.49 | 143.3 | 143.3 | 1020.0 |
| 2022-09-30 04:30:00 | AAPL | Stock | 143.3 | 143.3 | 143.22 | 143.23 | 1853.0 |
| 2022-09-30 04:35:00 | AAPL | Stock | 143.24 | 143.24 | 143.02 | 143.19 | 15129.0 |
| 2022-09-30 04:40:00 | AAPL | Stock | 143.21 | 143.32 | 143.2 | 143.32 | 13705.0 |
| 2022-09-30 04:45:00 | AAPL | Stock | 143.32 | 143.34 | 143.3 | 143.34 | 4021.0 |
| 2022-09-30 04:50:00 | AAPL | Stock | 143.3 | 143.5 | 143.3 | 143.5 | 3401.0 |
| 2022-09-30 04:55:00 | AAPL | Stock | 143.45 | 143.58 | 143.45 | 143.54 | 1209.0 |
| 2022-09-30 05:00:00 | AAPL | Stock | 143.41 | 143.41 | 143.2 | 143.38 | 6528.0 |
| 2022-09-30 05:05:00 | AAPL | Stock | 143.4 | 143.4 | 143.35 | 143.39 | 4509.0 |
| 2022-09-30 05:10:00 | AAPL | Stock | 143.39 | 143.4 | 143.32 | 143.4 | 1101.0 |
| 2022-09-30 05:15:00 | AAPL | Stock | 143.31 | 143.38 | 143.06 | 143.06 | 15131.0 |
| 2022-09-30 05:20:00 | AAPL | Stock | 143.06 | 143.1 | 143.0 | 143.05 | 3835.0 |
| 2022-09-30 05:25:00 | AAPL | Stock | 143.21 | 143.38 | 143.1 | 143.38 | 13661.0 |
| 2022-09-30 05:30:00 | AAPL | Stock | 143.25 | 143.3 | 143.2 | 143.3 | 7425.0 |
| 2022-09-30 05:35:00 | AAPL | Stock | 143.3 | 143.3 | 143.04 | 143.04 | 4327.0 |
| 2022-09-30 05:40:00 | AAPL | Stock | 143.03 | 143.05 | 143.02 | 143.04 | 1651.0 |
| 2022-09-30 05:45:00 | AAPL | Stock | 143.04 | 143.16 | 143.04 | 143.16 | 550.0 |
| 2022-09-30 05:50:00 | AAPL | Stock | 143.15 | 143.15 | 143.15 | 143.15 | 300.0 |
| 2022-09-30 05:55:00 | AAPL | Stock | 143.1 | 143.1 | 142.89 | 142.89 | 1212.0 |
| 2022-09-30 06:00:00 | AAPL | Stock | 143.03 | 143.25 | 143.0 | 143.25 | 2397.0 |
| 2022-09-30 06:05:00 | AAPL | Stock | 143.26 | 143.3 | 143.11 | 143.25 | 4297.0 |
| 2022-09-30 06:10:00 | AAPL | Stock | 143.3 | 143.3 | 143.25 | 143.3 | 4298.0 |
| 2022-09-30 06:15:00 | AAPL | Stock | 143.28 | 143.36 | 143.25 | 143.25 | 2775.0 |
| 2022-09-30 06:20:00 | AAPL | Stock | 143.16 | 143.21 | 143.15 | 143.18 | 2953.0 |
| 2022-09-30 06:25:00 | AAPL | Stock | 143.2 | 143.51 | 143.19 | 143.4 | 13825.0 |
| 2022-09-30 06:30:00 | AAPL | Stock | 143.27 | 143.27 | 143.2 | 143.27 | 2310.0 |
| 2022-09-30 06:35:00 | AAPL | Stock | 143.3 | 143.3 | 143.3 | 143.3 | 100.0 |
| 2022-09-30 06:40:00 | AAPL | Stock | 143.32 | 143.32 | 143.16 | 143.25 | 2308.0 |
| 2022-09-30 06:45:00 | AAPL | Stock | 143.16 | 143.16 | 143.06 | 143.06 | 23380.0 |
| 2022-09-30 06:50:00 | AAPL | Stock | 143.03 | 143.04 | 142.8 | 142.8 | 3673.0 |
| 2022-09-30 06:55:00 | AAPL | Stock | 142.8 | 142.86 | 142.76 | 142.79 | 2569.0 |
| 2022-09-30 07:00:00 | AAPL | Stock | 142.85 | 142.94 | 142.6 | 142.6 | 26464.0 |
| 2022-09-30 07:05:00 | AAPL | Stock | 142.53 | 142.53 | 142.24 | 142.26 | 19958.0 |
| 2022-09-30 07:10:00 | AAPL | Stock | 142.26 | 142.37 | 142.2 | 142.3 | 18891.0 |
| 2022-09-30 07:15:00 | AAPL | Stock | 142.32 | 142.49 | 142.32 | 142.38 | 10977.0 |
| 2022-09-30 07:20:00 | AAPL | Stock | 142.3 | 142.39 | 142.29 | 142.38 | 8064.0 |
| 2022-09-30 07:25:00 | AAPL | Stock | 142.32 | 142.44 | 142.28 | 142.44 | 3998.0 |
| 2022-09-30 07:30:00 | AAPL | Stock | 142.44 | 142.5 | 142.2 | 142.23 | 16979.0 |
| 2022-09-30 07:35:00 | AAPL | Stock | 142.23 | 142.28 | 141.87 | 141.96 | 23616.0 |
| 2022-09-30 07:40:00 | AAPL | Stock | 141.97 | 142.15 | 141.97 | 142.1 | 10106.0 |
| 2022-09-30 07:45:00 | AAPL | Stock | 142.0 | 142.0 | 141.79 | 141.9 | 16811.0 |
| 2022-09-30 07:50:00 | AAPL | Stock | 141.94 | 141.99 | 141.79 | 141.97 | 5846.0 |
| 2022-09-30 07:55:00 | AAPL | Stock | 141.93 | 142.01 | 141.93 | 141.96 | 16866.0 |
| 2022-09-30 08:00:00 | AAPL | Stock | 142.9238 | 143.3988 | 141.8 | 142.03 | 109413.0 |
| 2022-09-30 08:05:00 | AAPL | Stock | 142.0886 | 142.0886 | 141.86 | 141.94 | 18978.0 |
> showing 50 of 427,406 rows — these rows as CSV