PREVIEW / stock_5min / 2023-09-21
file: by_date/stock_5min/2023/2023-09-21.parquet size: 6.5 MB rows: 395,030 symbols: 1,396
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-09-21 04:05:00 | AAPL | Stock | 175.01 | 175.03 | 174.79 | 174.79 | 3819.0 |
| 2023-09-21 04:10:00 | AAPL | Stock | 174.89 | 174.89 | 174.77 | 174.85 | 1437.0 |
| 2023-09-21 04:15:00 | AAPL | Stock | 174.77 | 174.77 | 174.75 | 174.77 | 2995.0 |
| 2023-09-21 04:20:00 | AAPL | Stock | 174.73 | 174.75 | 174.73 | 174.75 | 1710.0 |
| 2023-09-21 04:25:00 | AAPL | Stock | 174.75 | 174.83 | 174.72 | 174.83 | 2551.0 |
| 2023-09-21 04:30:00 | AAPL | Stock | 174.76 | 174.78 | 174.68 | 174.68 | 4050.0 |
| 2023-09-21 04:35:00 | AAPL | Stock | 174.68 | 174.68 | 174.56 | 174.56 | 5592.0 |
| 2023-09-21 04:40:00 | AAPL | Stock | 174.6 | 174.65 | 174.6 | 174.65 | 633.0 |
| 2023-09-21 04:45:00 | AAPL | Stock | 174.65 | 174.65 | 174.65 | 174.65 | 585.0 |
| 2023-09-21 04:50:00 | AAPL | Stock | 174.69 | 174.69 | 174.63 | 174.63 | 299.0 |
| 2023-09-21 04:55:00 | AAPL | Stock | 174.6 | 174.61 | 174.55 | 174.61 | 955.0 |
| 2023-09-21 05:00:00 | AAPL | Stock | 174.6 | 174.69 | 174.6 | 174.69 | 2651.0 |
| 2023-09-21 05:05:00 | AAPL | Stock | 174.71 | 174.71 | 174.71 | 174.71 | 612.0 |
| 2023-09-21 05:10:00 | AAPL | Stock | 174.72 | 174.72 | 174.72 | 174.72 | 100.0 |
| 2023-09-21 05:15:00 | AAPL | Stock | 174.72 | 174.72 | 174.7 | 174.7 | 2425.0 |
| 2023-09-21 05:20:00 | AAPL | Stock | 174.64 | 174.64 | 174.63 | 174.63 | 200.0 |
| 2023-09-21 05:25:00 | AAPL | Stock | 174.63 | 174.63 | 174.62 | 174.63 | 1949.0 |
| 2023-09-21 05:30:00 | AAPL | Stock | 174.64 | 174.65 | 174.64 | 174.65 | 1614.0 |
| 2023-09-21 05:35:00 | AAPL | Stock | 174.62 | 174.62 | 174.62 | 174.62 | 100.0 |
| 2023-09-21 05:40:00 | AAPL | Stock | 174.65 | 174.68 | 174.65 | 174.68 | 408.0 |
| 2023-09-21 05:45:00 | AAPL | Stock | 174.65 | 174.65 | 174.55 | 174.56 | 2268.0 |
| 2023-09-21 05:50:00 | AAPL | Stock | 174.58 | 174.6 | 174.55 | 174.57 | 1418.0 |
| 2023-09-21 05:55:00 | AAPL | Stock | 174.58 | 174.58 | 174.5 | 174.53 | 2742.0 |
| 2023-09-21 06:00:00 | AAPL | Stock | 174.54 | 174.54 | 174.5 | 174.5 | 2874.0 |
| 2023-09-21 06:05:00 | AAPL | Stock | 174.48 | 174.5 | 174.45 | 174.5 | 2878.0 |
| 2023-09-21 06:10:00 | AAPL | Stock | 174.46 | 174.6 | 174.46 | 174.55 | 2433.0 |
| 2023-09-21 06:15:00 | AAPL | Stock | 174.57 | 174.57 | 174.57 | 174.57 | 788.0 |
| 2023-09-21 06:20:00 | AAPL | Stock | 174.5 | 174.62 | 174.5 | 174.62 | 5556.0 |
| 2023-09-21 06:25:00 | AAPL | Stock | 174.56 | 174.6 | 174.53 | 174.55 | 952.0 |
| 2023-09-21 06:30:00 | AAPL | Stock | 174.59 | 174.6 | 174.5 | 174.5 | 830.0 |
| 2023-09-21 06:35:00 | AAPL | Stock | 174.6 | 174.6 | 174.5 | 174.5 | 2964.0 |
| 2023-09-21 06:40:00 | AAPL | Stock | 174.5 | 174.58 | 174.5 | 174.58 | 900.0 |
| 2023-09-21 06:45:00 | AAPL | Stock | 174.58 | 174.58 | 174.45 | 174.45 | 3509.0 |
| 2023-09-21 06:50:00 | AAPL | Stock | 174.45 | 174.45 | 174.34 | 174.35 | 7715.0 |
| 2023-09-21 06:55:00 | AAPL | Stock | 174.43 | 174.48 | 174.43 | 174.48 | 937.0 |
| 2023-09-21 07:00:00 | AAPL | Stock | 174.58 | 174.64 | 174.4 | 174.45 | 13539.0 |
| 2023-09-21 07:05:00 | AAPL | Stock | 174.45 | 174.48 | 174.32 | 174.39 | 8822.0 |
| 2023-09-21 07:10:00 | AAPL | Stock | 174.39 | 174.42 | 174.2 | 174.29 | 13893.0 |
| 2023-09-21 07:15:00 | AAPL | Stock | 174.35 | 174.39 | 174.31 | 174.35 | 6180.0 |
| 2023-09-21 07:20:00 | AAPL | Stock | 174.33 | 174.4 | 174.3 | 174.3 | 5963.0 |
| 2023-09-21 07:25:00 | AAPL | Stock | 174.3 | 174.4 | 174.3 | 174.31 | 5926.0 |
| 2023-09-21 07:30:00 | AAPL | Stock | 174.31 | 174.35 | 174.2 | 174.25 | 9447.0 |
| 2023-09-21 07:35:00 | AAPL | Stock | 174.3 | 174.42 | 174.27 | 174.36 | 8354.0 |
| 2023-09-21 07:40:00 | AAPL | Stock | 174.37 | 174.42 | 174.35 | 174.42 | 1888.0 |
| 2023-09-21 07:45:00 | AAPL | Stock | 174.49 | 174.66 | 174.45 | 174.63 | 9555.0 |
| 2023-09-21 07:50:00 | AAPL | Stock | 174.55 | 174.66 | 174.55 | 174.62 | 10448.0 |
| 2023-09-21 07:55:00 | AAPL | Stock | 174.62 | 174.65 | 174.35 | 174.5 | 9309.0 |
| 2023-09-21 08:00:00 | AAPL | Stock | 174.7 | 175.05 | 174.2001 | 174.55 | 75028.0 |
| 2023-09-21 08:05:00 | AAPL | Stock | 174.69 | 174.69 | 174.4301 | 174.45 | 7694.0 |
| 2023-09-21 08:10:00 | AAPL | Stock | 174.5 | 174.6499 | 174.4 | 174.6381 | 8876.0 |
> showing 50 of 395,030 rows — these rows as CSV