PREVIEW / stock_5min / 2023-07-28
file: by_date/stock_5min/2023/2023-07-28.parquet size: 6.7 MB rows: 406,770 symbols: 1,529
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-07-28 04:00:00 | AAPL | Stock | 194.03 | 194.37 | 194.03 | 194.3 | 1052.0 |
| 2023-07-28 04:05:00 | AAPL | Stock | 194.22 | 194.42 | 194.16 | 194.42 | 3404.0 |
| 2023-07-28 04:10:00 | AAPL | Stock | 194.42 | 194.48 | 194.32 | 194.32 | 1418.0 |
| 2023-07-28 04:15:00 | AAPL | Stock | 194.39 | 194.48 | 194.39 | 194.45 | 2363.0 |
| 2023-07-28 04:20:00 | AAPL | Stock | 194.32 | 194.38 | 194.3 | 194.3 | 1018.0 |
| 2023-07-28 04:25:00 | AAPL | Stock | 194.3 | 194.35 | 194.3 | 194.3 | 700.0 |
| 2023-07-28 04:30:00 | AAPL | Stock | 194.32 | 194.44 | 194.32 | 194.44 | 1440.0 |
| 2023-07-28 04:35:00 | AAPL | Stock | 194.44 | 194.44 | 194.39 | 194.43 | 1331.0 |
| 2023-07-28 04:40:00 | AAPL | Stock | 194.39 | 194.39 | 194.39 | 194.39 | 1983.0 |
| 2023-07-28 04:45:00 | AAPL | Stock | 194.37 | 194.45 | 194.37 | 194.39 | 1479.0 |
| 2023-07-28 04:55:00 | AAPL | Stock | 194.48 | 194.67 | 194.48 | 194.67 | 1093.0 |
| 2023-07-28 05:00:00 | AAPL | Stock | 194.55 | 194.55 | 194.55 | 194.55 | 100.0 |
| 2023-07-28 05:05:00 | AAPL | Stock | 194.55 | 194.55 | 194.55 | 194.55 | 298.0 |
| 2023-07-28 05:10:00 | AAPL | Stock | 194.5 | 194.5 | 194.45 | 194.45 | 1014.0 |
| 2023-07-28 05:20:00 | AAPL | Stock | 194.44 | 194.45 | 194.44 | 194.45 | 624.0 |
| 2023-07-28 05:30:00 | AAPL | Stock | 194.5 | 194.5 | 194.5 | 194.5 | 136.0 |
| 2023-07-28 05:35:00 | AAPL | Stock | 194.6 | 194.6 | 194.6 | 194.6 | 200.0 |
| 2023-07-28 05:40:00 | AAPL | Stock | 194.69 | 194.73 | 194.69 | 194.7 | 1705.0 |
| 2023-07-28 05:45:00 | AAPL | Stock | 194.73 | 194.9 | 194.73 | 194.9 | 1185.0 |
| 2023-07-28 05:50:00 | AAPL | Stock | 194.9 | 194.9 | 194.88 | 194.88 | 593.0 |
| 2023-07-28 05:55:00 | AAPL | Stock | 194.84 | 194.9 | 194.84 | 194.9 | 1669.0 |
| 2023-07-28 06:00:00 | AAPL | Stock | 194.9 | 194.9 | 194.88 | 194.88 | 475.0 |
| 2023-07-28 06:05:00 | AAPL | Stock | 194.83 | 194.83 | 194.78 | 194.78 | 217.0 |
| 2023-07-28 06:10:00 | AAPL | Stock | 194.78 | 194.8 | 194.78 | 194.8 | 2396.0 |
| 2023-07-28 06:20:00 | AAPL | Stock | 194.75 | 194.75 | 194.75 | 194.75 | 100.0 |
| 2023-07-28 06:25:00 | AAPL | Stock | 194.72 | 194.72 | 194.7 | 194.7 | 436.0 |
| 2023-07-28 06:40:00 | AAPL | Stock | 194.65 | 194.81 | 194.65 | 194.81 | 268.0 |
| 2023-07-28 06:45:00 | AAPL | Stock | 194.77 | 194.77 | 194.77 | 194.77 | 100.0 |
| 2023-07-28 06:50:00 | AAPL | Stock | 194.78 | 194.88 | 194.78 | 194.88 | 2372.0 |
| 2023-07-28 07:00:00 | AAPL | Stock | 194.76 | 194.78 | 194.65 | 194.72 | 4852.0 |
| 2023-07-28 07:05:00 | AAPL | Stock | 194.75 | 194.79 | 194.74 | 194.74 | 2737.0 |
| 2023-07-28 07:10:00 | AAPL | Stock | 194.71 | 194.71 | 194.7 | 194.7 | 1064.0 |
| 2023-07-28 07:15:00 | AAPL | Stock | 194.69 | 194.78 | 194.69 | 194.76 | 4521.0 |
| 2023-07-28 07:20:00 | AAPL | Stock | 194.74 | 194.74 | 194.7 | 194.7 | 520.0 |
| 2023-07-28 07:25:00 | AAPL | Stock | 194.67 | 194.75 | 194.66 | 194.72 | 1052.0 |
| 2023-07-28 07:30:00 | AAPL | Stock | 194.7 | 194.75 | 194.67 | 194.72 | 3624.0 |
| 2023-07-28 07:35:00 | AAPL | Stock | 194.67 | 194.74 | 194.66 | 194.7 | 2514.0 |
| 2023-07-28 07:40:00 | AAPL | Stock | 194.68 | 194.68 | 194.6 | 194.6 | 2641.0 |
| 2023-07-28 07:45:00 | AAPL | Stock | 194.65 | 194.7 | 194.65 | 194.7 | 1121.0 |
| 2023-07-28 07:50:00 | AAPL | Stock | 194.69 | 194.72 | 194.69 | 194.72 | 1278.0 |
| 2023-07-28 07:55:00 | AAPL | Stock | 194.7 | 194.7 | 194.66 | 194.69 | 2344.0 |
| 2023-07-28 08:00:00 | AAPL | Stock | 194.75 | 194.79 | 193.84 | 194.79 | 63046.0 |
| 2023-07-28 08:05:00 | AAPL | Stock | 194.8 | 194.8 | 194.67 | 194.69 | 6265.0 |
| 2023-07-28 08:10:00 | AAPL | Stock | 194.75 | 194.78 | 194.7 | 194.7 | 5893.0 |
| 2023-07-28 08:15:00 | AAPL | Stock | 194.7 | 194.97 | 194.7 | 194.86 | 26445.0 |
| 2023-07-28 08:20:00 | AAPL | Stock | 194.89 | 194.9699 | 194.83 | 194.9699 | 8680.0 |
| 2023-07-28 08:25:00 | AAPL | Stock | 194.96 | 194.99 | 194.9 | 194.95 | 4979.0 |
| 2023-07-28 08:30:00 | AAPL | Stock | 194.98 | 195.2 | 194.85 | 194.85 | 21647.0 |
| 2023-07-28 08:35:00 | AAPL | Stock | 194.85 | 195.06 | 194.8 | 195.02 | 16598.0 |
| 2023-07-28 08:40:00 | AAPL | Stock | 195.03 | 195.05 | 194.9 | 194.9 | 8479.0 |
> showing 50 of 406,770 rows — these rows as CSV