PREVIEW / stock_5min / 2023-10-03
file: by_date/stock_5min/2023/2023-10-03.parquet size: 6.5 MB rows: 399,068 symbols: 1,400
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-03 04:00:00 | AAPL | Stock | 173.23 | 173.81 | 173.23 | 173.69 | 5889.0 |
| 2023-10-03 04:05:00 | AAPL | Stock | 173.77 | 173.84 | 173.71 | 173.78 | 966.0 |
| 2023-10-03 04:10:00 | AAPL | Stock | 173.78 | 173.78 | 173.6 | 173.6 | 4385.0 |
| 2023-10-03 04:15:00 | AAPL | Stock | 173.65 | 173.8 | 173.65 | 173.8 | 2221.0 |
| 2023-10-03 04:20:00 | AAPL | Stock | 173.81 | 173.81 | 173.8 | 173.8 | 1386.0 |
| 2023-10-03 04:25:00 | AAPL | Stock | 173.81 | 173.87 | 173.79 | 173.85 | 1100.0 |
| 2023-10-03 04:30:00 | AAPL | Stock | 173.86 | 173.87 | 173.81 | 173.87 | 1436.0 |
| 2023-10-03 04:35:00 | AAPL | Stock | 173.81 | 173.81 | 173.78 | 173.78 | 615.0 |
| 2023-10-03 04:40:00 | AAPL | Stock | 173.72 | 173.72 | 173.72 | 173.72 | 350.0 |
| 2023-10-03 04:45:00 | AAPL | Stock | 173.65 | 173.8 | 173.65 | 173.8 | 758.0 |
| 2023-10-03 04:55:00 | AAPL | Stock | 173.75 | 173.8 | 173.75 | 173.8 | 1103.0 |
| 2023-10-03 05:00:00 | AAPL | Stock | 173.67 | 173.67 | 173.54 | 173.54 | 1213.0 |
| 2023-10-03 05:05:00 | AAPL | Stock | 173.53 | 173.53 | 173.53 | 173.53 | 300.0 |
| 2023-10-03 05:10:00 | AAPL | Stock | 173.45 | 173.45 | 173.36 | 173.36 | 1153.0 |
| 2023-10-03 05:15:00 | AAPL | Stock | 173.43 | 173.43 | 173.42 | 173.42 | 519.0 |
| 2023-10-03 05:25:00 | AAPL | Stock | 173.64 | 173.64 | 173.64 | 173.64 | 1013.0 |
| 2023-10-03 05:30:00 | AAPL | Stock | 173.36 | 173.36 | 173.36 | 173.36 | 137.0 |
| 2023-10-03 05:35:00 | AAPL | Stock | 173.36 | 173.36 | 173.23 | 173.23 | 447.0 |
| 2023-10-03 05:45:00 | AAPL | Stock | 173.34 | 173.41 | 173.34 | 173.34 | 803.0 |
| 2023-10-03 06:00:00 | AAPL | Stock | 173.42 | 173.42 | 173.4 | 173.4 | 290.0 |
| 2023-10-03 06:05:00 | AAPL | Stock | 173.5 | 173.5 | 173.5 | 173.5 | 150.0 |
| 2023-10-03 06:20:00 | AAPL | Stock | 173.44 | 173.44 | 173.44 | 173.44 | 100.0 |
| 2023-10-03 06:25:00 | AAPL | Stock | 173.5 | 173.5 | 173.5 | 173.5 | 350.0 |
| 2023-10-03 06:30:00 | AAPL | Stock | 173.69 | 173.69 | 173.63 | 173.69 | 1767.0 |
| 2023-10-03 06:40:00 | AAPL | Stock | 173.5 | 173.5 | 173.32 | 173.32 | 597.0 |
| 2023-10-03 06:45:00 | AAPL | Stock | 173.33 | 173.33 | 173.33 | 173.33 | 400.0 |
| 2023-10-03 06:55:00 | AAPL | Stock | 173.32 | 173.32 | 173.3 | 173.3 | 937.0 |
| 2023-10-03 07:00:00 | AAPL | Stock | 173.33 | 173.37 | 173.22 | 173.22 | 6922.0 |
| 2023-10-03 07:05:00 | AAPL | Stock | 173.22 | 173.27 | 173.15 | 173.15 | 6260.0 |
| 2023-10-03 07:10:00 | AAPL | Stock | 173.1 | 173.1 | 172.98 | 172.98 | 4522.0 |
| 2023-10-03 07:15:00 | AAPL | Stock | 173.0 | 173.0 | 172.89 | 172.89 | 4786.0 |
| 2023-10-03 07:20:00 | AAPL | Stock | 172.98 | 173.0 | 172.75 | 172.75 | 9837.0 |
| 2023-10-03 07:25:00 | AAPL | Stock | 172.71 | 172.75 | 172.63 | 172.75 | 6643.0 |
| 2023-10-03 07:30:00 | AAPL | Stock | 172.75 | 172.89 | 172.75 | 172.89 | 623.0 |
| 2023-10-03 07:35:00 | AAPL | Stock | 172.81 | 172.81 | 172.74 | 172.74 | 650.0 |
| 2023-10-03 07:40:00 | AAPL | Stock | 172.73 | 172.73 | 172.6 | 172.73 | 4700.0 |
| 2023-10-03 07:45:00 | AAPL | Stock | 172.62 | 172.7 | 172.57 | 172.57 | 3631.0 |
| 2023-10-03 07:50:00 | AAPL | Stock | 172.5 | 172.57 | 172.36 | 172.57 | 4035.0 |
| 2023-10-03 07:55:00 | AAPL | Stock | 172.61 | 172.81 | 172.61 | 172.75 | 2931.0 |
| 2023-10-03 08:00:00 | AAPL | Stock | 173.34 | 173.76 | 172.4 | 172.6 | 46032.0 |
| 2023-10-03 08:05:00 | AAPL | Stock | 172.56 | 172.65 | 172.42 | 172.42 | 3848.0 |
| 2023-10-03 08:10:00 | AAPL | Stock | 172.6052 | 172.89 | 172.46 | 172.69 | 14957.0 |
| 2023-10-03 08:15:00 | AAPL | Stock | 172.76 | 172.76 | 172.44 | 172.576 | 3532.0 |
| 2023-10-03 08:20:00 | AAPL | Stock | 172.6 | 172.65 | 172.5 | 172.6 | 5616.0 |
| 2023-10-03 08:25:00 | AAPL | Stock | 172.75 | 172.77 | 172.715 | 172.77 | 2155.0 |
| 2023-10-03 08:30:00 | AAPL | Stock | 172.638 | 172.73 | 172.52 | 172.73 | 1282.0 |
| 2023-10-03 08:35:00 | AAPL | Stock | 172.6798 | 172.6798 | 172.12 | 172.25 | 13195.0 |
| 2023-10-03 08:40:00 | AAPL | Stock | 172.25 | 172.32 | 172.08 | 172.32 | 12211.0 |
| 2023-10-03 08:45:00 | AAPL | Stock | 172.2736 | 172.45 | 172.21 | 172.28 | 9606.0 |
| 2023-10-03 08:50:00 | AAPL | Stock | 172.25 | 172.37 | 172.2 | 172.25 | 6359.0 |
> showing 50 of 399,068 rows — these rows as CSV