PREVIEW / stock_5min / 2023-06-27
file: by_date/stock_5min/2023/2023-06-27.parquet size: 6.7 MB rows: 408,055 symbols: 1,577
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-27 04:05:00 | AAPL | Stock | 185.85 | 185.9 | 185.85 | 185.89 | 1110.0 |
| 2023-06-27 04:10:00 | AAPL | Stock | 185.88 | 185.9 | 185.85 | 185.9 | 1056.0 |
| 2023-06-27 04:15:00 | AAPL | Stock | 186.0 | 186.15 | 186.0 | 186.15 | 596.0 |
| 2023-06-27 04:20:00 | AAPL | Stock | 186.1 | 186.1 | 186.1 | 186.1 | 146.0 |
| 2023-06-27 04:25:00 | AAPL | Stock | 186.0 | 186.01 | 185.99 | 186.01 | 463.0 |
| 2023-06-27 04:30:00 | AAPL | Stock | 185.95 | 185.97 | 185.75 | 185.75 | 3048.0 |
| 2023-06-27 04:35:00 | AAPL | Stock | 185.65 | 185.65 | 185.65 | 185.65 | 100.0 |
| 2023-06-27 04:40:00 | AAPL | Stock | 185.69 | 185.69 | 185.65 | 185.65 | 583.0 |
| 2023-06-27 05:10:00 | AAPL | Stock | 185.81 | 185.97 | 185.81 | 185.97 | 334.0 |
| 2023-06-27 05:15:00 | AAPL | Stock | 185.88 | 185.88 | 185.88 | 185.88 | 100.0 |
| 2023-06-27 05:20:00 | AAPL | Stock | 185.93 | 185.93 | 185.85 | 185.85 | 797.0 |
| 2023-06-27 05:25:00 | AAPL | Stock | 185.93 | 185.93 | 185.93 | 185.93 | 100.0 |
| 2023-06-27 05:40:00 | AAPL | Stock | 185.87 | 185.87 | 185.87 | 185.87 | 100.0 |
| 2023-06-27 05:45:00 | AAPL | Stock | 185.8 | 185.8 | 185.8 | 185.8 | 113.0 |
| 2023-06-27 05:55:00 | AAPL | Stock | 185.81 | 185.81 | 185.81 | 185.81 | 432.0 |
| 2023-06-27 06:05:00 | AAPL | Stock | 185.7 | 185.7 | 185.7 | 185.7 | 100.0 |
| 2023-06-27 06:25:00 | AAPL | Stock | 185.72 | 185.72 | 185.72 | 185.72 | 119.0 |
| 2023-06-27 06:35:00 | AAPL | Stock | 185.81 | 185.81 | 185.8 | 185.8 | 1171.0 |
| 2023-06-27 06:50:00 | AAPL | Stock | 185.88 | 185.88 | 185.83 | 185.83 | 720.0 |
| 2023-06-27 06:55:00 | AAPL | Stock | 185.83 | 185.83 | 185.83 | 185.83 | 100.0 |
| 2023-06-27 07:00:00 | AAPL | Stock | 185.8 | 185.82 | 185.74 | 185.74 | 4187.0 |
| 2023-06-27 07:05:00 | AAPL | Stock | 185.75 | 185.81 | 185.75 | 185.8 | 3086.0 |
| 2023-06-27 07:10:00 | AAPL | Stock | 185.8 | 185.8 | 185.8 | 185.8 | 1140.0 |
| 2023-06-27 07:15:00 | AAPL | Stock | 185.84 | 185.86 | 185.7 | 185.7 | 2322.0 |
| 2023-06-27 07:20:00 | AAPL | Stock | 185.68 | 185.72 | 185.64 | 185.64 | 2152.0 |
| 2023-06-27 07:25:00 | AAPL | Stock | 185.7 | 185.7 | 185.7 | 185.7 | 1720.0 |
| 2023-06-27 07:30:00 | AAPL | Stock | 185.64 | 185.65 | 185.58 | 185.58 | 3440.0 |
| 2023-06-27 07:35:00 | AAPL | Stock | 185.6 | 185.63 | 185.6 | 185.63 | 1124.0 |
| 2023-06-27 07:40:00 | AAPL | Stock | 185.6 | 185.63 | 185.58 | 185.58 | 2959.0 |
| 2023-06-27 07:45:00 | AAPL | Stock | 185.58 | 185.58 | 185.46 | 185.55 | 4162.0 |
| 2023-06-27 07:50:00 | AAPL | Stock | 185.59 | 185.59 | 185.42 | 185.46 | 3218.0 |
| 2023-06-27 07:55:00 | AAPL | Stock | 185.5 | 185.61 | 185.5 | 185.55 | 1082.0 |
| 2023-06-27 08:00:00 | AAPL | Stock | 185.82 | 186.05 | 185.27 | 185.6 | 45356.0 |
| 2023-06-27 08:05:00 | AAPL | Stock | 185.5 | 185.65 | 185.5 | 185.62 | 4599.0 |
| 2023-06-27 08:10:00 | AAPL | Stock | 185.6 | 185.65 | 185.53 | 185.57 | 2700.0 |
| 2023-06-27 08:15:00 | AAPL | Stock | 185.6452 | 185.6452 | 185.57 | 185.59 | 1534.0 |
| 2023-06-27 08:20:00 | AAPL | Stock | 185.55 | 185.57 | 185.53 | 185.5302 | 2587.0 |
| 2023-06-27 08:25:00 | AAPL | Stock | 185.5601 | 185.6589 | 185.56 | 185.65 | 2374.0 |
| 2023-06-27 08:30:00 | AAPL | Stock | 185.6 | 185.8355 | 185.55 | 185.8355 | 15085.0 |
| 2023-06-27 08:35:00 | AAPL | Stock | 185.81 | 185.96 | 185.73 | 185.95 | 12983.0 |
| 2023-06-27 08:40:00 | AAPL | Stock | 185.97 | 185.98 | 185.7634 | 185.7634 | 5703.0 |
| 2023-06-27 08:45:00 | AAPL | Stock | 185.76 | 185.8597 | 185.76 | 185.78 | 5705.0 |
| 2023-06-27 08:50:00 | AAPL | Stock | 185.8 | 185.83 | 185.7386 | 185.76 | 5015.0 |
| 2023-06-27 08:55:00 | AAPL | Stock | 185.79 | 185.88 | 185.73 | 185.87 | 5118.0 |
| 2023-06-27 09:00:00 | AAPL | Stock | 185.84 | 185.88 | 185.77 | 185.88 | 2674.0 |
| 2023-06-27 09:05:00 | AAPL | Stock | 185.85 | 185.8899 | 185.78 | 185.8899 | 13592.0 |
| 2023-06-27 09:10:00 | AAPL | Stock | 185.8508 | 186.0 | 185.85 | 185.96 | 16432.0 |
| 2023-06-27 09:15:00 | AAPL | Stock | 185.97 | 186.0102 | 185.85 | 185.94 | 26728.0 |
| 2023-06-27 09:20:00 | AAPL | Stock | 185.92 | 185.95 | 185.88 | 185.9 | 13115.0 |
| 2023-06-27 09:25:00 | AAPL | Stock | 185.9 | 185.97 | 185.75 | 185.91 | 28939.0 |
> showing 50 of 408,055 rows — these rows as CSV