PREVIEW / stock_5min / 2024-04-30
file: by_date/stock_5min/2024/2024-04-30.parquet size: 6.5 MB rows: 395,499 symbols: 981
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-04-30 04:00:00 | AAPL | Stock | 173.22 | 173.74 | 173.12 | 173.63 | 1361.0 |
| 2024-04-30 04:05:00 | AAPL | Stock | 173.68 | 173.68 | 173.59 | 173.63 | 989.0 |
| 2024-04-30 04:10:00 | AAPL | Stock | 173.64 | 173.68 | 173.64 | 173.68 | 2224.0 |
| 2024-04-30 04:15:00 | AAPL | Stock | 173.68 | 173.87 | 173.68 | 173.87 | 3641.0 |
| 2024-04-30 04:20:00 | AAPL | Stock | 173.85 | 173.85 | 173.85 | 173.85 | 400.0 |
| 2024-04-30 04:25:00 | AAPL | Stock | 173.84 | 173.97 | 173.84 | 173.85 | 1164.0 |
| 2024-04-30 04:30:00 | AAPL | Stock | 173.95 | 173.99 | 173.95 | 173.99 | 942.0 |
| 2024-04-30 04:35:00 | AAPL | Stock | 174.06 | 174.06 | 174.06 | 174.06 | 162.0 |
| 2024-04-30 04:40:00 | AAPL | Stock | 174.05 | 174.05 | 174.05 | 174.05 | 100.0 |
| 2024-04-30 04:45:00 | AAPL | Stock | 174.02 | 174.02 | 173.97 | 173.97 | 548.0 |
| 2024-04-30 05:00:00 | AAPL | Stock | 173.95 | 174.09 | 173.95 | 174.09 | 2305.0 |
| 2024-04-30 05:05:00 | AAPL | Stock | 174.05 | 174.05 | 174.05 | 174.05 | 200.0 |
| 2024-04-30 05:15:00 | AAPL | Stock | 174.01 | 174.01 | 174.01 | 174.01 | 125.0 |
| 2024-04-30 05:20:00 | AAPL | Stock | 174.0 | 174.05 | 174.0 | 174.05 | 838.0 |
| 2024-04-30 05:30:00 | AAPL | Stock | 174.08 | 174.12 | 174.08 | 174.12 | 404.0 |
| 2024-04-30 05:35:00 | AAPL | Stock | 174.09 | 174.5 | 174.09 | 174.5 | 11116.0 |
| 2024-04-30 05:40:00 | AAPL | Stock | 174.4 | 174.42 | 174.4 | 174.41 | 796.0 |
| 2024-04-30 05:50:00 | AAPL | Stock | 174.42 | 174.42 | 174.2 | 174.2 | 1003.0 |
| 2024-04-30 06:00:00 | AAPL | Stock | 174.36 | 174.36 | 174.3 | 174.3 | 397.0 |
| 2024-04-30 06:05:00 | AAPL | Stock | 174.35 | 174.35 | 174.32 | 174.32 | 483.0 |
| 2024-04-30 06:10:00 | AAPL | Stock | 174.35 | 174.39 | 174.35 | 174.39 | 963.0 |
| 2024-04-30 06:15:00 | AAPL | Stock | 174.4 | 174.4 | 174.31 | 174.31 | 2556.0 |
| 2024-04-30 06:20:00 | AAPL | Stock | 174.31 | 174.39 | 174.31 | 174.31 | 1828.0 |
| 2024-04-30 06:25:00 | AAPL | Stock | 174.31 | 174.31 | 174.3 | 174.31 | 909.0 |
| 2024-04-30 06:30:00 | AAPL | Stock | 174.31 | 174.31 | 174.31 | 174.31 | 400.0 |
| 2024-04-30 06:35:00 | AAPL | Stock | 174.27 | 174.33 | 174.27 | 174.33 | 229.0 |
| 2024-04-30 06:40:00 | AAPL | Stock | 174.31 | 174.34 | 174.31 | 174.31 | 1748.0 |
| 2024-04-30 06:45:00 | AAPL | Stock | 174.3 | 174.31 | 174.3 | 174.31 | 1200.0 |
| 2024-04-30 06:50:00 | AAPL | Stock | 174.3 | 174.3 | 174.28 | 174.28 | 790.0 |
| 2024-04-30 06:55:00 | AAPL | Stock | 174.23 | 174.23 | 174.23 | 174.23 | 100.0 |
| 2024-04-30 07:00:00 | AAPL | Stock | 174.22 | 174.22 | 173.91 | 173.91 | 7048.0 |
| 2024-04-30 07:05:00 | AAPL | Stock | 173.88 | 173.9 | 173.85 | 173.86 | 1933.0 |
| 2024-04-30 07:10:00 | AAPL | Stock | 173.84 | 173.94 | 173.84 | 173.94 | 905.0 |
| 2024-04-30 07:15:00 | AAPL | Stock | 173.89 | 174.1 | 173.88 | 174.1 | 2399.0 |
| 2024-04-30 07:20:00 | AAPL | Stock | 174.09 | 174.09 | 174.0 | 174.0 | 1038.0 |
| 2024-04-30 07:25:00 | AAPL | Stock | 173.94 | 173.94 | 173.93 | 173.93 | 245.0 |
| 2024-04-30 07:35:00 | AAPL | Stock | 173.87 | 173.92 | 173.87 | 173.92 | 500.0 |
| 2024-04-30 07:40:00 | AAPL | Stock | 173.94 | 173.94 | 173.94 | 173.94 | 100.0 |
| 2024-04-30 07:45:00 | AAPL | Stock | 173.88 | 173.88 | 173.79 | 173.8 | 1377.0 |
| 2024-04-30 07:50:00 | AAPL | Stock | 173.81 | 173.81 | 173.81 | 173.81 | 154.0 |
| 2024-04-30 07:55:00 | AAPL | Stock | 173.78 | 173.78 | 173.75 | 173.75 | 600.0 |
| 2024-04-30 08:00:00 | AAPL | Stock | 173.95 | 174.5 | 173.7 | 174.37 | 73486.0 |
| 2024-04-30 08:05:00 | AAPL | Stock | 173.8278 | 173.8278 | 173.67 | 173.67 | 10430.0 |
| 2024-04-30 08:10:00 | AAPL | Stock | 173.67 | 173.77 | 173.65 | 173.6536 | 2679.0 |
| 2024-04-30 08:15:00 | AAPL | Stock | 173.7 | 173.7001 | 173.6703 | 173.7001 | 919.0 |
| 2024-04-30 08:20:00 | AAPL | Stock | 173.75 | 173.75 | 173.68 | 173.7199 | 1888.0 |
| 2024-04-30 08:25:00 | AAPL | Stock | 173.68 | 173.72 | 173.672 | 173.68 | 4045.0 |
| 2024-04-30 08:30:00 | AAPL | Stock | 173.65 | 173.65 | 172.873 | 173.08 | 39926.0 |
| 2024-04-30 08:35:00 | AAPL | Stock | 173.09 | 173.35 | 172.91 | 172.91 | 23687.0 |
| 2024-04-30 08:40:00 | AAPL | Stock | 172.84 | 173.15 | 172.79 | 173.15 | 5508.0 |
> showing 50 of 395,499 rows — these rows as CSV