PREVIEW / stock_5min / 2024-05-20
file: by_date/stock_5min/2024/2024-05-20.parquet size: 6.7 MB rows: 400,007 symbols: 969
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-20 04:00:00 | AAPL | Stock | 189.84 | 189.89 | 189.72 | 189.85 | 500.0 |
| 2024-05-20 04:05:00 | AAPL | Stock | 189.8 | 189.86 | 189.8 | 189.86 | 697.0 |
| 2024-05-20 04:10:00 | AAPL | Stock | 189.9 | 189.99 | 189.9 | 189.95 | 1767.0 |
| 2024-05-20 04:15:00 | AAPL | Stock | 190.0 | 190.06 | 190.0 | 190.06 | 931.0 |
| 2024-05-20 04:20:00 | AAPL | Stock | 190.09 | 190.1 | 190.09 | 190.1 | 868.0 |
| 2024-05-20 04:25:00 | AAPL | Stock | 190.06 | 190.06 | 190.06 | 190.06 | 250.0 |
| 2024-05-20 04:30:00 | AAPL | Stock | 190.0 | 190.0 | 190.0 | 190.0 | 1347.0 |
| 2024-05-20 04:50:00 | AAPL | Stock | 189.87 | 189.88 | 189.87 | 189.88 | 212.0 |
| 2024-05-20 04:55:00 | AAPL | Stock | 189.9 | 189.9 | 189.9 | 189.9 | 637.0 |
| 2024-05-20 05:05:00 | AAPL | Stock | 189.79 | 189.79 | 189.79 | 189.79 | 154.0 |
| 2024-05-20 05:10:00 | AAPL | Stock | 189.79 | 189.79 | 189.62 | 189.75 | 1178.0 |
| 2024-05-20 05:15:00 | AAPL | Stock | 189.77 | 189.77 | 189.62 | 189.62 | 2625.0 |
| 2024-05-20 05:20:00 | AAPL | Stock | 189.6 | 189.6 | 189.37 | 189.37 | 1681.0 |
| 2024-05-20 05:25:00 | AAPL | Stock | 189.43 | 189.43 | 189.3 | 189.32 | 1578.0 |
| 2024-05-20 05:30:00 | AAPL | Stock | 189.3 | 189.33 | 189.05 | 189.18 | 7644.0 |
| 2024-05-20 05:35:00 | AAPL | Stock | 189.12 | 189.17 | 189.1 | 189.1 | 4277.0 |
| 2024-05-20 05:40:00 | AAPL | Stock | 189.01 | 189.02 | 188.53 | 188.61 | 8407.0 |
| 2024-05-20 05:45:00 | AAPL | Stock | 188.69 | 188.8 | 188.69 | 188.8 | 825.0 |
| 2024-05-20 05:50:00 | AAPL | Stock | 188.81 | 188.85 | 188.8 | 188.82 | 1450.0 |
| 2024-05-20 05:55:00 | AAPL | Stock | 188.73 | 188.73 | 188.66 | 188.66 | 1450.0 |
| 2024-05-20 06:00:00 | AAPL | Stock | 188.66 | 188.66 | 188.31 | 188.4 | 6421.0 |
| 2024-05-20 06:05:00 | AAPL | Stock | 188.31 | 188.59 | 188.27 | 188.5 | 2196.0 |
| 2024-05-20 06:15:00 | AAPL | Stock | 188.55 | 188.57 | 188.5 | 188.55 | 1094.0 |
| 2024-05-20 06:20:00 | AAPL | Stock | 188.53 | 188.55 | 188.5 | 188.5 | 753.0 |
| 2024-05-20 06:25:00 | AAPL | Stock | 188.43 | 188.43 | 188.43 | 188.43 | 305.0 |
| 2024-05-20 06:30:00 | AAPL | Stock | 188.5 | 188.52 | 188.5 | 188.51 | 532.0 |
| 2024-05-20 06:35:00 | AAPL | Stock | 188.52 | 188.7 | 188.52 | 188.7 | 1218.0 |
| 2024-05-20 06:40:00 | AAPL | Stock | 188.65 | 188.65 | 188.65 | 188.65 | 173.0 |
| 2024-05-20 06:45:00 | AAPL | Stock | 188.88 | 188.88 | 188.88 | 188.88 | 774.0 |
| 2024-05-20 06:55:00 | AAPL | Stock | 188.77 | 188.77 | 188.72 | 188.72 | 413.0 |
| 2024-05-20 07:00:00 | AAPL | Stock | 188.75 | 189.2 | 188.75 | 189.08 | 9541.0 |
| 2024-05-20 07:05:00 | AAPL | Stock | 189.02 | 189.02 | 188.96 | 189.0 | 3209.0 |
| 2024-05-20 07:10:00 | AAPL | Stock | 189.0 | 189.07 | 189.0 | 189.06 | 3999.0 |
| 2024-05-20 07:15:00 | AAPL | Stock | 189.05 | 189.05 | 189.05 | 189.05 | 462.0 |
| 2024-05-20 07:20:00 | AAPL | Stock | 189.11 | 189.14 | 188.99 | 188.99 | 5696.0 |
| 2024-05-20 07:25:00 | AAPL | Stock | 189.0 | 189.1 | 189.0 | 189.1 | 1834.0 |
| 2024-05-20 07:30:00 | AAPL | Stock | 189.1 | 189.12 | 189.1 | 189.12 | 2097.0 |
| 2024-05-20 07:35:00 | AAPL | Stock | 189.14 | 189.14 | 189.1 | 189.1 | 1200.0 |
| 2024-05-20 07:40:00 | AAPL | Stock | 189.1 | 189.1 | 189.0 | 189.05 | 328.0 |
| 2024-05-20 07:50:00 | AAPL | Stock | 189.01 | 189.01 | 189.01 | 189.01 | 100.0 |
| 2024-05-20 07:55:00 | AAPL | Stock | 189.05 | 189.06 | 189.02 | 189.02 | 686.0 |
| 2024-05-20 08:00:00 | AAPL | Stock | 188.98 | 190.18 | 188.8 | 190.09 | 29407.0 |
| 2024-05-20 08:05:00 | AAPL | Stock | 190.35 | 190.35 | 189.09 | 189.2 | 5431.0 |
| 2024-05-20 08:10:00 | AAPL | Stock | 189.16 | 189.2804 | 189.16 | 189.21 | 4180.0 |
| 2024-05-20 08:15:00 | AAPL | Stock | 189.22 | 189.3 | 189.2 | 189.3 | 5102.0 |
| 2024-05-20 08:20:00 | AAPL | Stock | 189.31 | 189.4 | 189.2 | 189.25 | 11308.0 |
| 2024-05-20 08:25:00 | AAPL | Stock | 189.3 | 189.4271 | 189.3 | 189.36 | 5651.0 |
| 2024-05-20 08:30:00 | AAPL | Stock | 189.35 | 189.6 | 189.35 | 189.53 | 16849.0 |
| 2024-05-20 08:35:00 | AAPL | Stock | 189.53 | 189.6 | 189.43 | 189.5 | 12645.0 |
| 2024-05-20 08:40:00 | AAPL | Stock | 189.5 | 189.5 | 189.26 | 189.3 | 13629.0 |
> showing 50 of 400,007 rows — these rows as CSV