PREVIEW / stock_5min / 2023-10-18
file: by_date/stock_5min/2023/2023-10-18.parquet size: 6.3 MB rows: 387,791 symbols: 1,357
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-10-18 04:05:00 | AAPL | Stock | 176.66 | 176.66 | 176.66 | 176.66 | 944.0 |
| 2023-10-18 04:10:00 | AAPL | Stock | 176.65 | 176.65 | 176.64 | 176.64 | 715.0 |
| 2023-10-18 04:25:00 | AAPL | Stock | 176.62 | 176.62 | 176.62 | 176.62 | 389.0 |
| 2023-10-18 04:30:00 | AAPL | Stock | 176.6 | 176.6 | 176.6 | 176.6 | 700.0 |
| 2023-10-18 04:45:00 | AAPL | Stock | 176.72 | 176.73 | 176.72 | 176.73 | 1828.0 |
| 2023-10-18 05:00:00 | AAPL | Stock | 176.61 | 176.61 | 176.61 | 176.61 | 500.0 |
| 2023-10-18 05:10:00 | AAPL | Stock | 176.7 | 176.73 | 176.7 | 176.73 | 424.0 |
| 2023-10-18 05:20:00 | AAPL | Stock | 176.6 | 176.61 | 176.6 | 176.6 | 646.0 |
| 2023-10-18 05:25:00 | AAPL | Stock | 176.43 | 176.43 | 176.38 | 176.38 | 1538.0 |
| 2023-10-18 05:30:00 | AAPL | Stock | 176.38 | 176.38 | 175.8 | 175.8 | 7097.0 |
| 2023-10-18 05:35:00 | AAPL | Stock | 176.11 | 176.11 | 176.0 | 176.0 | 613.0 |
| 2023-10-18 05:40:00 | AAPL | Stock | 175.91 | 175.91 | 175.81 | 175.89 | 999.0 |
| 2023-10-18 05:45:00 | AAPL | Stock | 175.9 | 175.9 | 175.89 | 175.9 | 1842.0 |
| 2023-10-18 05:50:00 | AAPL | Stock | 175.93 | 176.04 | 175.93 | 176.04 | 312.0 |
| 2023-10-18 05:55:00 | AAPL | Stock | 176.02 | 176.02 | 176.02 | 176.02 | 200.0 |
| 2023-10-18 06:00:00 | AAPL | Stock | 176.1 | 176.1 | 176.08 | 176.1 | 620.0 |
| 2023-10-18 06:05:00 | AAPL | Stock | 176.12 | 176.12 | 176.12 | 176.12 | 370.0 |
| 2023-10-18 06:10:00 | AAPL | Stock | 176.12 | 176.12 | 176.12 | 176.12 | 580.0 |
| 2023-10-18 06:15:00 | AAPL | Stock | 176.1 | 176.1 | 176.1 | 176.1 | 500.0 |
| 2023-10-18 06:20:00 | AAPL | Stock | 176.03 | 176.03 | 176.02 | 176.02 | 2344.0 |
| 2023-10-18 06:25:00 | AAPL | Stock | 176.01 | 176.01 | 175.97 | 175.97 | 1200.0 |
| 2023-10-18 06:30:00 | AAPL | Stock | 175.95 | 175.95 | 175.95 | 175.95 | 2180.0 |
| 2023-10-18 06:35:00 | AAPL | Stock | 175.9 | 175.9 | 175.9 | 175.9 | 1000.0 |
| 2023-10-18 06:40:00 | AAPL | Stock | 175.82 | 175.89 | 175.82 | 175.82 | 1704.0 |
| 2023-10-18 06:45:00 | AAPL | Stock | 175.89 | 175.9 | 175.7 | 175.7 | 2507.0 |
| 2023-10-18 06:50:00 | AAPL | Stock | 175.79 | 175.79 | 175.77 | 175.77 | 566.0 |
| 2023-10-18 06:55:00 | AAPL | Stock | 175.84 | 175.84 | 175.83 | 175.84 | 2719.0 |
| 2023-10-18 07:00:00 | AAPL | Stock | 175.98 | 176.01 | 175.78 | 176.01 | 7241.0 |
| 2023-10-18 07:05:00 | AAPL | Stock | 176.01 | 176.1 | 175.99 | 176.0 | 2830.0 |
| 2023-10-18 07:10:00 | AAPL | Stock | 176.0 | 176.0 | 175.84 | 175.84 | 5954.0 |
| 2023-10-18 07:15:00 | AAPL | Stock | 175.88 | 175.88 | 175.86 | 175.86 | 899.0 |
| 2023-10-18 07:20:00 | AAPL | Stock | 175.87 | 175.87 | 175.71 | 175.71 | 7488.0 |
| 2023-10-18 07:25:00 | AAPL | Stock | 175.74 | 175.88 | 175.74 | 175.88 | 1252.0 |
| 2023-10-18 07:30:00 | AAPL | Stock | 175.85 | 175.85 | 175.74 | 175.79 | 9374.0 |
| 2023-10-18 07:35:00 | AAPL | Stock | 175.8 | 175.8 | 175.71 | 175.71 | 4872.0 |
| 2023-10-18 07:40:00 | AAPL | Stock | 175.69 | 175.76 | 175.6 | 175.6 | 1166.0 |
| 2023-10-18 07:45:00 | AAPL | Stock | 175.65 | 175.66 | 175.45 | 175.45 | 6113.0 |
| 2023-10-18 07:50:00 | AAPL | Stock | 175.45 | 175.61 | 175.45 | 175.61 | 714.0 |
| 2023-10-18 08:00:00 | AAPL | Stock | 175.99 | 176.8 | 175.41 | 175.41 | 33946.0 |
| 2023-10-18 08:05:00 | AAPL | Stock | 175.46 | 175.83 | 175.46 | 175.78 | 7185.0 |
| 2023-10-18 08:10:00 | AAPL | Stock | 175.8 | 175.8 | 175.69 | 175.69 | 7814.0 |
| 2023-10-18 08:15:00 | AAPL | Stock | 175.7 | 175.8 | 175.6575 | 175.8 | 1372.0 |
| 2023-10-18 08:20:00 | AAPL | Stock | 175.75 | 175.8 | 175.75 | 175.75 | 4357.0 |
| 2023-10-18 08:25:00 | AAPL | Stock | 175.8 | 175.8 | 175.75 | 175.75 | 7341.0 |
| 2023-10-18 08:30:00 | AAPL | Stock | 175.76 | 175.8 | 175.7 | 175.7 | 9902.0 |
| 2023-10-18 08:35:00 | AAPL | Stock | 175.7 | 175.8 | 175.7 | 175.8 | 7698.0 |
| 2023-10-18 08:40:00 | AAPL | Stock | 175.75 | 175.75 | 175.65 | 175.72 | 6873.0 |
| 2023-10-18 08:45:00 | AAPL | Stock | 175.65 | 175.7 | 175.65 | 175.69 | 6800.0 |
| 2023-10-18 08:50:00 | AAPL | Stock | 175.66 | 175.66 | 175.6 | 175.6 | 10234.0 |
| 2023-10-18 08:55:00 | AAPL | Stock | 175.64 | 175.75 | 175.6 | 175.66 | 51997.0 |
> showing 50 of 387,791 rows — these rows as CSV