PREVIEW / stock_5min / 2024-09-30
file: by_date/stock_5min/2024/2024-09-30.parquet size: 6.9 MB rows: 416,043 symbols: 788
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-09-30 04:00:00 | AAPL | Stock | 227.33 | 228.6 | 227.33 | 228.4 | 16228.0 |
| 2024-09-30 04:05:00 | AAPL | Stock | 228.4 | 228.55 | 228.35 | 228.48 | 8637.0 |
| 2024-09-30 04:10:00 | AAPL | Stock | 228.52 | 228.55 | 228.5 | 228.51 | 7901.0 |
| 2024-09-30 04:15:00 | AAPL | Stock | 228.5 | 228.7 | 228.5 | 228.7 | 5058.0 |
| 2024-09-30 04:20:00 | AAPL | Stock | 228.7 | 228.84 | 228.7 | 228.84 | 798.0 |
| 2024-09-30 04:25:00 | AAPL | Stock | 228.93 | 229.37 | 228.93 | 229.33 | 8315.0 |
| 2024-09-30 04:30:00 | AAPL | Stock | 229.29 | 229.33 | 229.03 | 229.03 | 1536.0 |
| 2024-09-30 04:35:00 | AAPL | Stock | 228.89 | 229.15 | 228.89 | 229.0 | 3744.0 |
| 2024-09-30 04:40:00 | AAPL | Stock | 229.01 | 229.01 | 229.0 | 229.0 | 440.0 |
| 2024-09-30 04:45:00 | AAPL | Stock | 229.0 | 229.0 | 229.0 | 229.0 | 100.0 |
| 2024-09-30 04:50:00 | AAPL | Stock | 229.01 | 229.02 | 229.0 | 229.0 | 3155.0 |
| 2024-09-30 05:00:00 | AAPL | Stock | 229.0 | 229.03 | 229.0 | 229.0 | 1013.0 |
| 2024-09-30 05:05:00 | AAPL | Stock | 229.01 | 229.19 | 229.01 | 229.15 | 2356.0 |
| 2024-09-30 05:10:00 | AAPL | Stock | 229.18 | 229.2 | 229.18 | 229.19 | 450.0 |
| 2024-09-30 05:15:00 | AAPL | Stock | 229.19 | 229.4 | 229.15 | 229.4 | 3778.0 |
| 2024-09-30 05:20:00 | AAPL | Stock | 229.23 | 229.67 | 229.23 | 229.67 | 6427.0 |
| 2024-09-30 05:25:00 | AAPL | Stock | 229.8 | 230.02 | 229.79 | 229.8 | 9965.0 |
| 2024-09-30 05:30:00 | AAPL | Stock | 229.82 | 230.0 | 229.82 | 230.0 | 5820.0 |
| 2024-09-30 05:35:00 | AAPL | Stock | 229.87 | 229.96 | 229.87 | 229.96 | 550.0 |
| 2024-09-30 05:40:00 | AAPL | Stock | 229.85 | 230.11 | 229.85 | 229.93 | 8054.0 |
| 2024-09-30 05:45:00 | AAPL | Stock | 229.86 | 229.9 | 229.86 | 229.9 | 722.0 |
| 2024-09-30 05:50:00 | AAPL | Stock | 229.96 | 230.07 | 229.85 | 230.0 | 4017.0 |
| 2024-09-30 05:55:00 | AAPL | Stock | 229.83 | 230.22 | 229.83 | 230.2 | 5813.0 |
| 2024-09-30 06:00:00 | AAPL | Stock | 230.12 | 230.55 | 230.11 | 230.3 | 5908.0 |
| 2024-09-30 06:05:00 | AAPL | Stock | 230.32 | 230.37 | 230.17 | 230.36 | 1251.0 |
| 2024-09-30 06:10:00 | AAPL | Stock | 230.12 | 230.15 | 230.04 | 230.15 | 1275.0 |
| 2024-09-30 06:15:00 | AAPL | Stock | 230.1 | 230.2 | 230.1 | 230.11 | 2082.0 |
| 2024-09-30 06:20:00 | AAPL | Stock | 230.13 | 230.13 | 230.05 | 230.1 | 1427.0 |
| 2024-09-30 06:25:00 | AAPL | Stock | 230.1 | 230.2 | 230.02 | 230.19 | 5237.0 |
| 2024-09-30 06:30:00 | AAPL | Stock | 230.18 | 230.2 | 230.1 | 230.1 | 1676.0 |
| 2024-09-30 06:35:00 | AAPL | Stock | 230.1 | 230.12 | 229.91 | 229.93 | 2515.0 |
| 2024-09-30 06:40:00 | AAPL | Stock | 229.93 | 229.93 | 229.9 | 229.9 | 401.0 |
| 2024-09-30 06:45:00 | AAPL | Stock | 229.89 | 229.89 | 229.89 | 229.89 | 772.0 |
| 2024-09-30 06:50:00 | AAPL | Stock | 229.85 | 229.85 | 229.83 | 229.83 | 200.0 |
| 2024-09-30 06:55:00 | AAPL | Stock | 229.83 | 229.9 | 229.83 | 229.9 | 2218.0 |
| 2024-09-30 07:00:00 | AAPL | Stock | 229.85 | 229.92 | 229.71 | 229.85 | 18033.0 |
| 2024-09-30 07:05:00 | AAPL | Stock | 229.77 | 229.77 | 229.68 | 229.71 | 2926.0 |
| 2024-09-30 07:10:00 | AAPL | Stock | 229.64 | 229.68 | 229.31 | 229.31 | 8849.0 |
| 2024-09-30 07:15:00 | AAPL | Stock | 229.4 | 229.6 | 229.18 | 229.6 | 10525.0 |
| 2024-09-30 07:20:00 | AAPL | Stock | 229.61 | 229.88 | 229.61 | 229.78 | 5514.0 |
| 2024-09-30 07:25:00 | AAPL | Stock | 229.8 | 229.8 | 229.5 | 229.5 | 15426.0 |
| 2024-09-30 07:30:00 | AAPL | Stock | 229.5 | 229.73 | 229.5 | 229.71 | 6027.0 |
| 2024-09-30 07:35:00 | AAPL | Stock | 229.57 | 229.59 | 229.46 | 229.46 | 2509.0 |
| 2024-09-30 07:40:00 | AAPL | Stock | 229.38 | 229.55 | 229.32 | 229.45 | 15346.0 |
| 2024-09-30 07:45:00 | AAPL | Stock | 229.48 | 229.49 | 229.02 | 229.17 | 10892.0 |
| 2024-09-30 07:50:00 | AAPL | Stock | 229.17 | 229.35 | 229.0 | 229.35 | 11697.0 |
| 2024-09-30 07:55:00 | AAPL | Stock | 229.35 | 229.48 | 229.35 | 229.42 | 5750.0 |
| 2024-09-30 08:00:00 | AAPL | Stock | 229.4 | 229.89 | 226.84 | 229.75 | 107464.0 |
| 2024-09-30 08:05:00 | AAPL | Stock | 229.73 | 229.89 | 229.5 | 229.89 | 10786.0 |
| 2024-09-30 08:10:00 | AAPL | Stock | 229.8693 | 229.89 | 229.69 | 229.69 | 16018.0 |
> showing 50 of 416,043 rows — these rows as CSV