PREVIEW / stock_5min / 2023-08-29
file: by_date/stock_5min/2023/2023-08-29.parquet size: 6.4 MB rows: 389,621 symbols: 1,458
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-08-29 04:00:00 | AAPL | Stock | 180.25 | 180.38 | 180.25 | 180.31 | 3269.0 |
| 2023-08-29 04:05:00 | AAPL | Stock | 180.28 | 180.28 | 180.19 | 180.19 | 653.0 |
| 2023-08-29 04:10:00 | AAPL | Stock | 180.1 | 180.1 | 180.01 | 180.01 | 2944.0 |
| 2023-08-29 04:15:00 | AAPL | Stock | 180.02 | 180.04 | 180.01 | 180.03 | 1269.0 |
| 2023-08-29 04:20:00 | AAPL | Stock | 180.05 | 180.05 | 180.05 | 180.05 | 100.0 |
| 2023-08-29 04:25:00 | AAPL | Stock | 180.14 | 180.26 | 180.14 | 180.26 | 1399.0 |
| 2023-08-29 04:30:00 | AAPL | Stock | 180.1 | 180.1 | 180.1 | 180.1 | 300.0 |
| 2023-08-29 04:35:00 | AAPL | Stock | 180.18 | 180.19 | 180.18 | 180.19 | 740.0 |
| 2023-08-29 04:40:00 | AAPL | Stock | 180.29 | 180.29 | 180.29 | 180.29 | 850.0 |
| 2023-08-29 04:45:00 | AAPL | Stock | 180.3 | 180.32 | 180.3 | 180.32 | 455.0 |
| 2023-08-29 04:50:00 | AAPL | Stock | 180.31 | 180.31 | 180.18 | 180.18 | 300.0 |
| 2023-08-29 04:55:00 | AAPL | Stock | 180.23 | 180.23 | 180.1 | 180.1 | 1590.0 |
| 2023-08-29 05:00:00 | AAPL | Stock | 180.08 | 180.15 | 180.05 | 180.09 | 600.0 |
| 2023-08-29 05:05:00 | AAPL | Stock | 180.11 | 180.19 | 180.11 | 180.19 | 750.0 |
| 2023-08-29 05:10:00 | AAPL | Stock | 180.25 | 180.25 | 180.22 | 180.22 | 900.0 |
| 2023-08-29 05:15:00 | AAPL | Stock | 180.18 | 180.18 | 180.18 | 180.18 | 1689.0 |
| 2023-08-29 05:20:00 | AAPL | Stock | 180.2 | 180.2 | 180.18 | 180.18 | 200.0 |
| 2023-08-29 05:25:00 | AAPL | Stock | 180.18 | 180.21 | 180.18 | 180.2 | 525.0 |
| 2023-08-29 05:30:00 | AAPL | Stock | 180.22 | 180.22 | 180.22 | 180.22 | 100.0 |
| 2023-08-29 05:35:00 | AAPL | Stock | 180.22 | 180.25 | 180.22 | 180.25 | 287.0 |
| 2023-08-29 05:40:00 | AAPL | Stock | 180.25 | 180.28 | 180.25 | 180.28 | 399.0 |
| 2023-08-29 05:45:00 | AAPL | Stock | 180.28 | 180.37 | 180.28 | 180.35 | 1869.0 |
| 2023-08-29 05:50:00 | AAPL | Stock | 180.36 | 180.36 | 180.35 | 180.35 | 305.0 |
| 2023-08-29 05:55:00 | AAPL | Stock | 180.35 | 180.38 | 180.35 | 180.38 | 256.0 |
| 2023-08-29 06:00:00 | AAPL | Stock | 180.43 | 180.43 | 180.36 | 180.36 | 1140.0 |
| 2023-08-29 06:05:00 | AAPL | Stock | 180.44 | 180.55 | 180.44 | 180.48 | 1028.0 |
| 2023-08-29 06:10:00 | AAPL | Stock | 180.5 | 180.52 | 180.37 | 180.43 | 2979.0 |
| 2023-08-29 06:15:00 | AAPL | Stock | 180.42 | 180.42 | 180.29 | 180.29 | 1571.0 |
| 2023-08-29 06:20:00 | AAPL | Stock | 180.29 | 180.39 | 180.29 | 180.38 | 687.0 |
| 2023-08-29 06:25:00 | AAPL | Stock | 180.39 | 180.43 | 180.39 | 180.43 | 255.0 |
| 2023-08-29 06:30:00 | AAPL | Stock | 180.46 | 180.46 | 180.44 | 180.44 | 722.0 |
| 2023-08-29 06:35:00 | AAPL | Stock | 180.43 | 180.43 | 180.4 | 180.4 | 600.0 |
| 2023-08-29 06:40:00 | AAPL | Stock | 180.41 | 180.51 | 180.41 | 180.51 | 1589.0 |
| 2023-08-29 06:45:00 | AAPL | Stock | 180.49 | 180.49 | 180.41 | 180.41 | 2275.0 |
| 2023-08-29 06:50:00 | AAPL | Stock | 180.29 | 180.33 | 180.26 | 180.33 | 975.0 |
| 2023-08-29 06:55:00 | AAPL | Stock | 180.29 | 180.29 | 180.29 | 180.29 | 150.0 |
| 2023-08-29 07:00:00 | AAPL | Stock | 180.3 | 180.3 | 180.25 | 180.29 | 1142.0 |
| 2023-08-29 07:05:00 | AAPL | Stock | 180.3 | 180.38 | 180.3 | 180.3 | 2149.0 |
| 2023-08-29 07:10:00 | AAPL | Stock | 180.3 | 180.37 | 180.3 | 180.34 | 4240.0 |
| 2023-08-29 07:15:00 | AAPL | Stock | 180.33 | 180.33 | 180.3 | 180.3 | 300.0 |
| 2023-08-29 07:20:00 | AAPL | Stock | 180.33 | 180.4 | 180.31 | 180.4 | 4150.0 |
| 2023-08-29 07:25:00 | AAPL | Stock | 180.35 | 180.35 | 180.21 | 180.21 | 1890.0 |
| 2023-08-29 07:30:00 | AAPL | Stock | 180.25 | 180.25 | 180.25 | 180.25 | 612.0 |
| 2023-08-29 07:35:00 | AAPL | Stock | 180.3 | 180.3 | 180.2 | 180.2 | 2195.0 |
| 2023-08-29 07:40:00 | AAPL | Stock | 180.16 | 180.16 | 180.15 | 180.15 | 306.0 |
| 2023-08-29 07:45:00 | AAPL | Stock | 180.15 | 180.15 | 180.1 | 180.1 | 769.0 |
| 2023-08-29 07:50:00 | AAPL | Stock | 180.17 | 180.23 | 180.17 | 180.23 | 2138.0 |
| 2023-08-29 08:00:00 | AAPL | Stock | 180.39 | 180.4 | 180.1 | 180.22 | 18312.0 |
| 2023-08-29 08:05:00 | AAPL | Stock | 180.17 | 180.35 | 180.17 | 180.34 | 5830.0 |
| 2023-08-29 08:10:00 | AAPL | Stock | 180.34 | 180.34 | 180.1888 | 180.1888 | 2395.0 |
> showing 50 of 389,621 rows — these rows as CSV