PREVIEW / stock_5min / 2023-11-10
file: by_date/stock_5min/2023/2023-11-10.parquet size: 6.4 MB rows: 388,169 symbols: 1,299
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-10 04:00:00 | AAPL | Stock | 182.08 | 182.3 | 182.08 | 182.2 | 1652.0 |
| 2023-11-10 04:05:00 | AAPL | Stock | 182.23 | 182.24 | 182.21 | 182.24 | 400.0 |
| 2023-11-10 04:10:00 | AAPL | Stock | 182.24 | 182.32 | 182.2 | 182.2 | 1847.0 |
| 2023-11-10 04:15:00 | AAPL | Stock | 181.99 | 181.99 | 181.91 | 181.91 | 696.0 |
| 2023-11-10 04:20:00 | AAPL | Stock | 182.0 | 182.0 | 181.9 | 181.9 | 7898.0 |
| 2023-11-10 04:25:00 | AAPL | Stock | 181.83 | 181.87 | 181.83 | 181.87 | 1344.0 |
| 2023-11-10 04:30:00 | AAPL | Stock | 181.86 | 181.86 | 181.78 | 181.81 | 3039.0 |
| 2023-11-10 04:35:00 | AAPL | Stock | 181.87 | 181.87 | 181.87 | 181.87 | 700.0 |
| 2023-11-10 04:40:00 | AAPL | Stock | 181.83 | 181.86 | 181.83 | 181.86 | 300.0 |
| 2023-11-10 04:45:00 | AAPL | Stock | 182.0 | 182.1 | 182.0 | 182.1 | 1180.0 |
| 2023-11-10 04:50:00 | AAPL | Stock | 182.17 | 182.29 | 182.17 | 182.29 | 550.0 |
| 2023-11-10 04:55:00 | AAPL | Stock | 182.26 | 182.32 | 182.26 | 182.32 | 1200.0 |
| 2023-11-10 05:00:00 | AAPL | Stock | 182.17 | 182.17 | 182.17 | 182.17 | 500.0 |
| 2023-11-10 05:05:00 | AAPL | Stock | 182.1 | 182.1 | 182.1 | 182.1 | 100.0 |
| 2023-11-10 05:10:00 | AAPL | Stock | 182.12 | 182.12 | 182.12 | 182.12 | 125.0 |
| 2023-11-10 05:20:00 | AAPL | Stock | 182.04 | 182.04 | 182.0 | 182.0 | 1143.0 |
| 2023-11-10 05:30:00 | AAPL | Stock | 181.94 | 181.94 | 181.92 | 181.92 | 230.0 |
| 2023-11-10 05:35:00 | AAPL | Stock | 181.96 | 181.96 | 181.92 | 181.92 | 270.0 |
| 2023-11-10 05:40:00 | AAPL | Stock | 181.96 | 182.01 | 181.96 | 182.01 | 325.0 |
| 2023-11-10 05:45:00 | AAPL | Stock | 182.0 | 182.08 | 182.0 | 182.08 | 5047.0 |
| 2023-11-10 05:55:00 | AAPL | Stock | 182.16 | 182.16 | 182.16 | 182.16 | 500.0 |
| 2023-11-10 06:00:00 | AAPL | Stock | 182.1 | 182.1 | 182.1 | 182.1 | 500.0 |
| 2023-11-10 06:05:00 | AAPL | Stock | 182.17 | 182.17 | 182.17 | 182.17 | 404.0 |
| 2023-11-10 06:10:00 | AAPL | Stock | 182.1 | 182.1 | 182.08 | 182.08 | 3192.0 |
| 2023-11-10 06:15:00 | AAPL | Stock | 182.1 | 182.13 | 182.1 | 182.13 | 267.0 |
| 2023-11-10 06:20:00 | AAPL | Stock | 182.03 | 182.13 | 182.01 | 182.13 | 1300.0 |
| 2023-11-10 06:30:00 | AAPL | Stock | 182.02 | 182.02 | 181.96 | 181.96 | 822.0 |
| 2023-11-10 06:35:00 | AAPL | Stock | 181.9 | 181.9 | 181.89 | 181.9 | 696.0 |
| 2023-11-10 06:40:00 | AAPL | Stock | 181.89 | 181.91 | 181.89 | 181.91 | 300.0 |
| 2023-11-10 06:45:00 | AAPL | Stock | 181.92 | 181.93 | 181.92 | 181.93 | 300.0 |
| 2023-11-10 06:50:00 | AAPL | Stock | 181.95 | 181.95 | 181.95 | 181.95 | 200.0 |
| 2023-11-10 06:55:00 | AAPL | Stock | 181.94 | 182.04 | 181.94 | 182.04 | 400.0 |
| 2023-11-10 07:00:00 | AAPL | Stock | 182.05 | 182.15 | 182.04 | 182.15 | 1443.0 |
| 2023-11-10 07:05:00 | AAPL | Stock | 182.16 | 182.19 | 182.16 | 182.19 | 261.0 |
| 2023-11-10 07:10:00 | AAPL | Stock | 182.19 | 182.21 | 182.19 | 182.2 | 2296.0 |
| 2023-11-10 07:15:00 | AAPL | Stock | 182.15 | 182.34 | 182.15 | 182.34 | 1175.0 |
| 2023-11-10 07:20:00 | AAPL | Stock | 182.31 | 182.33 | 182.28 | 182.28 | 2115.0 |
| 2023-11-10 07:25:00 | AAPL | Stock | 182.32 | 182.49 | 182.32 | 182.49 | 758.0 |
| 2023-11-10 07:30:00 | AAPL | Stock | 182.48 | 182.55 | 182.45 | 182.55 | 1761.0 |
| 2023-11-10 07:35:00 | AAPL | Stock | 182.58 | 182.7 | 182.58 | 182.7 | 4368.0 |
| 2023-11-10 07:40:00 | AAPL | Stock | 182.72 | 182.8 | 182.72 | 182.8 | 8537.0 |
| 2023-11-10 07:45:00 | AAPL | Stock | 182.8 | 182.87 | 182.75 | 182.75 | 4481.0 |
| 2023-11-10 07:50:00 | AAPL | Stock | 182.74 | 182.75 | 182.74 | 182.75 | 1361.0 |
| 2023-11-10 07:55:00 | AAPL | Stock | 182.74 | 183.0 | 182.71 | 182.99 | 5544.0 |
| 2023-11-10 08:00:00 | AAPL | Stock | 182.07 | 182.9 | 181.71 | 182.78 | 25511.0 |
| 2023-11-10 08:05:00 | AAPL | Stock | 182.86 | 182.98 | 182.86 | 182.95 | 3365.0 |
| 2023-11-10 08:10:00 | AAPL | Stock | 182.95 | 182.98 | 182.9 | 182.98 | 513.0 |
| 2023-11-10 08:15:00 | AAPL | Stock | 183.0 | 183.07 | 182.97 | 183.0 | 6062.0 |
| 2023-11-10 08:20:00 | AAPL | Stock | 183.0 | 183.0 | 182.85 | 183.0 | 3953.0 |
| 2023-11-10 08:25:00 | AAPL | Stock | 182.9798 | 182.98 | 182.8624 | 182.95 | 3598.0 |
> showing 50 of 388,169 rows — these rows as CSV