PREVIEW / stock_5min / 2024-07-12
file: by_date/stock_5min/2024/2024-07-12.parquet size: 6.7 MB rows: 403,280 symbols: 900
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-07-12 04:00:00 | AAPL | Stock | 228.0 | 228.0 | 227.29 | 227.81 | 6271.0 |
| 2024-07-12 04:05:00 | AAPL | Stock | 227.88 | 228.0 | 227.82 | 228.0 | 2350.0 |
| 2024-07-12 04:10:00 | AAPL | Stock | 228.0 | 228.15 | 227.99 | 228.15 | 2015.0 |
| 2024-07-12 04:15:00 | AAPL | Stock | 228.18 | 228.2 | 228.18 | 228.2 | 692.0 |
| 2024-07-12 04:20:00 | AAPL | Stock | 228.2 | 228.5 | 228.2 | 228.5 | 1381.0 |
| 2024-07-12 04:25:00 | AAPL | Stock | 228.49 | 228.5 | 228.49 | 228.5 | 588.0 |
| 2024-07-12 04:30:00 | AAPL | Stock | 228.5 | 228.5 | 228.3 | 228.3 | 803.0 |
| 2024-07-12 04:35:00 | AAPL | Stock | 228.37 | 228.37 | 228.37 | 228.37 | 228.0 |
| 2024-07-12 04:40:00 | AAPL | Stock | 228.25 | 228.25 | 228.21 | 228.21 | 747.0 |
| 2024-07-12 04:45:00 | AAPL | Stock | 228.25 | 228.25 | 228.16 | 228.25 | 1468.0 |
| 2024-07-12 04:50:00 | AAPL | Stock | 228.26 | 228.3 | 228.26 | 228.3 | 818.0 |
| 2024-07-12 04:55:00 | AAPL | Stock | 228.34 | 228.4 | 228.34 | 228.37 | 685.0 |
| 2024-07-12 05:00:00 | AAPL | Stock | 228.47 | 228.53 | 228.47 | 228.51 | 1580.0 |
| 2024-07-12 05:05:00 | AAPL | Stock | 228.53 | 228.59 | 228.53 | 228.59 | 895.0 |
| 2024-07-12 05:10:00 | AAPL | Stock | 228.57 | 228.65 | 228.57 | 228.65 | 1043.0 |
| 2024-07-12 05:15:00 | AAPL | Stock | 228.67 | 228.69 | 228.45 | 228.45 | 956.0 |
| 2024-07-12 05:20:00 | AAPL | Stock | 228.46 | 228.46 | 228.46 | 228.46 | 440.0 |
| 2024-07-12 05:25:00 | AAPL | Stock | 228.21 | 228.21 | 228.2 | 228.2 | 1465.0 |
| 2024-07-12 05:30:00 | AAPL | Stock | 228.34 | 228.34 | 228.25 | 228.25 | 220.0 |
| 2024-07-12 05:35:00 | AAPL | Stock | 228.13 | 228.13 | 228.09 | 228.12 | 2257.0 |
| 2024-07-12 05:40:00 | AAPL | Stock | 228.34 | 228.4 | 228.29 | 228.34 | 1630.0 |
| 2024-07-12 05:45:00 | AAPL | Stock | 228.43 | 228.43 | 228.43 | 228.43 | 670.0 |
| 2024-07-12 05:50:00 | AAPL | Stock | 228.47 | 228.47 | 228.44 | 228.44 | 228.0 |
| 2024-07-12 06:00:00 | AAPL | Stock | 228.47 | 228.47 | 228.47 | 228.47 | 100.0 |
| 2024-07-12 06:05:00 | AAPL | Stock | 228.43 | 228.43 | 228.4 | 228.4 | 1604.0 |
| 2024-07-12 06:10:00 | AAPL | Stock | 228.32 | 228.32 | 228.32 | 228.32 | 100.0 |
| 2024-07-12 06:15:00 | AAPL | Stock | 228.34 | 228.34 | 228.34 | 228.34 | 137.0 |
| 2024-07-12 06:20:00 | AAPL | Stock | 228.34 | 228.35 | 228.34 | 228.34 | 715.0 |
| 2024-07-12 06:25:00 | AAPL | Stock | 228.34 | 228.34 | 228.3 | 228.34 | 756.0 |
| 2024-07-12 06:30:00 | AAPL | Stock | 228.33 | 228.33 | 228.3 | 228.33 | 864.0 |
| 2024-07-12 06:35:00 | AAPL | Stock | 228.34 | 228.35 | 228.34 | 228.34 | 640.0 |
| 2024-07-12 06:40:00 | AAPL | Stock | 228.35 | 228.35 | 228.2 | 228.2 | 1399.0 |
| 2024-07-12 06:45:00 | AAPL | Stock | 228.2 | 228.2 | 228.19 | 228.19 | 400.0 |
| 2024-07-12 06:50:00 | AAPL | Stock | 228.17 | 228.3 | 228.17 | 228.29 | 794.0 |
| 2024-07-12 06:55:00 | AAPL | Stock | 228.3 | 228.3 | 228.19 | 228.3 | 1806.0 |
| 2024-07-12 07:00:00 | AAPL | Stock | 228.3 | 228.34 | 228.18 | 228.2 | 2789.0 |
| 2024-07-12 07:05:00 | AAPL | Stock | 228.1 | 228.1 | 227.88 | 227.88 | 9128.0 |
| 2024-07-12 07:10:00 | AAPL | Stock | 227.89 | 227.99 | 227.89 | 227.99 | 630.0 |
| 2024-07-12 07:15:00 | AAPL | Stock | 228.0 | 228.39 | 228.0 | 228.39 | 1978.0 |
| 2024-07-12 07:20:00 | AAPL | Stock | 228.4 | 228.45 | 228.33 | 228.4 | 3041.0 |
| 2024-07-12 07:30:00 | AAPL | Stock | 228.4 | 228.5 | 228.4 | 228.5 | 850.0 |
| 2024-07-12 07:35:00 | AAPL | Stock | 228.54 | 228.76 | 228.39 | 228.39 | 10656.0 |
| 2024-07-12 07:40:00 | AAPL | Stock | 228.46 | 228.47 | 228.4 | 228.4 | 1920.0 |
| 2024-07-12 07:45:00 | AAPL | Stock | 228.4 | 228.46 | 228.4 | 228.45 | 1006.0 |
| 2024-07-12 07:50:00 | AAPL | Stock | 228.42 | 228.42 | 228.32 | 228.32 | 1941.0 |
| 2024-07-12 07:55:00 | AAPL | Stock | 228.38 | 228.58 | 228.38 | 228.58 | 3912.0 |
| 2024-07-12 08:00:00 | AAPL | Stock | 228.31 | 228.77 | 227.44 | 228.21 | 72314.0 |
| 2024-07-12 08:05:00 | AAPL | Stock | 227.67 | 228.35 | 227.45 | 228.31 | 9978.0 |
| 2024-07-12 08:10:00 | AAPL | Stock | 228.35 | 228.4 | 228.3 | 228.385 | 8384.0 |
| 2024-07-12 08:15:00 | AAPL | Stock | 228.4 | 228.45 | 228.3304 | 228.3304 | 1272.0 |
> showing 50 of 403,280 rows — these rows as CSV