PREVIEW / stock_5min / 2024-10-03
file: by_date/stock_5min/2024/2024-10-03.parquet size: 6.6 MB rows: 391,983 symbols: 746
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-10-03 04:00:00 | AAPL | Stock | 226.2 | 226.2 | 225.8 | 226.0 | 2331.0 |
| 2024-10-03 04:05:00 | AAPL | Stock | 225.94 | 226.0 | 225.9 | 225.9 | 3245.0 |
| 2024-10-03 04:10:00 | AAPL | Stock | 225.94 | 225.99 | 225.91 | 225.93 | 868.0 |
| 2024-10-03 04:15:00 | AAPL | Stock | 225.98 | 225.98 | 225.98 | 225.98 | 290.0 |
| 2024-10-03 04:20:00 | AAPL | Stock | 225.95 | 225.96 | 225.95 | 225.96 | 588.0 |
| 2024-10-03 04:25:00 | AAPL | Stock | 226.0 | 226.02 | 225.95 | 225.95 | 3439.0 |
| 2024-10-03 04:30:00 | AAPL | Stock | 225.9 | 225.9 | 225.73 | 225.74 | 688.0 |
| 2024-10-03 04:35:00 | AAPL | Stock | 225.67 | 225.67 | 225.67 | 225.67 | 100.0 |
| 2024-10-03 04:40:00 | AAPL | Stock | 225.94 | 225.94 | 225.94 | 225.94 | 150.0 |
| 2024-10-03 04:55:00 | AAPL | Stock | 225.86 | 225.86 | 225.86 | 225.86 | 100.0 |
| 2024-10-03 05:00:00 | AAPL | Stock | 225.86 | 225.86 | 225.85 | 225.85 | 624.0 |
| 2024-10-03 05:10:00 | AAPL | Stock | 225.74 | 225.74 | 225.74 | 225.74 | 112.0 |
| 2024-10-03 06:00:00 | AAPL | Stock | 225.79 | 225.79 | 225.79 | 225.79 | 100.0 |
| 2024-10-03 06:05:00 | AAPL | Stock | 225.75 | 225.75 | 225.75 | 225.75 | 198.0 |
| 2024-10-03 06:15:00 | AAPL | Stock | 225.84 | 225.88 | 225.84 | 225.88 | 872.0 |
| 2024-10-03 06:30:00 | AAPL | Stock | 225.9 | 225.9 | 225.82 | 225.82 | 1755.0 |
| 2024-10-03 06:35:00 | AAPL | Stock | 225.88 | 225.88 | 225.88 | 225.88 | 528.0 |
| 2024-10-03 06:40:00 | AAPL | Stock | 225.8 | 225.8 | 225.7 | 225.77 | 4936.0 |
| 2024-10-03 06:45:00 | AAPL | Stock | 225.6 | 225.75 | 225.53 | 225.75 | 1188.0 |
| 2024-10-03 06:50:00 | AAPL | Stock | 225.73 | 225.78 | 225.73 | 225.75 | 1690.0 |
| 2024-10-03 06:55:00 | AAPL | Stock | 225.75 | 225.75 | 225.75 | 225.75 | 100.0 |
| 2024-10-03 07:00:00 | AAPL | Stock | 225.8 | 226.09 | 225.8 | 226.05 | 6973.0 |
| 2024-10-03 07:05:00 | AAPL | Stock | 226.0 | 226.0 | 225.7 | 225.7 | 10461.0 |
| 2024-10-03 07:10:00 | AAPL | Stock | 225.7 | 225.7 | 225.55 | 225.55 | 1909.0 |
| 2024-10-03 07:15:00 | AAPL | Stock | 225.55 | 225.6 | 225.4 | 225.4 | 2114.0 |
| 2024-10-03 07:20:00 | AAPL | Stock | 225.46 | 225.46 | 225.4 | 225.41 | 3442.0 |
| 2024-10-03 07:25:00 | AAPL | Stock | 225.4 | 225.41 | 225.29 | 225.38 | 2945.0 |
| 2024-10-03 07:30:00 | AAPL | Stock | 225.38 | 225.48 | 225.31 | 225.31 | 876.0 |
| 2024-10-03 07:35:00 | AAPL | Stock | 225.35 | 225.35 | 225.15 | 225.16 | 5782.0 |
| 2024-10-03 07:40:00 | AAPL | Stock | 225.21 | 225.39 | 225.21 | 225.39 | 650.0 |
| 2024-10-03 07:45:00 | AAPL | Stock | 225.38 | 225.38 | 225.38 | 225.38 | 115.0 |
| 2024-10-03 07:50:00 | AAPL | Stock | 225.44 | 225.56 | 225.38 | 225.55 | 2964.0 |
| 2024-10-03 07:55:00 | AAPL | Stock | 225.5 | 225.56 | 225.48 | 225.53 | 2040.0 |
| 2024-10-03 08:00:00 | AAPL | Stock | 225.5 | 226.37 | 224.79 | 225.27 | 59535.0 |
| 2024-10-03 08:05:00 | AAPL | Stock | 225.2 | 225.4 | 225.2 | 225.4 | 9172.0 |
| 2024-10-03 08:10:00 | AAPL | Stock | 225.33 | 225.35 | 225.2 | 225.28 | 8882.0 |
| 2024-10-03 08:15:00 | AAPL | Stock | 225.29 | 225.57 | 225.29 | 225.5003 | 4580.0 |
| 2024-10-03 08:20:00 | AAPL | Stock | 225.55 | 225.6494 | 225.45 | 225.45 | 13784.0 |
| 2024-10-03 08:25:00 | AAPL | Stock | 225.5 | 225.5645 | 225.42 | 225.53 | 11453.0 |
| 2024-10-03 08:30:00 | AAPL | Stock | 225.4 | 225.83 | 225.4 | 225.52 | 5677.0 |
| 2024-10-03 08:35:00 | AAPL | Stock | 225.55 | 225.55 | 225.3 | 225.3 | 4862.0 |
| 2024-10-03 08:40:00 | AAPL | Stock | 225.26 | 225.417 | 225.2 | 225.28 | 18991.0 |
| 2024-10-03 08:45:00 | AAPL | Stock | 225.27 | 225.35 | 225.254 | 225.3 | 2250.0 |
| 2024-10-03 08:50:00 | AAPL | Stock | 225.27 | 225.354 | 225.25 | 225.26 | 5025.0 |
| 2024-10-03 08:55:00 | AAPL | Stock | 225.2505 | 225.39 | 225.15 | 225.21 | 7928.0 |
| 2024-10-03 09:00:00 | AAPL | Stock | 225.15 | 225.19 | 225.05 | 225.13 | 10590.0 |
| 2024-10-03 09:05:00 | AAPL | Stock | 225.19 | 225.3235 | 225.11 | 225.2219 | 3368.0 |
| 2024-10-03 09:10:00 | AAPL | Stock | 225.2327 | 225.3 | 225.15 | 225.18 | 5718.0 |
| 2024-10-03 09:15:00 | AAPL | Stock | 225.15 | 225.2 | 225.0 | 225.2 | 5209.0 |
| 2024-10-03 09:20:00 | AAPL | Stock | 225.2487 | 225.3 | 225.0 | 225.1402 | 5646.0 |
> showing 50 of 391,983 rows — these rows as CSV