PREVIEW / stock_5min / 2023-12-27
file: by_date/stock_5min/2023/2023-12-27.parquet size: 7.0 MB rows: 421,098 symbols: 1,232
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-12-27 04:00:00 | AAPL | Stock | 193.0 | 193.0 | 192.92 | 192.92 | 929.0 |
| 2023-12-27 04:05:00 | AAPL | Stock | 192.92 | 192.92 | 192.89 | 192.89 | 1924.0 |
| 2023-12-27 04:10:00 | AAPL | Stock | 192.85 | 192.9 | 192.85 | 192.9 | 4849.0 |
| 2023-12-27 04:25:00 | AAPL | Stock | 192.9 | 192.9 | 192.8 | 192.81 | 1308.0 |
| 2023-12-27 04:30:00 | AAPL | Stock | 192.8 | 192.8 | 192.74 | 192.74 | 1232.0 |
| 2023-12-27 04:40:00 | AAPL | Stock | 192.81 | 192.81 | 192.8 | 192.8 | 250.0 |
| 2023-12-27 04:45:00 | AAPL | Stock | 192.76 | 192.76 | 192.76 | 192.76 | 100.0 |
| 2023-12-27 04:50:00 | AAPL | Stock | 192.78 | 192.8 | 192.78 | 192.8 | 709.0 |
| 2023-12-27 05:00:00 | AAPL | Stock | 192.8 | 192.81 | 192.8 | 192.81 | 540.0 |
| 2023-12-27 05:10:00 | AAPL | Stock | 192.83 | 192.83 | 192.81 | 192.81 | 266.0 |
| 2023-12-27 05:45:00 | AAPL | Stock | 192.86 | 192.86 | 192.86 | 192.86 | 200.0 |
| 2023-12-27 06:00:00 | AAPL | Stock | 192.81 | 192.82 | 192.81 | 192.82 | 350.0 |
| 2023-12-27 06:05:00 | AAPL | Stock | 192.82 | 192.82 | 192.82 | 192.82 | 100.0 |
| 2023-12-27 06:20:00 | AAPL | Stock | 192.82 | 192.82 | 192.82 | 192.82 | 393.0 |
| 2023-12-27 06:25:00 | AAPL | Stock | 192.83 | 192.83 | 192.82 | 192.82 | 872.0 |
| 2023-12-27 06:35:00 | AAPL | Stock | 192.8 | 192.8 | 192.8 | 192.8 | 134.0 |
| 2023-12-27 06:45:00 | AAPL | Stock | 192.81 | 192.82 | 192.81 | 192.82 | 875.0 |
| 2023-12-27 06:50:00 | AAPL | Stock | 192.82 | 192.82 | 192.82 | 192.82 | 169.0 |
| 2023-12-27 07:00:00 | AAPL | Stock | 192.85 | 192.86 | 192.85 | 192.86 | 1520.0 |
| 2023-12-27 07:05:00 | AAPL | Stock | 192.85 | 192.85 | 192.82 | 192.82 | 411.0 |
| 2023-12-27 07:10:00 | AAPL | Stock | 192.83 | 192.83 | 192.83 | 192.83 | 1500.0 |
| 2023-12-27 07:15:00 | AAPL | Stock | 192.87 | 192.87 | 192.87 | 192.87 | 300.0 |
| 2023-12-27 07:20:00 | AAPL | Stock | 192.88 | 192.88 | 192.85 | 192.85 | 236.0 |
| 2023-12-27 07:25:00 | AAPL | Stock | 192.91 | 192.91 | 192.91 | 192.91 | 100.0 |
| 2023-12-27 07:35:00 | AAPL | Stock | 192.98 | 192.98 | 192.98 | 192.98 | 1025.0 |
| 2023-12-27 07:40:00 | AAPL | Stock | 192.96 | 192.96 | 192.92 | 192.92 | 1058.0 |
| 2023-12-27 07:45:00 | AAPL | Stock | 192.92 | 192.92 | 192.9 | 192.9 | 238.0 |
| 2023-12-27 07:50:00 | AAPL | Stock | 192.92 | 192.93 | 192.91 | 192.91 | 2964.0 |
| 2023-12-27 08:00:00 | AAPL | Stock | 192.8214 | 193.05 | 192.8 | 193.05 | 14592.0 |
| 2023-12-27 08:05:00 | AAPL | Stock | 192.96 | 192.96 | 192.96 | 192.96 | 300.0 |
| 2023-12-27 08:10:00 | AAPL | Stock | 192.97 | 193.03 | 192.97 | 193.03 | 3765.0 |
| 2023-12-27 08:15:00 | AAPL | Stock | 193.0401 | 193.05 | 193.0 | 193.04 | 4788.0 |
| 2023-12-27 08:20:00 | AAPL | Stock | 193.05 | 193.05 | 193.01 | 193.03 | 3722.0 |
| 2023-12-27 08:25:00 | AAPL | Stock | 193.0299 | 193.03 | 193.02 | 193.03 | 3257.0 |
| 2023-12-27 08:30:00 | AAPL | Stock | 193.03 | 193.03 | 193.0 | 193.0 | 2850.0 |
| 2023-12-27 08:35:00 | AAPL | Stock | 193.02 | 193.02 | 192.9767 | 193.0 | 5118.0 |
| 2023-12-27 08:40:00 | AAPL | Stock | 193.0 | 193.0 | 193.0 | 193.0 | 535.0 |
| 2023-12-27 08:45:00 | AAPL | Stock | 192.971 | 193.01 | 192.97 | 193.01 | 4938.0 |
| 2023-12-27 08:50:00 | AAPL | Stock | 193.01 | 193.02 | 192.97 | 192.97 | 3778.0 |
| 2023-12-27 08:55:00 | AAPL | Stock | 192.95 | 192.97 | 192.9072 | 192.9133 | 9904.0 |
| 2023-12-27 09:00:00 | AAPL | Stock | 192.94 | 192.99 | 192.92 | 192.95 | 1646.0 |
| 2023-12-27 09:05:00 | AAPL | Stock | 192.95 | 192.95 | 192.92 | 192.92 | 4581.0 |
| 2023-12-27 09:10:00 | AAPL | Stock | 192.92 | 192.9301 | 192.89 | 192.93 | 12942.0 |
| 2023-12-27 09:15:00 | AAPL | Stock | 192.95 | 192.95 | 192.91 | 192.93 | 2324.0 |
| 2023-12-27 09:20:00 | AAPL | Stock | 192.93 | 192.93 | 192.89 | 192.8999 | 4803.0 |
| 2023-12-27 09:25:00 | AAPL | Stock | 192.87 | 192.89 | 192.0 | 192.43 | 104465.0 |
| 2023-12-27 09:30:00 | AAPL | Stock | 192.49 | 192.8799 | 192.36 | 192.5742 | 1518979.0 |
| 2023-12-27 09:35:00 | AAPL | Stock | 192.5703 | 192.84 | 192.47 | 192.72 | 514509.0 |
| 2023-12-27 09:40:00 | AAPL | Stock | 192.72 | 192.8972 | 192.66 | 192.8699 | 373736.0 |
| 2023-12-27 09:45:00 | AAPL | Stock | 192.862 | 192.877 | 192.6 | 192.679 | 340497.0 |
> showing 50 of 421,098 rows — these rows as CSV