PREVIEW / stock_5min / 2023-02-24
file: by_date/stock_5min/2023/2023-02-24.parquet size: 6.7 MB rows: 408,117 symbols: 1,818
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-02-24 04:00:00 | AAPL | Stock | 148.19 | 148.74 | 148.19 | 148.68 | 1170.0 |
| 2023-02-24 04:05:00 | AAPL | Stock | 148.68 | 148.68 | 148.4 | 148.4 | 1778.0 |
| 2023-02-24 04:10:00 | AAPL | Stock | 148.5 | 148.5 | 148.5 | 148.5 | 200.0 |
| 2023-02-24 04:15:00 | AAPL | Stock | 148.6 | 148.6 | 148.6 | 148.6 | 117.0 |
| 2023-02-24 04:20:00 | AAPL | Stock | 148.59 | 148.59 | 148.59 | 148.59 | 390.0 |
| 2023-02-24 04:25:00 | AAPL | Stock | 148.5 | 148.5 | 148.5 | 148.5 | 100.0 |
| 2023-02-24 04:35:00 | AAPL | Stock | 148.47 | 148.47 | 148.47 | 148.47 | 123.0 |
| 2023-02-24 04:40:00 | AAPL | Stock | 148.49 | 148.49 | 148.49 | 148.49 | 111.0 |
| 2023-02-24 04:45:00 | AAPL | Stock | 148.44 | 148.47 | 148.31 | 148.31 | 2950.0 |
| 2023-02-24 04:55:00 | AAPL | Stock | 148.34 | 148.37 | 148.34 | 148.37 | 600.0 |
| 2023-02-24 05:00:00 | AAPL | Stock | 148.34 | 148.34 | 148.22 | 148.29 | 3210.0 |
| 2023-02-24 05:05:00 | AAPL | Stock | 148.3 | 148.3 | 148.3 | 148.3 | 1508.0 |
| 2023-02-24 05:10:00 | AAPL | Stock | 148.23 | 148.23 | 148.2 | 148.2 | 809.0 |
| 2023-02-24 05:20:00 | AAPL | Stock | 148.15 | 148.19 | 148.15 | 148.19 | 482.0 |
| 2023-02-24 05:25:00 | AAPL | Stock | 148.19 | 148.2 | 148.19 | 148.2 | 873.0 |
| 2023-02-24 05:35:00 | AAPL | Stock | 148.2 | 148.23 | 148.19 | 148.2 | 618.0 |
| 2023-02-24 05:45:00 | AAPL | Stock | 148.22 | 148.22 | 148.22 | 148.22 | 220.0 |
| 2023-02-24 05:55:00 | AAPL | Stock | 148.23 | 148.29 | 148.23 | 148.29 | 1218.0 |
| 2023-02-24 06:00:00 | AAPL | Stock | 148.16 | 148.2 | 148.11 | 148.2 | 2191.0 |
| 2023-02-24 06:05:00 | AAPL | Stock | 148.11 | 148.11 | 148.11 | 148.11 | 170.0 |
| 2023-02-24 06:10:00 | AAPL | Stock | 148.11 | 148.11 | 148.02 | 148.02 | 406.0 |
| 2023-02-24 06:15:00 | AAPL | Stock | 148.01 | 148.08 | 148.0 | 148.08 | 836.0 |
| 2023-02-24 06:20:00 | AAPL | Stock | 148.01 | 148.1 | 148.01 | 148.02 | 1140.0 |
| 2023-02-24 06:25:00 | AAPL | Stock | 148.1 | 148.1 | 148.06 | 148.06 | 2875.0 |
| 2023-02-24 06:30:00 | AAPL | Stock | 148.04 | 148.04 | 148.04 | 148.04 | 190.0 |
| 2023-02-24 06:40:00 | AAPL | Stock | 148.07 | 148.07 | 148.05 | 148.05 | 543.0 |
| 2023-02-24 06:45:00 | AAPL | Stock | 148.03 | 148.03 | 147.75 | 147.82 | 4234.0 |
| 2023-02-24 06:50:00 | AAPL | Stock | 147.95 | 147.95 | 147.95 | 147.95 | 100.0 |
| 2023-02-24 06:55:00 | AAPL | Stock | 147.98 | 147.99 | 147.98 | 147.99 | 1156.0 |
| 2023-02-24 07:00:00 | AAPL | Stock | 147.98 | 148.06 | 147.93 | 148.0 | 10305.0 |
| 2023-02-24 07:05:00 | AAPL | Stock | 147.99 | 148.02 | 147.99 | 148.02 | 1399.0 |
| 2023-02-24 07:10:00 | AAPL | Stock | 148.05 | 148.05 | 148.02 | 148.05 | 2292.0 |
| 2023-02-24 07:15:00 | AAPL | Stock | 148.07 | 148.11 | 148.05 | 148.08 | 6009.0 |
| 2023-02-24 07:20:00 | AAPL | Stock | 148.1 | 148.1 | 148.0 | 148.0 | 1300.0 |
| 2023-02-24 07:25:00 | AAPL | Stock | 148.05 | 148.05 | 148.05 | 148.05 | 100.0 |
| 2023-02-24 07:30:00 | AAPL | Stock | 148.04 | 148.04 | 148.04 | 148.04 | 200.0 |
| 2023-02-24 07:35:00 | AAPL | Stock | 148.0 | 148.0 | 147.94 | 148.0 | 2440.0 |
| 2023-02-24 07:40:00 | AAPL | Stock | 147.94 | 148.07 | 147.94 | 148.07 | 4420.0 |
| 2023-02-24 07:45:00 | AAPL | Stock | 148.05 | 148.05 | 147.95 | 147.95 | 4798.0 |
| 2023-02-24 07:50:00 | AAPL | Stock | 147.98 | 147.98 | 147.98 | 147.98 | 420.0 |
| 2023-02-24 07:55:00 | AAPL | Stock | 147.97 | 148.0 | 147.97 | 148.0 | 2183.0 |
| 2023-02-24 08:00:00 | AAPL | Stock | 148.003 | 149.39 | 147.9 | 147.94 | 25531.0 |
| 2023-02-24 08:05:00 | AAPL | Stock | 147.97 | 147.99 | 147.93 | 147.99 | 6159.0 |
| 2023-02-24 08:10:00 | AAPL | Stock | 147.99 | 148.0399 | 147.95 | 147.95 | 7056.0 |
| 2023-02-24 08:15:00 | AAPL | Stock | 147.96 | 148.01 | 147.95 | 148.01 | 8696.0 |
| 2023-02-24 08:20:00 | AAPL | Stock | 148.01 | 148.04 | 148.01 | 148.04 | 2185.0 |
| 2023-02-24 08:25:00 | AAPL | Stock | 148.05 | 148.21 | 148.05 | 148.14 | 9019.0 |
| 2023-02-24 08:30:00 | AAPL | Stock | 148.05 | 148.05 | 147.24 | 147.3025 | 60161.0 |
| 2023-02-24 08:35:00 | AAPL | Stock | 147.35 | 147.35 | 147.0 | 147.04 | 46348.0 |
| 2023-02-24 08:40:00 | AAPL | Stock | 147.03 | 147.1719 | 146.75 | 146.76 | 33685.0 |
> showing 50 of 408,117 rows — these rows as CSV