PREVIEW / stock_5min / 2023-05-08
file: by_date/stock_5min/2023/2023-05-08.parquet size: 6.7 MB rows: 410,825 symbols: 1,647
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-05-08 04:00:00 | AAPL | Stock | 173.1 | 173.57 | 173.1 | 173.55 | 8532.0 |
| 2023-05-08 04:05:00 | AAPL | Stock | 173.51 | 173.51 | 173.3 | 173.3 | 3351.0 |
| 2023-05-08 04:10:00 | AAPL | Stock | 173.25 | 173.29 | 173.25 | 173.29 | 675.0 |
| 2023-05-08 04:15:00 | AAPL | Stock | 173.35 | 173.35 | 173.32 | 173.32 | 400.0 |
| 2023-05-08 04:20:00 | AAPL | Stock | 173.35 | 173.35 | 173.28 | 173.3 | 1568.0 |
| 2023-05-08 04:25:00 | AAPL | Stock | 173.32 | 173.35 | 173.32 | 173.35 | 283.0 |
| 2023-05-08 04:30:00 | AAPL | Stock | 173.35 | 173.35 | 173.35 | 173.35 | 116.0 |
| 2023-05-08 04:35:00 | AAPL | Stock | 173.32 | 173.32 | 173.32 | 173.32 | 100.0 |
| 2023-05-08 04:40:00 | AAPL | Stock | 173.32 | 173.34 | 173.32 | 173.34 | 577.0 |
| 2023-05-08 04:50:00 | AAPL | Stock | 173.4 | 173.42 | 173.38 | 173.38 | 1442.0 |
| 2023-05-08 04:55:00 | AAPL | Stock | 173.36 | 173.42 | 173.33 | 173.42 | 2067.0 |
| 2023-05-08 05:00:00 | AAPL | Stock | 173.41 | 173.43 | 173.41 | 173.41 | 720.0 |
| 2023-05-08 05:05:00 | AAPL | Stock | 173.4 | 173.4 | 173.38 | 173.38 | 302.0 |
| 2023-05-08 05:10:00 | AAPL | Stock | 173.39 | 173.39 | 173.39 | 173.39 | 373.0 |
| 2023-05-08 05:15:00 | AAPL | Stock | 173.39 | 173.39 | 173.39 | 173.39 | 394.0 |
| 2023-05-08 05:20:00 | AAPL | Stock | 173.33 | 173.33 | 173.3 | 173.32 | 847.0 |
| 2023-05-08 05:25:00 | AAPL | Stock | 173.35 | 173.35 | 173.3 | 173.3 | 442.0 |
| 2023-05-08 05:30:00 | AAPL | Stock | 173.33 | 173.33 | 173.33 | 173.33 | 100.0 |
| 2023-05-08 05:35:00 | AAPL | Stock | 173.37 | 173.37 | 173.37 | 173.37 | 115.0 |
| 2023-05-08 05:40:00 | AAPL | Stock | 173.31 | 173.31 | 173.31 | 173.31 | 585.0 |
| 2023-05-08 05:50:00 | AAPL | Stock | 173.39 | 173.39 | 173.36 | 173.36 | 385.0 |
| 2023-05-08 05:55:00 | AAPL | Stock | 173.39 | 173.48 | 173.39 | 173.47 | 3024.0 |
| 2023-05-08 06:00:00 | AAPL | Stock | 173.47 | 173.47 | 173.45 | 173.45 | 317.0 |
| 2023-05-08 06:05:00 | AAPL | Stock | 173.38 | 173.38 | 173.38 | 173.38 | 165.0 |
| 2023-05-08 06:25:00 | AAPL | Stock | 173.45 | 173.45 | 173.41 | 173.41 | 578.0 |
| 2023-05-08 06:30:00 | AAPL | Stock | 173.48 | 173.53 | 173.47 | 173.51 | 4633.0 |
| 2023-05-08 06:35:00 | AAPL | Stock | 173.52 | 173.54 | 173.47 | 173.47 | 10171.0 |
| 2023-05-08 06:40:00 | AAPL | Stock | 173.45 | 173.45 | 173.45 | 173.45 | 100.0 |
| 2023-05-08 06:45:00 | AAPL | Stock | 173.4 | 173.41 | 173.1 | 173.1 | 3708.0 |
| 2023-05-08 06:55:00 | AAPL | Stock | 173.2 | 173.23 | 173.2 | 173.23 | 1005.0 |
| 2023-05-08 07:00:00 | AAPL | Stock | 173.2 | 173.3 | 173.13 | 173.25 | 4017.0 |
| 2023-05-08 07:05:00 | AAPL | Stock | 173.29 | 173.36 | 173.29 | 173.36 | 2677.0 |
| 2023-05-08 07:10:00 | AAPL | Stock | 173.35 | 173.45 | 173.33 | 173.35 | 11048.0 |
| 2023-05-08 07:15:00 | AAPL | Stock | 173.31 | 173.32 | 173.25 | 173.26 | 2867.0 |
| 2023-05-08 07:20:00 | AAPL | Stock | 173.27 | 173.27 | 173.19 | 173.2 | 4246.0 |
| 2023-05-08 07:25:00 | AAPL | Stock | 173.21 | 173.29 | 173.19 | 173.25 | 4144.0 |
| 2023-05-08 07:30:00 | AAPL | Stock | 173.24 | 173.24 | 173.18 | 173.21 | 4408.0 |
| 2023-05-08 07:35:00 | AAPL | Stock | 173.17 | 173.2 | 173.1 | 173.14 | 6577.0 |
| 2023-05-08 07:40:00 | AAPL | Stock | 173.15 | 173.23 | 173.13 | 173.23 | 1843.0 |
| 2023-05-08 07:45:00 | AAPL | Stock | 173.34 | 173.34 | 173.24 | 173.25 | 3825.0 |
| 2023-05-08 07:50:00 | AAPL | Stock | 173.24 | 173.24 | 173.16 | 173.17 | 5183.0 |
| 2023-05-08 07:55:00 | AAPL | Stock | 173.17 | 173.2 | 173.14 | 173.16 | 7033.0 |
| 2023-05-08 08:00:00 | AAPL | Stock | 173.27 | 173.46 | 172.88 | 173.1782 | 85011.0 |
| 2023-05-08 08:05:00 | AAPL | Stock | 173.18 | 173.26 | 173.15 | 173.25 | 7116.0 |
| 2023-05-08 08:10:00 | AAPL | Stock | 173.27 | 173.27 | 173.12 | 173.19 | 4735.0 |
| 2023-05-08 08:15:00 | AAPL | Stock | 173.15 | 173.15 | 173.05 | 173.0603 | 10020.0 |
| 2023-05-08 08:20:00 | AAPL | Stock | 173.1 | 173.15 | 173.0601 | 173.12 | 6841.0 |
| 2023-05-08 08:25:00 | AAPL | Stock | 173.12 | 173.1239 | 173.05 | 173.12 | 4083.0 |
| 2023-05-08 08:30:00 | AAPL | Stock | 173.14 | 173.22 | 172.98 | 172.98 | 25997.0 |
| 2023-05-08 08:35:00 | AAPL | Stock | 172.99 | 173.02 | 172.88 | 172.95 | 18619.0 |
> showing 50 of 410,825 rows — these rows as CSV