PREVIEW / stock_5min / 2024-06-17
file: by_date/stock_5min/2024/2024-06-17.parquet size: 6.7 MB rows: 400,436 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-06-17 04:00:00 | AAPL | Stock | 212.62 | 213.47 | 212.62 | 212.9 | 3816.0 |
| 2024-06-17 04:05:00 | AAPL | Stock | 212.83 | 213.4 | 212.82 | 213.4 | 10717.0 |
| 2024-06-17 04:10:00 | AAPL | Stock | 213.46 | 213.7 | 213.46 | 213.7 | 4131.0 |
| 2024-06-17 04:15:00 | AAPL | Stock | 213.72 | 214.39 | 213.6 | 214.25 | 9548.0 |
| 2024-06-17 04:20:00 | AAPL | Stock | 214.24 | 214.3 | 214.0 | 214.3 | 31795.0 |
| 2024-06-17 04:25:00 | AAPL | Stock | 214.3 | 214.61 | 214.13 | 214.34 | 29241.0 |
| 2024-06-17 04:30:00 | AAPL | Stock | 214.41 | 214.61 | 214.26 | 214.58 | 19520.0 |
| 2024-06-17 04:35:00 | AAPL | Stock | 214.54 | 214.6 | 214.4 | 214.4 | 1802.0 |
| 2024-06-17 04:40:00 | AAPL | Stock | 214.24 | 214.24 | 214.0 | 214.01 | 7136.0 |
| 2024-06-17 04:45:00 | AAPL | Stock | 214.09 | 214.09 | 214.09 | 214.09 | 100.0 |
| 2024-06-17 04:50:00 | AAPL | Stock | 214.13 | 214.18 | 214.01 | 214.18 | 5537.0 |
| 2024-06-17 04:55:00 | AAPL | Stock | 214.13 | 214.13 | 214.04 | 214.04 | 857.0 |
| 2024-06-17 05:00:00 | AAPL | Stock | 214.01 | 214.02 | 213.91 | 213.91 | 14203.0 |
| 2024-06-17 05:05:00 | AAPL | Stock | 213.85 | 213.85 | 213.7 | 213.7 | 550.0 |
| 2024-06-17 05:10:00 | AAPL | Stock | 213.8 | 213.94 | 213.8 | 213.89 | 1836.0 |
| 2024-06-17 05:15:00 | AAPL | Stock | 213.88 | 213.89 | 213.86 | 213.86 | 535.0 |
| 2024-06-17 05:20:00 | AAPL | Stock | 213.97 | 213.97 | 213.91 | 213.91 | 300.0 |
| 2024-06-17 05:25:00 | AAPL | Stock | 214.01 | 214.01 | 213.96 | 214.0 | 513.0 |
| 2024-06-17 05:30:00 | AAPL | Stock | 214.0 | 214.0 | 214.0 | 214.0 | 346.0 |
| 2024-06-17 05:35:00 | AAPL | Stock | 213.9 | 213.95 | 213.9 | 213.94 | 1138.0 |
| 2024-06-17 05:40:00 | AAPL | Stock | 213.94 | 214.0 | 213.91 | 214.0 | 942.0 |
| 2024-06-17 05:45:00 | AAPL | Stock | 213.92 | 213.92 | 213.8 | 213.85 | 3941.0 |
| 2024-06-17 05:50:00 | AAPL | Stock | 213.9 | 213.9 | 213.8 | 213.81 | 4359.0 |
| 2024-06-17 05:55:00 | AAPL | Stock | 213.87 | 213.87 | 213.8 | 213.8 | 1038.0 |
| 2024-06-17 06:00:00 | AAPL | Stock | 213.9 | 214.09 | 213.9 | 214.09 | 13518.0 |
| 2024-06-17 06:05:00 | AAPL | Stock | 214.01 | 214.02 | 213.8 | 213.8 | 8161.0 |
| 2024-06-17 06:10:00 | AAPL | Stock | 213.81 | 213.81 | 213.8 | 213.81 | 1779.0 |
| 2024-06-17 06:15:00 | AAPL | Stock | 213.82 | 213.87 | 213.81 | 213.81 | 1401.0 |
| 2024-06-17 06:20:00 | AAPL | Stock | 213.8 | 213.85 | 213.8 | 213.84 | 2173.0 |
| 2024-06-17 06:25:00 | AAPL | Stock | 213.72 | 213.72 | 213.65 | 213.65 | 1913.0 |
| 2024-06-17 06:30:00 | AAPL | Stock | 213.71 | 213.8 | 213.71 | 213.79 | 2929.0 |
| 2024-06-17 06:35:00 | AAPL | Stock | 213.89 | 214.16 | 213.89 | 213.9 | 15006.0 |
| 2024-06-17 06:40:00 | AAPL | Stock | 213.82 | 214.0 | 213.8 | 213.8 | 8635.0 |
| 2024-06-17 06:45:00 | AAPL | Stock | 213.9 | 213.92 | 213.89 | 213.89 | 463.0 |
| 2024-06-17 06:50:00 | AAPL | Stock | 213.85 | 213.85 | 213.82 | 213.85 | 1048.0 |
| 2024-06-17 06:55:00 | AAPL | Stock | 213.8 | 213.89 | 213.8 | 213.89 | 4054.0 |
| 2024-06-17 07:00:00 | AAPL | Stock | 213.71 | 214.1 | 213.65 | 214.02 | 19605.0 |
| 2024-06-17 07:05:00 | AAPL | Stock | 214.01 | 214.05 | 213.88 | 213.88 | 5187.0 |
| 2024-06-17 07:10:00 | AAPL | Stock | 213.8 | 213.8 | 213.7 | 213.74 | 2313.0 |
| 2024-06-17 07:15:00 | AAPL | Stock | 213.81 | 213.98 | 213.81 | 213.98 | 5258.0 |
| 2024-06-17 07:20:00 | AAPL | Stock | 213.96 | 213.97 | 213.72 | 213.97 | 5397.0 |
| 2024-06-17 07:25:00 | AAPL | Stock | 213.95 | 213.97 | 213.9 | 213.97 | 3124.0 |
| 2024-06-17 07:30:00 | AAPL | Stock | 213.95 | 214.0 | 213.8 | 213.8 | 5991.0 |
| 2024-06-17 07:35:00 | AAPL | Stock | 213.81 | 213.9 | 213.73 | 213.9 | 2209.0 |
| 2024-06-17 07:40:00 | AAPL | Stock | 213.99 | 214.03 | 213.91 | 213.95 | 10987.0 |
| 2024-06-17 07:45:00 | AAPL | Stock | 213.96 | 214.03 | 213.79 | 213.8 | 10521.0 |
| 2024-06-17 07:50:00 | AAPL | Stock | 213.85 | 214.0 | 213.75 | 213.8 | 5143.0 |
| 2024-06-17 07:55:00 | AAPL | Stock | 213.78 | 213.92 | 213.69 | 213.92 | 5901.0 |
| 2024-06-17 08:00:00 | AAPL | Stock | 213.78 | 214.1 | 212.43 | 213.88 | 166361.0 |
| 2024-06-17 08:05:00 | AAPL | Stock | 213.9 | 214.3 | 213.9 | 214.18 | 47195.0 |
> showing 50 of 400,436 rows — these rows as CSV