PREVIEW / stock_5min / 2024-09-19
file: by_date/stock_5min/2024/2024-09-19.parquet size: 6.9 MB rows: 413,013 symbols: 802
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-19 04:00:00 | AAPL | Stock | 222.79 | 223.8 | 222.79 | 223.8 | 6785.0 |
| 2024-09-19 04:05:00 | AAPL | Stock | 223.81 | 224.0 | 223.79 | 223.95 | 8974.0 |
| 2024-09-19 04:10:00 | AAPL | Stock | 224.07 | 224.3 | 224.05 | 224.24 | 2607.0 |
| 2024-09-19 04:15:00 | AAPL | Stock | 224.24 | 224.24 | 224.0 | 224.0 | 893.0 |
| 2024-09-19 04:20:00 | AAPL | Stock | 223.86 | 223.86 | 223.6 | 223.6 | 2642.0 |
| 2024-09-19 04:25:00 | AAPL | Stock | 223.6 | 223.69 | 223.51 | 223.65 | 1633.0 |
| 2024-09-19 04:30:00 | AAPL | Stock | 223.75 | 224.0 | 223.75 | 223.96 | 4554.0 |
| 2024-09-19 04:35:00 | AAPL | Stock | 223.96 | 224.1 | 223.96 | 224.1 | 10694.0 |
| 2024-09-19 04:40:00 | AAPL | Stock | 224.2 | 224.42 | 224.2 | 224.42 | 3497.0 |
| 2024-09-19 04:45:00 | AAPL | Stock | 224.31 | 224.5 | 224.25 | 224.5 | 4619.0 |
| 2024-09-19 04:50:00 | AAPL | Stock | 224.51 | 224.76 | 224.5 | 224.5 | 6168.0 |
| 2024-09-19 04:55:00 | AAPL | Stock | 224.51 | 224.6 | 224.5 | 224.5 | 1130.0 |
| 2024-09-19 05:00:00 | AAPL | Stock | 224.34 | 224.34 | 223.87 | 224.11 | 10739.0 |
| 2024-09-19 05:05:00 | AAPL | Stock | 224.3 | 224.31 | 224.14 | 224.14 | 2244.0 |
| 2024-09-19 05:10:00 | AAPL | Stock | 224.19 | 224.38 | 224.15 | 224.38 | 4343.0 |
| 2024-09-19 05:15:00 | AAPL | Stock | 224.38 | 224.46 | 224.38 | 224.46 | 4482.0 |
| 2024-09-19 05:20:00 | AAPL | Stock | 224.45 | 224.49 | 224.37 | 224.37 | 2148.0 |
| 2024-09-19 05:25:00 | AAPL | Stock | 224.3 | 224.35 | 224.3 | 224.35 | 305.0 |
| 2024-09-19 05:30:00 | AAPL | Stock | 224.36 | 224.36 | 224.24 | 224.24 | 2049.0 |
| 2024-09-19 05:35:00 | AAPL | Stock | 224.32 | 224.36 | 224.3 | 224.36 | 962.0 |
| 2024-09-19 05:40:00 | AAPL | Stock | 224.42 | 224.42 | 224.42 | 224.42 | 100.0 |
| 2024-09-19 05:45:00 | AAPL | Stock | 224.34 | 224.34 | 224.34 | 224.34 | 200.0 |
| 2024-09-19 05:50:00 | AAPL | Stock | 224.38 | 224.38 | 224.38 | 224.38 | 163.0 |
| 2024-09-19 06:05:00 | AAPL | Stock | 224.23 | 224.23 | 224.13 | 224.13 | 2801.0 |
| 2024-09-19 06:10:00 | AAPL | Stock | 224.2 | 224.28 | 224.2 | 224.25 | 1443.0 |
| 2024-09-19 06:15:00 | AAPL | Stock | 224.31 | 224.31 | 224.31 | 224.31 | 338.0 |
| 2024-09-19 06:20:00 | AAPL | Stock | 224.25 | 224.31 | 224.25 | 224.31 | 723.0 |
| 2024-09-19 06:25:00 | AAPL | Stock | 224.32 | 224.38 | 224.14 | 224.38 | 4138.0 |
| 2024-09-19 06:30:00 | AAPL | Stock | 224.38 | 224.58 | 224.38 | 224.58 | 3649.0 |
| 2024-09-19 06:35:00 | AAPL | Stock | 224.57 | 224.61 | 224.56 | 224.61 | 3649.0 |
| 2024-09-19 06:40:00 | AAPL | Stock | 224.67 | 224.67 | 224.67 | 224.67 | 500.0 |
| 2024-09-19 06:45:00 | AAPL | Stock | 224.5 | 224.5 | 224.4 | 224.4 | 666.0 |
| 2024-09-19 06:50:00 | AAPL | Stock | 224.5 | 224.5 | 224.5 | 224.5 | 1244.0 |
| 2024-09-19 06:55:00 | AAPL | Stock | 224.5 | 224.85 | 224.5 | 224.84 | 5072.0 |
| 2024-09-19 07:00:00 | AAPL | Stock | 224.5 | 224.53 | 224.22 | 224.22 | 9399.0 |
| 2024-09-19 07:05:00 | AAPL | Stock | 224.15 | 224.3 | 224.01 | 224.3 | 3252.0 |
| 2024-09-19 07:10:00 | AAPL | Stock | 224.31 | 224.55 | 224.3 | 224.38 | 11163.0 |
| 2024-09-19 07:15:00 | AAPL | Stock | 224.31 | 224.44 | 224.29 | 224.4 | 3764.0 |
| 2024-09-19 07:20:00 | AAPL | Stock | 224.33 | 224.42 | 224.3 | 224.3 | 2729.0 |
| 2024-09-19 07:25:00 | AAPL | Stock | 224.3 | 224.32 | 224.25 | 224.25 | 1161.0 |
| 2024-09-19 07:30:00 | AAPL | Stock | 224.29 | 224.45 | 224.27 | 224.45 | 6357.0 |
| 2024-09-19 07:35:00 | AAPL | Stock | 224.48 | 224.65 | 224.45 | 224.65 | 5271.0 |
| 2024-09-19 07:40:00 | AAPL | Stock | 224.65 | 224.87 | 224.65 | 224.8 | 8344.0 |
| 2024-09-19 07:45:00 | AAPL | Stock | 224.7 | 224.88 | 224.7 | 224.88 | 3707.0 |
| 2024-09-19 07:50:00 | AAPL | Stock | 224.89 | 224.89 | 224.79 | 224.8 | 5576.0 |
| 2024-09-19 07:55:00 | AAPL | Stock | 224.79 | 224.79 | 224.68 | 224.7 | 2224.0 |
| 2024-09-19 08:00:00 | AAPL | Stock | 224.14 | 224.95 | 223.0 | 224.6983 | 103304.0 |
| 2024-09-19 08:05:00 | AAPL | Stock | 224.57 | 224.75 | 224.55 | 224.75 | 14178.0 |
| 2024-09-19 08:10:00 | AAPL | Stock | 224.7 | 224.9 | 224.5968 | 224.879 | 21009.0 |
| 2024-09-19 08:15:00 | AAPL | Stock | 224.85 | 224.99 | 224.85 | 224.99 | 31641.0 |
> showing 50 of 413,013 rows — these rows as CSV