PREVIEW / stock_5min / 2022-06-23
file: by_date/stock_5min/2022/2022-06-23.parquet size: 7.1 MB rows: 447,712 symbols: 2,320
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-06-23 04:00:00 | AAPL | Stock | 134.21 | 135.18 | 134.21 | 135.18 | 6753.0 |
| 2022-06-23 04:05:00 | AAPL | Stock | 135.17 | 135.56 | 135.17 | 135.5 | 3136.0 |
| 2022-06-23 04:10:00 | AAPL | Stock | 135.62 | 135.95 | 135.62 | 135.87 | 16447.0 |
| 2022-06-23 04:15:00 | AAPL | Stock | 135.79 | 135.81 | 135.7 | 135.75 | 3263.0 |
| 2022-06-23 04:20:00 | AAPL | Stock | 135.72 | 135.79 | 135.72 | 135.72 | 629.0 |
| 2022-06-23 04:25:00 | AAPL | Stock | 135.73 | 135.77 | 135.66 | 135.66 | 1430.0 |
| 2022-06-23 04:30:00 | AAPL | Stock | 135.7 | 135.7 | 135.65 | 135.66 | 3990.0 |
| 2022-06-23 04:35:00 | AAPL | Stock | 135.63 | 135.67 | 135.63 | 135.67 | 1263.0 |
| 2022-06-23 04:40:00 | AAPL | Stock | 135.61 | 135.78 | 135.61 | 135.78 | 2079.0 |
| 2022-06-23 04:45:00 | AAPL | Stock | 135.75 | 135.78 | 135.61 | 135.66 | 1680.0 |
| 2022-06-23 04:50:00 | AAPL | Stock | 135.65 | 135.65 | 135.58 | 135.58 | 3022.0 |
| 2022-06-23 04:55:00 | AAPL | Stock | 135.59 | 135.72 | 135.58 | 135.72 | 925.0 |
| 2022-06-23 05:00:00 | AAPL | Stock | 135.76 | 135.85 | 135.75 | 135.8 | 1776.0 |
| 2022-06-23 05:05:00 | AAPL | Stock | 135.8 | 135.8 | 135.8 | 135.8 | 1544.0 |
| 2022-06-23 05:10:00 | AAPL | Stock | 135.89 | 136.0 | 135.86 | 136.0 | 1677.0 |
| 2022-06-23 05:15:00 | AAPL | Stock | 135.99 | 136.14 | 135.99 | 136.02 | 1517.0 |
| 2022-06-23 05:20:00 | AAPL | Stock | 136.0 | 136.0 | 136.0 | 136.0 | 531.0 |
| 2022-06-23 05:25:00 | AAPL | Stock | 135.94 | 135.98 | 135.81 | 135.81 | 3716.0 |
| 2022-06-23 05:30:00 | AAPL | Stock | 135.81 | 135.81 | 135.8 | 135.8 | 668.0 |
| 2022-06-23 05:35:00 | AAPL | Stock | 135.86 | 135.86 | 135.78 | 135.8 | 1000.0 |
| 2022-06-23 05:40:00 | AAPL | Stock | 135.89 | 135.89 | 135.89 | 135.89 | 500.0 |
| 2022-06-23 05:45:00 | AAPL | Stock | 136.05 | 136.16 | 136.05 | 136.08 | 589.0 |
| 2022-06-23 05:55:00 | AAPL | Stock | 136.07 | 136.3 | 136.07 | 136.3 | 2093.0 |
| 2022-06-23 06:00:00 | AAPL | Stock | 136.23 | 136.3 | 136.23 | 136.29 | 1026.0 |
| 2022-06-23 06:05:00 | AAPL | Stock | 136.24 | 136.3 | 136.24 | 136.3 | 1925.0 |
| 2022-06-23 06:10:00 | AAPL | Stock | 136.3 | 136.42 | 136.3 | 136.3 | 2045.0 |
| 2022-06-23 06:15:00 | AAPL | Stock | 136.23 | 136.23 | 136.23 | 136.23 | 200.0 |
| 2022-06-23 06:20:00 | AAPL | Stock | 136.3 | 136.3 | 136.29 | 136.29 | 998.0 |
| 2022-06-23 06:25:00 | AAPL | Stock | 136.36 | 136.71 | 136.36 | 136.55 | 3862.0 |
| 2022-06-23 06:30:00 | AAPL | Stock | 136.55 | 136.55 | 136.38 | 136.38 | 1745.0 |
| 2022-06-23 06:35:00 | AAPL | Stock | 136.51 | 136.51 | 136.48 | 136.5 | 2045.0 |
| 2022-06-23 06:40:00 | AAPL | Stock | 136.57 | 136.6 | 136.49 | 136.6 | 4513.0 |
| 2022-06-23 06:45:00 | AAPL | Stock | 136.57 | 136.75 | 136.48 | 136.75 | 5298.0 |
| 2022-06-23 06:50:00 | AAPL | Stock | 136.75 | 136.95 | 136.73 | 136.76 | 1522.0 |
| 2022-06-23 06:55:00 | AAPL | Stock | 136.8 | 136.81 | 136.76 | 136.76 | 961.0 |
| 2022-06-23 07:00:00 | AAPL | Stock | 136.77 | 136.78 | 136.35 | 136.45 | 60744.0 |
| 2022-06-23 07:05:00 | AAPL | Stock | 136.5 | 136.54 | 136.4 | 136.46 | 9600.0 |
| 2022-06-23 07:10:00 | AAPL | Stock | 136.46 | 136.46 | 136.36 | 136.44 | 5188.0 |
| 2022-06-23 07:15:00 | AAPL | Stock | 136.44 | 136.58 | 136.44 | 136.56 | 4241.0 |
| 2022-06-23 07:20:00 | AAPL | Stock | 136.54 | 136.74 | 136.54 | 136.66 | 14297.0 |
| 2022-06-23 07:25:00 | AAPL | Stock | 136.6 | 136.94 | 136.59 | 136.94 | 8876.0 |
| 2022-06-23 07:30:00 | AAPL | Stock | 136.81 | 136.84 | 136.58 | 136.58 | 3164.0 |
| 2022-06-23 07:35:00 | AAPL | Stock | 136.62 | 136.7 | 136.62 | 136.63 | 3997.0 |
| 2022-06-23 07:40:00 | AAPL | Stock | 136.65 | 136.65 | 136.42 | 136.62 | 8700.0 |
| 2022-06-23 07:45:00 | AAPL | Stock | 136.56 | 136.85 | 136.54 | 136.65 | 7786.0 |
| 2022-06-23 07:50:00 | AAPL | Stock | 136.65 | 136.74 | 136.63 | 136.67 | 5608.0 |
| 2022-06-23 07:55:00 | AAPL | Stock | 136.65 | 136.65 | 136.58 | 136.6 | 7104.0 |
| 2022-06-23 08:00:00 | AAPL | Stock | 136.5 | 136.9 | 134.65 | 136.46 | 145511.0 |
| 2022-06-23 08:05:00 | AAPL | Stock | 136.4501 | 136.4501 | 136.26 | 136.27 | 32012.0 |
| 2022-06-23 08:10:00 | AAPL | Stock | 136.28 | 136.47 | 136.28 | 136.3 | 31295.0 |
> showing 50 of 447,712 rows — these rows as CSV