PREVIEW / stock_5min / 2024-12-06
file: by_date/stock_5min/2024/2024-12-06.parquet size: 7.2 MB rows: 423,068 symbols: 689
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-12-06 04:00:00 | AAPL | Stock | 242.97 | 243.06 | 242.97 | 243.04 | 1459.0 |
| 2024-12-06 04:05:00 | AAPL | Stock | 243.1 | 243.1 | 242.81 | 243.0 | 1848.0 |
| 2024-12-06 04:10:00 | AAPL | Stock | 243.0 | 243.05 | 242.99 | 242.99 | 300.0 |
| 2024-12-06 04:20:00 | AAPL | Stock | 242.86 | 242.89 | 242.86 | 242.89 | 419.0 |
| 2024-12-06 05:20:00 | AAPL | Stock | 242.73 | 242.73 | 242.73 | 242.73 | 100.0 |
| 2024-12-06 05:25:00 | AAPL | Stock | 242.71 | 242.71 | 242.69 | 242.7 | 1200.0 |
| 2024-12-06 05:35:00 | AAPL | Stock | 242.78 | 242.78 | 242.78 | 242.78 | 100.0 |
| 2024-12-06 05:50:00 | AAPL | Stock | 242.72 | 242.72 | 242.72 | 242.72 | 300.0 |
| 2024-12-06 06:15:00 | AAPL | Stock | 242.69 | 242.69 | 242.69 | 242.69 | 100.0 |
| 2024-12-06 06:20:00 | AAPL | Stock | 242.57 | 242.57 | 242.57 | 242.57 | 100.0 |
| 2024-12-06 06:25:00 | AAPL | Stock | 242.55 | 242.57 | 242.55 | 242.57 | 1008.0 |
| 2024-12-06 06:30:00 | AAPL | Stock | 242.63 | 242.64 | 242.63 | 242.64 | 200.0 |
| 2024-12-06 06:45:00 | AAPL | Stock | 242.52 | 242.52 | 242.52 | 242.52 | 323.0 |
| 2024-12-06 06:50:00 | AAPL | Stock | 242.53 | 242.53 | 242.53 | 242.53 | 500.0 |
| 2024-12-06 07:00:00 | AAPL | Stock | 242.62 | 242.69 | 242.62 | 242.69 | 2113.0 |
| 2024-12-06 07:05:00 | AAPL | Stock | 242.69 | 242.72 | 242.69 | 242.72 | 1074.0 |
| 2024-12-06 07:10:00 | AAPL | Stock | 242.72 | 242.83 | 242.72 | 242.83 | 1470.0 |
| 2024-12-06 07:20:00 | AAPL | Stock | 242.87 | 242.95 | 242.87 | 242.87 | 3083.0 |
| 2024-12-06 07:30:00 | AAPL | Stock | 242.78 | 242.87 | 242.75 | 242.87 | 1893.0 |
| 2024-12-06 07:35:00 | AAPL | Stock | 242.89 | 242.9 | 242.89 | 242.9 | 200.0 |
| 2024-12-06 07:40:00 | AAPL | Stock | 242.81 | 242.84 | 242.78 | 242.8 | 914.0 |
| 2024-12-06 07:45:00 | AAPL | Stock | 242.76 | 242.79 | 242.76 | 242.77 | 823.0 |
| 2024-12-06 07:50:00 | AAPL | Stock | 242.85 | 242.85 | 242.85 | 242.85 | 100.0 |
| 2024-12-06 08:00:00 | AAPL | Stock | 242.79 | 243.04 | 242.41 | 242.85 | 15646.0 |
| 2024-12-06 08:05:00 | AAPL | Stock | 242.81 | 242.83 | 242.8054 | 242.83 | 549.0 |
| 2024-12-06 08:10:00 | AAPL | Stock | 242.8 | 242.85 | 242.8 | 242.85 | 1150.0 |
| 2024-12-06 08:15:00 | AAPL | Stock | 242.86 | 242.87 | 242.8 | 242.8 | 1762.0 |
| 2024-12-06 08:20:00 | AAPL | Stock | 242.81 | 242.9195 | 242.78 | 242.9195 | 2502.0 |
| 2024-12-06 08:25:00 | AAPL | Stock | 242.92 | 242.92 | 242.65 | 242.65 | 6521.0 |
| 2024-12-06 08:30:00 | AAPL | Stock | 242.92 | 243.02 | 242.65 | 242.92 | 10278.0 |
| 2024-12-06 08:35:00 | AAPL | Stock | 242.91 | 243.1398 | 242.7621 | 243.13 | 10005.0 |
| 2024-12-06 08:40:00 | AAPL | Stock | 243.14 | 243.18 | 242.8102 | 242.86 | 6115.0 |
| 2024-12-06 08:45:00 | AAPL | Stock | 242.96 | 243.02 | 242.82 | 242.97 | 1882.0 |
| 2024-12-06 08:50:00 | AAPL | Stock | 242.8471 | 242.989 | 242.81 | 242.989 | 16378.0 |
| 2024-12-06 08:55:00 | AAPL | Stock | 242.95 | 242.95 | 242.801 | 242.87 | 2290.0 |
| 2024-12-06 09:00:00 | AAPL | Stock | 242.86 | 243.01 | 242.86 | 243.0 | 4682.0 |
| 2024-12-06 09:05:00 | AAPL | Stock | 243.01 | 243.07 | 243.0 | 243.0001 | 4014.0 |
| 2024-12-06 09:10:00 | AAPL | Stock | 243.0164 | 243.1795 | 243.0164 | 243.13 | 6410.0 |
| 2024-12-06 09:15:00 | AAPL | Stock | 243.13 | 243.13 | 242.93 | 243.06 | 15584.0 |
| 2024-12-06 09:20:00 | AAPL | Stock | 243.06 | 243.2 | 243.0503 | 243.2 | 7448.0 |
| 2024-12-06 09:25:00 | AAPL | Stock | 243.18 | 243.23 | 242.65 | 242.9258 | 36842.0 |
| 2024-12-06 09:30:00 | AAPL | Stock | 242.905 | 243.05 | 242.08 | 242.4 | 944967.0 |
| 2024-12-06 09:35:00 | AAPL | Stock | 242.4 | 243.06 | 242.39 | 242.8 | 336504.0 |
| 2024-12-06 09:40:00 | AAPL | Stock | 242.82 | 243.14 | 242.79 | 243.08 | 469736.0 |
| 2024-12-06 09:45:00 | AAPL | Stock | 243.08 | 244.06 | 243.07 | 243.96 | 872477.0 |
| 2024-12-06 09:50:00 | AAPL | Stock | 243.99 | 244.2 | 243.85 | 243.905 | 640025.0 |
| 2024-12-06 09:55:00 | AAPL | Stock | 243.91 | 244.005 | 243.53 | 243.64 | 385740.0 |
| 2024-12-06 10:00:00 | AAPL | Stock | 243.67 | 244.28 | 243.59 | 244.08 | 444530.0 |
| 2024-12-06 10:05:00 | AAPL | Stock | 244.08 | 244.63 | 244.075 | 244.485 | 463776.0 |
| 2024-12-06 10:10:00 | AAPL | Stock | 244.481 | 244.5899 | 244.095 | 244.17 | 351397.0 |
> showing 50 of 423,068 rows — these rows as CSV