PREVIEW / stock_5min / 2023-08-08
file: by_date/stock_5min/2023/2023-08-08.parquet size: 6.7 MB rows: 408,428 symbols: 1,478
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-08 04:00:00 | AAPL | Stock | 178.78 | 178.78 | 178.25 | 178.39 | 3078.0 |
| 2023-08-08 04:05:00 | AAPL | Stock | 178.46 | 178.47 | 178.45 | 178.47 | 3815.0 |
| 2023-08-08 04:10:00 | AAPL | Stock | 178.36 | 178.4 | 178.36 | 178.4 | 330.0 |
| 2023-08-08 04:15:00 | AAPL | Stock | 178.4 | 178.41 | 178.36 | 178.36 | 678.0 |
| 2023-08-08 04:20:00 | AAPL | Stock | 178.35 | 178.35 | 178.35 | 178.35 | 320.0 |
| 2023-08-08 04:25:00 | AAPL | Stock | 178.4 | 178.44 | 178.4 | 178.44 | 5072.0 |
| 2023-08-08 04:30:00 | AAPL | Stock | 178.42 | 178.47 | 178.42 | 178.47 | 773.0 |
| 2023-08-08 04:35:00 | AAPL | Stock | 178.46 | 178.47 | 178.46 | 178.47 | 4419.0 |
| 2023-08-08 04:40:00 | AAPL | Stock | 178.47 | 178.5 | 178.47 | 178.5 | 3345.0 |
| 2023-08-08 04:45:00 | AAPL | Stock | 178.55 | 178.65 | 178.55 | 178.64 | 600.0 |
| 2023-08-08 04:50:00 | AAPL | Stock | 178.65 | 178.65 | 178.64 | 178.64 | 228.0 |
| 2023-08-08 04:55:00 | AAPL | Stock | 178.7 | 178.7 | 178.69 | 178.7 | 939.0 |
| 2023-08-08 05:05:00 | AAPL | Stock | 178.73 | 178.73 | 178.73 | 178.73 | 100.0 |
| 2023-08-08 05:10:00 | AAPL | Stock | 178.74 | 178.78 | 178.6 | 178.6 | 20930.0 |
| 2023-08-08 05:15:00 | AAPL | Stock | 178.57 | 178.66 | 178.48 | 178.65 | 2433.0 |
| 2023-08-08 05:20:00 | AAPL | Stock | 178.63 | 178.69 | 178.63 | 178.69 | 500.0 |
| 2023-08-08 05:25:00 | AAPL | Stock | 178.72 | 178.72 | 178.65 | 178.65 | 858.0 |
| 2023-08-08 05:30:00 | AAPL | Stock | 178.73 | 178.83 | 178.73 | 178.81 | 3075.0 |
| 2023-08-08 05:35:00 | AAPL | Stock | 178.8 | 178.89 | 178.8 | 178.83 | 1301.0 |
| 2023-08-08 05:40:00 | AAPL | Stock | 178.89 | 179.1 | 178.89 | 179.1 | 2729.0 |
| 2023-08-08 05:45:00 | AAPL | Stock | 179.06 | 179.06 | 179.06 | 179.06 | 200.0 |
| 2023-08-08 05:50:00 | AAPL | Stock | 179.07 | 179.08 | 179.07 | 179.08 | 300.0 |
| 2023-08-08 05:55:00 | AAPL | Stock | 179.07 | 179.19 | 179.07 | 179.19 | 2619.0 |
| 2023-08-08 06:00:00 | AAPL | Stock | 179.18 | 179.19 | 179.17 | 179.19 | 1221.0 |
| 2023-08-08 06:05:00 | AAPL | Stock | 179.28 | 179.37 | 179.28 | 179.37 | 1673.0 |
| 2023-08-08 06:10:00 | AAPL | Stock | 179.35 | 179.39 | 179.33 | 179.39 | 2126.0 |
| 2023-08-08 06:15:00 | AAPL | Stock | 179.4 | 179.41 | 179.34 | 179.36 | 1775.0 |
| 2023-08-08 06:20:00 | AAPL | Stock | 179.3 | 179.5 | 179.25 | 179.41 | 4996.0 |
| 2023-08-08 06:25:00 | AAPL | Stock | 179.39 | 179.39 | 179.31 | 179.32 | 853.0 |
| 2023-08-08 06:30:00 | AAPL | Stock | 179.31 | 179.31 | 179.2 | 179.24 | 2591.0 |
| 2023-08-08 06:35:00 | AAPL | Stock | 179.2 | 179.21 | 179.1 | 179.1 | 1049.0 |
| 2023-08-08 06:40:00 | AAPL | Stock | 179.1 | 179.15 | 179.1 | 179.15 | 789.0 |
| 2023-08-08 06:50:00 | AAPL | Stock | 179.27 | 179.28 | 179.17 | 179.17 | 1844.0 |
| 2023-08-08 06:55:00 | AAPL | Stock | 179.31 | 179.31 | 179.2 | 179.2 | 5617.0 |
| 2023-08-08 07:00:00 | AAPL | Stock | 179.25 | 179.26 | 179.0 | 179.0 | 18184.0 |
| 2023-08-08 07:05:00 | AAPL | Stock | 178.92 | 179.0 | 178.85 | 178.88 | 8496.0 |
| 2023-08-08 07:10:00 | AAPL | Stock | 178.86 | 178.86 | 178.6 | 178.6 | 5450.0 |
| 2023-08-08 07:15:00 | AAPL | Stock | 178.65 | 178.8 | 178.65 | 178.66 | 3499.0 |
| 2023-08-08 07:20:00 | AAPL | Stock | 178.63 | 178.7 | 178.6 | 178.7 | 6242.0 |
| 2023-08-08 07:25:00 | AAPL | Stock | 178.75 | 178.75 | 178.52 | 178.52 | 3527.0 |
| 2023-08-08 07:30:00 | AAPL | Stock | 178.5 | 178.5 | 178.3 | 178.34 | 7750.0 |
| 2023-08-08 07:35:00 | AAPL | Stock | 178.3 | 178.48 | 178.29 | 178.35 | 5003.0 |
| 2023-08-08 07:40:00 | AAPL | Stock | 178.39 | 178.51 | 178.39 | 178.47 | 5211.0 |
| 2023-08-08 07:45:00 | AAPL | Stock | 178.46 | 178.46 | 178.39 | 178.42 | 1259.0 |
| 2023-08-08 07:50:00 | AAPL | Stock | 178.48 | 178.64 | 178.48 | 178.64 | 2058.0 |
| 2023-08-08 07:55:00 | AAPL | Stock | 178.62 | 178.64 | 178.6 | 178.64 | 3420.0 |
| 2023-08-08 08:00:00 | AAPL | Stock | 179.17 | 179.47 | 178.29 | 178.55 | 121686.0 |
| 2023-08-08 08:05:00 | AAPL | Stock | 178.57 | 178.57 | 178.16 | 178.3 | 26833.0 |
| 2023-08-08 08:10:00 | AAPL | Stock | 178.41 | 178.67 | 178.41 | 178.6569 | 19814.0 |
| 2023-08-08 08:15:00 | AAPL | Stock | 178.7 | 179.0 | 178.7 | 178.95 | 22656.0 |
> showing 50 of 408,428 rows — these rows as CSV