PREVIEW / stock_5min / 2024-05-31
file: by_date/stock_5min/2024/2024-05-31.parquet size: 6.6 MB rows: 396,967 symbols: 962
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-31 04:00:00 | AAPL | Stock | 191.0 | 191.08 | 190.66 | 191.0 | 2907.0 |
| 2024-05-31 04:05:00 | AAPL | Stock | 190.9 | 191.11 | 190.9 | 191.0 | 1253.0 |
| 2024-05-31 04:10:00 | AAPL | Stock | 191.02 | 191.12 | 191.02 | 191.12 | 912.0 |
| 2024-05-31 04:15:00 | AAPL | Stock | 191.17 | 191.25 | 191.17 | 191.25 | 1357.0 |
| 2024-05-31 04:20:00 | AAPL | Stock | 191.37 | 191.39 | 191.37 | 191.38 | 1074.0 |
| 2024-05-31 04:25:00 | AAPL | Stock | 191.42 | 191.6 | 191.42 | 191.6 | 1680.0 |
| 2024-05-31 04:30:00 | AAPL | Stock | 191.51 | 191.51 | 191.5 | 191.5 | 200.0 |
| 2024-05-31 04:35:00 | AAPL | Stock | 191.28 | 191.28 | 191.2 | 191.2 | 1149.0 |
| 2024-05-31 04:50:00 | AAPL | Stock | 191.2 | 191.2 | 191.15 | 191.15 | 650.0 |
| 2024-05-31 05:00:00 | AAPL | Stock | 191.03 | 191.03 | 191.0 | 191.0 | 1651.0 |
| 2024-05-31 05:05:00 | AAPL | Stock | 190.95 | 190.95 | 190.8 | 190.8 | 445.0 |
| 2024-05-31 05:10:00 | AAPL | Stock | 190.86 | 190.87 | 190.76 | 190.76 | 1080.0 |
| 2024-05-31 05:20:00 | AAPL | Stock | 190.9 | 190.9 | 190.86 | 190.9 | 606.0 |
| 2024-05-31 05:25:00 | AAPL | Stock | 190.81 | 190.9 | 190.81 | 190.9 | 848.0 |
| 2024-05-31 05:30:00 | AAPL | Stock | 190.95 | 190.95 | 190.95 | 190.95 | 100.0 |
| 2024-05-31 05:35:00 | AAPL | Stock | 190.96 | 190.96 | 190.96 | 190.96 | 100.0 |
| 2024-05-31 05:45:00 | AAPL | Stock | 190.96 | 190.98 | 190.9 | 190.98 | 4137.0 |
| 2024-05-31 06:00:00 | AAPL | Stock | 190.99 | 190.99 | 190.99 | 190.99 | 174.0 |
| 2024-05-31 06:05:00 | AAPL | Stock | 191.04 | 191.04 | 191.03 | 191.03 | 400.0 |
| 2024-05-31 06:20:00 | AAPL | Stock | 191.0 | 191.0 | 191.0 | 191.0 | 144.0 |
| 2024-05-31 06:25:00 | AAPL | Stock | 191.0 | 191.0 | 190.84 | 190.87 | 2445.0 |
| 2024-05-31 06:35:00 | AAPL | Stock | 190.94 | 190.94 | 190.94 | 190.94 | 100.0 |
| 2024-05-31 06:40:00 | AAPL | Stock | 190.91 | 190.95 | 190.9 | 190.9 | 2056.0 |
| 2024-05-31 06:45:00 | AAPL | Stock | 190.9 | 190.9 | 190.81 | 190.81 | 7834.0 |
| 2024-05-31 06:50:00 | AAPL | Stock | 190.81 | 190.81 | 190.53 | 190.54 | 3267.0 |
| 2024-05-31 06:55:00 | AAPL | Stock | 190.64 | 190.68 | 190.64 | 190.68 | 290.0 |
| 2024-05-31 07:00:00 | AAPL | Stock | 190.6 | 190.81 | 190.5 | 190.5 | 15177.0 |
| 2024-05-31 07:05:00 | AAPL | Stock | 190.64 | 190.75 | 190.64 | 190.75 | 2147.0 |
| 2024-05-31 07:10:00 | AAPL | Stock | 190.76 | 190.84 | 190.76 | 190.84 | 936.0 |
| 2024-05-31 07:15:00 | AAPL | Stock | 190.86 | 190.86 | 190.83 | 190.83 | 1026.0 |
| 2024-05-31 07:20:00 | AAPL | Stock | 190.83 | 190.83 | 190.8 | 190.8 | 1890.0 |
| 2024-05-31 07:25:00 | AAPL | Stock | 190.86 | 191.01 | 190.85 | 191.01 | 2023.0 |
| 2024-05-31 07:30:00 | AAPL | Stock | 191.0 | 191.05 | 191.0 | 191.05 | 1479.0 |
| 2024-05-31 07:35:00 | AAPL | Stock | 191.1 | 191.15 | 191.1 | 191.1 | 2801.0 |
| 2024-05-31 07:40:00 | AAPL | Stock | 191.14 | 191.14 | 191.1 | 191.1 | 8908.0 |
| 2024-05-31 07:45:00 | AAPL | Stock | 191.07 | 191.14 | 191.07 | 191.14 | 479.0 |
| 2024-05-31 07:50:00 | AAPL | Stock | 191.05 | 191.05 | 191.0 | 191.0 | 1021.0 |
| 2024-05-31 07:55:00 | AAPL | Stock | 191.15 | 191.2 | 191.15 | 191.2 | 1142.0 |
| 2024-05-31 08:00:00 | AAPL | Stock | 190.84 | 191.38 | 190.5 | 191.28 | 31985.0 |
| 2024-05-31 08:05:00 | AAPL | Stock | 191.39 | 191.4 | 190.99 | 191.4 | 9939.0 |
| 2024-05-31 08:10:00 | AAPL | Stock | 191.49 | 191.54 | 191.4 | 191.4 | 4136.0 |
| 2024-05-31 08:15:00 | AAPL | Stock | 191.4 | 191.4 | 191.3 | 191.3 | 3390.0 |
| 2024-05-31 08:20:00 | AAPL | Stock | 191.35 | 191.5 | 191.35 | 191.5 | 8092.0 |
| 2024-05-31 08:25:00 | AAPL | Stock | 191.5 | 191.6894 | 191.49 | 191.54 | 9538.0 |
| 2024-05-31 08:30:00 | AAPL | Stock | 191.6 | 191.65 | 191.43 | 191.64 | 29348.0 |
| 2024-05-31 08:35:00 | AAPL | Stock | 191.64 | 191.84 | 191.6 | 191.84 | 61517.0 |
| 2024-05-31 08:40:00 | AAPL | Stock | 191.82 | 191.97 | 191.74 | 191.9 | 26405.0 |
| 2024-05-31 08:45:00 | AAPL | Stock | 191.9 | 192.0987 | 191.84 | 192.04 | 23740.0 |
| 2024-05-31 08:50:00 | AAPL | Stock | 192.01 | 192.0983 | 191.5 | 191.7315 | 23240.0 |
| 2024-05-31 08:55:00 | AAPL | Stock | 191.845 | 191.845 | 191.52 | 191.65 | 1726.0 |
> showing 50 of 396,967 rows — these rows as CSV