PREVIEW / stock_5min / 2023-04-17
file: by_date/stock_5min/2023/2023-04-17.parquet size: 6.8 MB rows: 413,236 symbols: 1,700
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-17 04:00:00 | AAPL | Stock | 165.25 | 165.62 | 165.25 | 165.5 | 3115.0 |
| 2023-04-17 04:05:00 | AAPL | Stock | 165.5 | 165.5 | 165.42 | 165.42 | 2590.0 |
| 2023-04-17 04:10:00 | AAPL | Stock | 165.39 | 165.5 | 165.29 | 165.5 | 8157.0 |
| 2023-04-17 04:15:00 | AAPL | Stock | 165.43 | 165.54 | 165.43 | 165.5 | 3050.0 |
| 2023-04-17 04:20:00 | AAPL | Stock | 165.5 | 165.51 | 165.41 | 165.41 | 5964.0 |
| 2023-04-17 04:30:00 | AAPL | Stock | 165.3 | 165.3 | 165.3 | 165.3 | 130.0 |
| 2023-04-17 04:35:00 | AAPL | Stock | 165.31 | 165.32 | 165.25 | 165.25 | 1265.0 |
| 2023-04-17 04:40:00 | AAPL | Stock | 165.3 | 165.3 | 165.3 | 165.3 | 100.0 |
| 2023-04-17 04:45:00 | AAPL | Stock | 165.26 | 165.27 | 165.26 | 165.27 | 337.0 |
| 2023-04-17 04:50:00 | AAPL | Stock | 165.4 | 165.4 | 165.4 | 165.4 | 178.0 |
| 2023-04-17 04:55:00 | AAPL | Stock | 165.39 | 165.39 | 165.38 | 165.39 | 635.0 |
| 2023-04-17 05:00:00 | AAPL | Stock | 165.39 | 165.39 | 165.39 | 165.39 | 300.0 |
| 2023-04-17 05:05:00 | AAPL | Stock | 165.27 | 165.27 | 165.21 | 165.21 | 1441.0 |
| 2023-04-17 05:10:00 | AAPL | Stock | 165.21 | 165.21 | 165.21 | 165.21 | 260.0 |
| 2023-04-17 05:15:00 | AAPL | Stock | 165.23 | 165.23 | 165.23 | 165.23 | 155.0 |
| 2023-04-17 05:20:00 | AAPL | Stock | 165.13 | 165.14 | 165.13 | 165.14 | 447.0 |
| 2023-04-17 05:30:00 | AAPL | Stock | 165.14 | 165.17 | 165.14 | 165.17 | 452.0 |
| 2023-04-17 05:35:00 | AAPL | Stock | 165.19 | 165.19 | 165.15 | 165.15 | 251.0 |
| 2023-04-17 05:40:00 | AAPL | Stock | 165.1 | 165.1 | 165.08 | 165.08 | 243.0 |
| 2023-04-17 05:45:00 | AAPL | Stock | 165.01 | 165.05 | 164.96 | 165.0 | 506.0 |
| 2023-04-17 05:50:00 | AAPL | Stock | 165.05 | 165.05 | 164.95 | 164.95 | 4375.0 |
| 2023-04-17 06:05:00 | AAPL | Stock | 165.01 | 165.01 | 165.01 | 165.01 | 100.0 |
| 2023-04-17 06:10:00 | AAPL | Stock | 165.0 | 165.24 | 165.0 | 165.24 | 1762.0 |
| 2023-04-17 06:15:00 | AAPL | Stock | 165.24 | 165.35 | 165.24 | 165.35 | 2301.0 |
| 2023-04-17 06:20:00 | AAPL | Stock | 165.33 | 165.35 | 165.33 | 165.35 | 3266.0 |
| 2023-04-17 06:25:00 | AAPL | Stock | 165.21 | 165.3 | 165.21 | 165.3 | 1012.0 |
| 2023-04-17 06:30:00 | AAPL | Stock | 165.37 | 165.4 | 165.37 | 165.4 | 1567.0 |
| 2023-04-17 06:35:00 | AAPL | Stock | 165.38 | 165.4 | 165.38 | 165.4 | 6364.0 |
| 2023-04-17 06:45:00 | AAPL | Stock | 165.42 | 165.5 | 165.42 | 165.5 | 1187.0 |
| 2023-04-17 06:50:00 | AAPL | Stock | 165.5 | 165.6 | 165.5 | 165.6 | 3255.0 |
| 2023-04-17 06:55:00 | AAPL | Stock | 165.56 | 165.65 | 165.56 | 165.65 | 2281.0 |
| 2023-04-17 07:00:00 | AAPL | Stock | 165.52 | 165.99 | 165.5 | 165.99 | 13955.0 |
| 2023-04-17 07:05:00 | AAPL | Stock | 165.88 | 165.93 | 165.8 | 165.93 | 8671.0 |
| 2023-04-17 07:10:00 | AAPL | Stock | 165.83 | 165.83 | 165.71 | 165.71 | 2175.0 |
| 2023-04-17 07:15:00 | AAPL | Stock | 165.76 | 165.76 | 165.62 | 165.62 | 1237.0 |
| 2023-04-17 07:20:00 | AAPL | Stock | 165.61 | 165.61 | 165.55 | 165.57 | 2282.0 |
| 2023-04-17 07:25:00 | AAPL | Stock | 165.55 | 165.55 | 165.5 | 165.5 | 1100.0 |
| 2023-04-17 07:30:00 | AAPL | Stock | 165.53 | 165.55 | 165.31 | 165.4 | 2198.0 |
| 2023-04-17 07:35:00 | AAPL | Stock | 165.46 | 165.51 | 165.3 | 165.3 | 7145.0 |
| 2023-04-17 07:40:00 | AAPL | Stock | 165.25 | 165.33 | 165.2 | 165.33 | 4624.0 |
| 2023-04-17 07:45:00 | AAPL | Stock | 165.35 | 165.46 | 165.35 | 165.46 | 539.0 |
| 2023-04-17 07:50:00 | AAPL | Stock | 165.42 | 165.5 | 165.42 | 165.5 | 2038.0 |
| 2023-04-17 07:55:00 | AAPL | Stock | 165.57 | 165.79 | 165.57 | 165.79 | 3989.0 |
| 2023-04-17 08:00:00 | AAPL | Stock | 165.65 | 165.95 | 164.48 | 165.79 | 53649.0 |
| 2023-04-17 08:05:00 | AAPL | Stock | 165.79 | 165.79 | 165.68 | 165.79 | 10777.0 |
| 2023-04-17 08:10:00 | AAPL | Stock | 165.87 | 166.15 | 165.81 | 166.02 | 21372.0 |
| 2023-04-17 08:15:00 | AAPL | Stock | 166.01 | 166.01 | 165.64 | 165.753 | 12033.0 |
| 2023-04-17 08:20:00 | AAPL | Stock | 165.8 | 165.95 | 165.8 | 165.85 | 17621.0 |
| 2023-04-17 08:25:00 | AAPL | Stock | 165.9 | 165.99 | 165.84 | 165.94 | 17519.0 |
| 2023-04-17 08:30:00 | AAPL | Stock | 165.94 | 166.0 | 165.63 | 165.71 | 72536.0 |
> showing 50 of 413,236 rows — these rows as CSV