PREVIEW / stock_5min / 2023-06-29
file: by_date/stock_5min/2023/2023-06-29.parquet size: 6.7 MB rows: 410,539 symbols: 1,578
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-06-29 04:00:00 | AAPL | Stock | 189.25 | 189.25 | 189.15 | 189.23 | 883.0 |
| 2023-06-29 04:05:00 | AAPL | Stock | 189.3 | 189.34 | 189.13 | 189.34 | 2006.0 |
| 2023-06-29 04:15:00 | AAPL | Stock | 189.45 | 189.45 | 189.45 | 189.45 | 377.0 |
| 2023-06-29 04:20:00 | AAPL | Stock | 189.52 | 189.52 | 189.42 | 189.42 | 1003.0 |
| 2023-06-29 04:25:00 | AAPL | Stock | 189.42 | 189.5 | 189.41 | 189.5 | 1876.0 |
| 2023-06-29 04:30:00 | AAPL | Stock | 189.56 | 189.56 | 189.38 | 189.38 | 1544.0 |
| 2023-06-29 04:35:00 | AAPL | Stock | 189.39 | 189.52 | 189.39 | 189.5 | 1480.0 |
| 2023-06-29 04:40:00 | AAPL | Stock | 189.5 | 189.5 | 189.41 | 189.5 | 741.0 |
| 2023-06-29 04:45:00 | AAPL | Stock | 189.48 | 189.5 | 189.48 | 189.5 | 1283.0 |
| 2023-06-29 04:50:00 | AAPL | Stock | 189.5 | 189.5 | 189.41 | 189.41 | 797.0 |
| 2023-06-29 05:00:00 | AAPL | Stock | 189.53 | 189.53 | 189.43 | 189.43 | 609.0 |
| 2023-06-29 05:05:00 | AAPL | Stock | 189.43 | 189.48 | 189.43 | 189.43 | 1142.0 |
| 2023-06-29 05:10:00 | AAPL | Stock | 189.5 | 189.53 | 189.5 | 189.53 | 2414.0 |
| 2023-06-29 05:15:00 | AAPL | Stock | 189.45 | 189.45 | 189.45 | 189.45 | 112.0 |
| 2023-06-29 05:20:00 | AAPL | Stock | 189.43 | 189.43 | 189.42 | 189.42 | 797.0 |
| 2023-06-29 05:25:00 | AAPL | Stock | 189.41 | 189.41 | 189.4 | 189.4 | 209.0 |
| 2023-06-29 05:30:00 | AAPL | Stock | 189.4 | 189.4 | 189.4 | 189.4 | 100.0 |
| 2023-06-29 05:40:00 | AAPL | Stock | 189.54 | 189.65 | 189.54 | 189.65 | 450.0 |
| 2023-06-29 05:45:00 | AAPL | Stock | 189.6 | 189.6 | 189.6 | 189.6 | 409.0 |
| 2023-06-29 05:50:00 | AAPL | Stock | 189.61 | 189.61 | 189.61 | 189.61 | 126.0 |
| 2023-06-29 06:00:00 | AAPL | Stock | 189.69 | 189.81 | 189.6 | 189.6 | 2913.0 |
| 2023-06-29 06:05:00 | AAPL | Stock | 189.51 | 189.51 | 189.51 | 189.51 | 100.0 |
| 2023-06-29 06:15:00 | AAPL | Stock | 189.72 | 189.8 | 189.72 | 189.8 | 834.0 |
| 2023-06-29 06:20:00 | AAPL | Stock | 189.8 | 189.8 | 189.78 | 189.78 | 248.0 |
| 2023-06-29 06:30:00 | AAPL | Stock | 189.79 | 189.79 | 189.79 | 189.79 | 100.0 |
| 2023-06-29 06:35:00 | AAPL | Stock | 189.73 | 189.73 | 189.73 | 189.73 | 116.0 |
| 2023-06-29 06:40:00 | AAPL | Stock | 189.75 | 189.75 | 189.75 | 189.75 | 282.0 |
| 2023-06-29 06:45:00 | AAPL | Stock | 189.78 | 189.78 | 189.78 | 189.78 | 200.0 |
| 2023-06-29 06:50:00 | AAPL | Stock | 189.75 | 189.76 | 189.75 | 189.75 | 311.0 |
| 2023-06-29 06:55:00 | AAPL | Stock | 189.7 | 189.7 | 189.7 | 189.7 | 674.0 |
| 2023-06-29 07:00:00 | AAPL | Stock | 189.65 | 189.77 | 189.65 | 189.65 | 5477.0 |
| 2023-06-29 07:05:00 | AAPL | Stock | 189.6 | 189.8 | 189.6 | 189.8 | 2532.0 |
| 2023-06-29 07:10:00 | AAPL | Stock | 189.8 | 189.85 | 189.8 | 189.8 | 3942.0 |
| 2023-06-29 07:15:00 | AAPL | Stock | 189.8 | 189.85 | 189.72 | 189.76 | 2666.0 |
| 2023-06-29 07:20:00 | AAPL | Stock | 189.76 | 189.76 | 189.69 | 189.69 | 1687.0 |
| 2023-06-29 07:25:00 | AAPL | Stock | 189.7 | 189.82 | 189.7 | 189.82 | 3110.0 |
| 2023-06-29 07:30:00 | AAPL | Stock | 189.84 | 189.84 | 189.8 | 189.82 | 2433.0 |
| 2023-06-29 07:35:00 | AAPL | Stock | 189.77 | 189.8 | 189.7 | 189.7 | 3692.0 |
| 2023-06-29 07:40:00 | AAPL | Stock | 189.67 | 189.8 | 189.67 | 189.79 | 1673.0 |
| 2023-06-29 07:45:00 | AAPL | Stock | 189.79 | 189.79 | 189.75 | 189.78 | 1035.0 |
| 2023-06-29 07:50:00 | AAPL | Stock | 189.8 | 189.82 | 189.8 | 189.82 | 300.0 |
| 2023-06-29 07:55:00 | AAPL | Stock | 189.83 | 189.85 | 189.8 | 189.83 | 4353.0 |
| 2023-06-29 08:00:00 | AAPL | Stock | 189.7596 | 189.85 | 189.21 | 189.8 | 52726.0 |
| 2023-06-29 08:05:00 | AAPL | Stock | 189.81 | 189.82 | 189.77 | 189.77 | 5305.0 |
| 2023-06-29 08:10:00 | AAPL | Stock | 189.78 | 189.83 | 189.77 | 189.7902 | 3001.0 |
| 2023-06-29 08:15:00 | AAPL | Stock | 189.83 | 189.84 | 189.77 | 189.84 | 16183.0 |
| 2023-06-29 08:20:00 | AAPL | Stock | 189.82 | 189.84 | 189.8 | 189.8385 | 4952.0 |
| 2023-06-29 08:25:00 | AAPL | Stock | 189.84 | 189.85 | 189.81 | 189.81 | 6429.0 |
| 2023-06-29 08:30:00 | AAPL | Stock | 189.81 | 189.91 | 189.6 | 189.72 | 23108.0 |
| 2023-06-29 08:35:00 | AAPL | Stock | 189.65 | 189.65 | 189.43 | 189.59 | 31662.0 |
> showing 50 of 410,539 rows — these rows as CSV