PREVIEW / stock_5min / 2023-05-03
file: by_date/stock_5min/2023/2023-05-03.parquet size: 6.8 MB rows: 420,847 symbols: 1,635
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-05-03 04:00:00 | AAPL | Stock | 168.75 | 168.75 | 168.6 | 168.63 | 1662.0 |
| 2023-05-03 04:05:00 | AAPL | Stock | 168.79 | 168.79 | 168.79 | 168.79 | 650.0 |
| 2023-05-03 04:10:00 | AAPL | Stock | 168.79 | 168.79 | 168.67 | 168.68 | 1119.0 |
| 2023-05-03 04:15:00 | AAPL | Stock | 168.7 | 168.72 | 168.7 | 168.72 | 451.0 |
| 2023-05-03 04:20:00 | AAPL | Stock | 168.69 | 168.69 | 168.69 | 168.69 | 230.0 |
| 2023-05-03 04:25:00 | AAPL | Stock | 168.69 | 168.73 | 168.69 | 168.69 | 1190.0 |
| 2023-05-03 04:30:00 | AAPL | Stock | 168.69 | 168.74 | 168.69 | 168.74 | 523.0 |
| 2023-05-03 04:35:00 | AAPL | Stock | 168.74 | 168.84 | 168.74 | 168.84 | 7076.0 |
| 2023-05-03 04:40:00 | AAPL | Stock | 168.88 | 168.91 | 168.88 | 168.91 | 863.0 |
| 2023-05-03 04:45:00 | AAPL | Stock | 168.88 | 168.88 | 168.85 | 168.88 | 800.0 |
| 2023-05-03 04:50:00 | AAPL | Stock | 168.85 | 168.93 | 168.85 | 168.87 | 1340.0 |
| 2023-05-03 04:55:00 | AAPL | Stock | 168.87 | 168.87 | 168.87 | 168.87 | 308.0 |
| 2023-05-03 05:05:00 | AAPL | Stock | 168.87 | 168.87 | 168.87 | 168.87 | 399.0 |
| 2023-05-03 05:15:00 | AAPL | Stock | 168.9 | 168.9 | 168.89 | 168.89 | 200.0 |
| 2023-05-03 05:20:00 | AAPL | Stock | 168.9 | 168.9 | 168.9 | 168.9 | 296.0 |
| 2023-05-03 05:25:00 | AAPL | Stock | 168.9 | 168.9 | 168.9 | 168.9 | 170.0 |
| 2023-05-03 05:35:00 | AAPL | Stock | 168.85 | 168.85 | 168.84 | 168.84 | 939.0 |
| 2023-05-03 05:40:00 | AAPL | Stock | 168.86 | 168.88 | 168.86 | 168.88 | 1152.0 |
| 2023-05-03 05:45:00 | AAPL | Stock | 168.91 | 168.94 | 168.86 | 168.94 | 1274.0 |
| 2023-05-03 05:50:00 | AAPL | Stock | 168.93 | 168.95 | 168.93 | 168.95 | 208.0 |
| 2023-05-03 05:55:00 | AAPL | Stock | 168.95 | 168.96 | 168.95 | 168.95 | 992.0 |
| 2023-05-03 06:00:00 | AAPL | Stock | 168.94 | 169.02 | 168.94 | 169.02 | 2072.0 |
| 2023-05-03 06:05:00 | AAPL | Stock | 169.11 | 169.11 | 169.01 | 169.01 | 1537.0 |
| 2023-05-03 06:10:00 | AAPL | Stock | 169.05 | 169.15 | 169.05 | 169.15 | 2561.0 |
| 2023-05-03 06:15:00 | AAPL | Stock | 169.12 | 169.2 | 169.12 | 169.2 | 2874.0 |
| 2023-05-03 06:20:00 | AAPL | Stock | 169.2 | 169.3 | 169.2 | 169.24 | 5537.0 |
| 2023-05-03 06:25:00 | AAPL | Stock | 169.13 | 169.15 | 169.13 | 169.15 | 513.0 |
| 2023-05-03 06:30:00 | AAPL | Stock | 169.14 | 169.19 | 169.09 | 169.19 | 1157.0 |
| 2023-05-03 06:35:00 | AAPL | Stock | 169.19 | 169.29 | 169.19 | 169.27 | 753.0 |
| 2023-05-03 06:40:00 | AAPL | Stock | 169.26 | 169.3 | 169.2 | 169.23 | 4401.0 |
| 2023-05-03 06:45:00 | AAPL | Stock | 169.24 | 169.24 | 169.2 | 169.2 | 530.0 |
| 2023-05-03 06:50:00 | AAPL | Stock | 169.1 | 169.1 | 169.1 | 169.1 | 1009.0 |
| 2023-05-03 06:55:00 | AAPL | Stock | 169.03 | 169.03 | 169.03 | 169.03 | 1000.0 |
| 2023-05-03 07:00:00 | AAPL | Stock | 169.05 | 169.13 | 169.05 | 169.1 | 2124.0 |
| 2023-05-03 07:05:00 | AAPL | Stock | 169.1 | 169.23 | 169.1 | 169.23 | 3471.0 |
| 2023-05-03 07:10:00 | AAPL | Stock | 169.22 | 169.23 | 169.22 | 169.23 | 493.0 |
| 2023-05-03 07:15:00 | AAPL | Stock | 169.19 | 169.23 | 169.19 | 169.23 | 2372.0 |
| 2023-05-03 07:25:00 | AAPL | Stock | 169.2 | 169.2 | 169.2 | 169.2 | 1342.0 |
| 2023-05-03 07:30:00 | AAPL | Stock | 169.23 | 169.24 | 169.2 | 169.2 | 5314.0 |
| 2023-05-03 07:35:00 | AAPL | Stock | 169.2 | 169.22 | 169.19 | 169.21 | 7056.0 |
| 2023-05-03 07:40:00 | AAPL | Stock | 169.22 | 169.37 | 169.22 | 169.37 | 9655.0 |
| 2023-05-03 07:45:00 | AAPL | Stock | 169.22 | 169.22 | 169.19 | 169.19 | 1460.0 |
| 2023-05-03 07:50:00 | AAPL | Stock | 169.14 | 169.15 | 169.1 | 169.1 | 5775.0 |
| 2023-05-03 08:00:00 | AAPL | Stock | 169.0563 | 169.3502 | 167.04 | 169.15 | 38829.0 |
| 2023-05-03 08:05:00 | AAPL | Stock | 169.12 | 169.17 | 169.11 | 169.1121 | 3677.0 |
| 2023-05-03 08:10:00 | AAPL | Stock | 169.17 | 169.23 | 169.17 | 169.19 | 2501.0 |
| 2023-05-03 08:15:00 | AAPL | Stock | 169.15 | 169.3 | 169.12 | 169.28 | 12489.0 |
| 2023-05-03 08:20:00 | AAPL | Stock | 169.28 | 169.3 | 169.12 | 169.12 | 16895.0 |
| 2023-05-03 08:25:00 | AAPL | Stock | 169.17 | 169.17 | 169.03 | 169.17 | 14271.0 |
| 2023-05-03 08:30:00 | AAPL | Stock | 169.1427 | 169.2 | 169.11 | 169.11 | 2533.0 |
> showing 50 of 420,847 rows — these rows as CSV