PREVIEW / stock_5min / 2023-11-17
file: by_date/stock_5min/2023/2023-11-17.parquet size: 6.5 MB rows: 396,815 symbols: 1,289
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-11-17 04:00:00 | AAPL | Stock | 189.8 | 190.21 | 189.8 | 190.1 | 3960.0 |
| 2023-11-17 04:05:00 | AAPL | Stock | 190.29 | 190.3 | 190.29 | 190.3 | 1991.0 |
| 2023-11-17 04:10:00 | AAPL | Stock | 190.28 | 190.28 | 190.28 | 190.28 | 105.0 |
| 2023-11-17 04:15:00 | AAPL | Stock | 190.28 | 190.28 | 190.19 | 190.2 | 1494.0 |
| 2023-11-17 04:20:00 | AAPL | Stock | 190.12 | 190.15 | 190.11 | 190.15 | 525.0 |
| 2023-11-17 04:25:00 | AAPL | Stock | 190.05 | 190.1 | 190.05 | 190.1 | 1000.0 |
| 2023-11-17 04:30:00 | AAPL | Stock | 190.1 | 190.16 | 190.1 | 190.11 | 2994.0 |
| 2023-11-17 04:35:00 | AAPL | Stock | 190.17 | 190.17 | 190.15 | 190.17 | 632.0 |
| 2023-11-17 04:40:00 | AAPL | Stock | 190.19 | 190.21 | 190.19 | 190.21 | 454.0 |
| 2023-11-17 04:45:00 | AAPL | Stock | 190.17 | 190.17 | 190.15 | 190.15 | 615.0 |
| 2023-11-17 04:50:00 | AAPL | Stock | 190.14 | 190.14 | 190.11 | 190.11 | 446.0 |
| 2023-11-17 04:55:00 | AAPL | Stock | 190.06 | 190.06 | 190.05 | 190.05 | 623.0 |
| 2023-11-17 05:05:00 | AAPL | Stock | 190.06 | 190.17 | 190.06 | 190.17 | 1173.0 |
| 2023-11-17 05:10:00 | AAPL | Stock | 190.19 | 190.19 | 190.15 | 190.15 | 240.0 |
| 2023-11-17 05:15:00 | AAPL | Stock | 190.13 | 190.13 | 190.13 | 190.13 | 566.0 |
| 2023-11-17 05:20:00 | AAPL | Stock | 190.16 | 190.16 | 190.16 | 190.16 | 477.0 |
| 2023-11-17 05:25:00 | AAPL | Stock | 190.13 | 190.21 | 190.11 | 190.21 | 747.0 |
| 2023-11-17 05:30:00 | AAPL | Stock | 190.22 | 190.3 | 190.22 | 190.3 | 4942.0 |
| 2023-11-17 05:35:00 | AAPL | Stock | 190.31 | 190.31 | 190.19 | 190.2 | 1506.0 |
| 2023-11-17 05:40:00 | AAPL | Stock | 190.25 | 190.25 | 190.25 | 190.25 | 428.0 |
| 2023-11-17 05:45:00 | AAPL | Stock | 190.25 | 190.25 | 190.2 | 190.2 | 1685.0 |
| 2023-11-17 05:55:00 | AAPL | Stock | 190.15 | 190.15 | 190.15 | 190.15 | 225.0 |
| 2023-11-17 06:00:00 | AAPL | Stock | 190.15 | 190.18 | 190.12 | 190.18 | 366.0 |
| 2023-11-17 06:10:00 | AAPL | Stock | 190.14 | 190.14 | 190.1 | 190.1 | 1225.0 |
| 2023-11-17 06:15:00 | AAPL | Stock | 190.1 | 190.11 | 190.08 | 190.08 | 2486.0 |
| 2023-11-17 06:20:00 | AAPL | Stock | 190.15 | 190.15 | 190.08 | 190.08 | 814.0 |
| 2023-11-17 06:25:00 | AAPL | Stock | 190.09 | 190.1 | 190.09 | 190.1 | 389.0 |
| 2023-11-17 06:30:00 | AAPL | Stock | 190.06 | 190.06 | 190.0 | 190.0 | 1843.0 |
| 2023-11-17 06:35:00 | AAPL | Stock | 189.92 | 189.92 | 189.92 | 189.92 | 401.0 |
| 2023-11-17 06:40:00 | AAPL | Stock | 189.92 | 189.92 | 189.82 | 189.82 | 756.0 |
| 2023-11-17 06:45:00 | AAPL | Stock | 189.88 | 189.88 | 189.88 | 189.88 | 147.0 |
| 2023-11-17 06:55:00 | AAPL | Stock | 189.98 | 190.0 | 189.98 | 190.0 | 465.0 |
| 2023-11-17 07:00:00 | AAPL | Stock | 190.08 | 190.14 | 190.06 | 190.14 | 4844.0 |
| 2023-11-17 07:05:00 | AAPL | Stock | 190.18 | 190.19 | 190.12 | 190.12 | 2646.0 |
| 2023-11-17 07:10:00 | AAPL | Stock | 190.02 | 190.13 | 190.02 | 190.1 | 2816.0 |
| 2023-11-17 07:15:00 | AAPL | Stock | 190.1 | 190.13 | 190.07 | 190.08 | 1852.0 |
| 2023-11-17 07:20:00 | AAPL | Stock | 190.01 | 190.05 | 190.0 | 190.0 | 4612.0 |
| 2023-11-17 07:25:00 | AAPL | Stock | 190.0 | 190.08 | 190.0 | 190.05 | 2386.0 |
| 2023-11-17 07:30:00 | AAPL | Stock | 190.08 | 190.09 | 190.08 | 190.09 | 812.0 |
| 2023-11-17 07:35:00 | AAPL | Stock | 190.09 | 190.18 | 190.09 | 190.18 | 1797.0 |
| 2023-11-17 07:40:00 | AAPL | Stock | 190.19 | 190.29 | 190.19 | 190.24 | 4578.0 |
| 2023-11-17 07:45:00 | AAPL | Stock | 190.23 | 190.23 | 190.2 | 190.2 | 1250.0 |
| 2023-11-17 07:50:00 | AAPL | Stock | 190.2 | 190.2 | 190.12 | 190.12 | 1678.0 |
| 2023-11-17 07:55:00 | AAPL | Stock | 190.09 | 190.12 | 190.09 | 190.1 | 354.0 |
| 2023-11-17 08:00:00 | AAPL | Stock | 190.15 | 190.2983 | 189.63 | 190.15 | 47815.0 |
| 2023-11-17 08:05:00 | AAPL | Stock | 190.18 | 190.2116 | 190.11 | 190.2 | 750.0 |
| 2023-11-17 08:10:00 | AAPL | Stock | 190.18 | 190.23 | 190.1623 | 190.23 | 2812.0 |
| 2023-11-17 08:15:00 | AAPL | Stock | 190.28 | 190.32 | 190.24 | 190.24 | 6734.0 |
| 2023-11-17 08:20:00 | AAPL | Stock | 190.26 | 190.39 | 190.2 | 190.38 | 3889.0 |
| 2023-11-17 08:25:00 | AAPL | Stock | 190.3401 | 190.3401 | 190.21 | 190.28 | 7237.0 |
> showing 50 of 396,815 rows — these rows as CSV