PREVIEW / stock_5min / 2023-05-10
file: by_date/stock_5min/2023/2023-05-10.parquet size: 6.8 MB rows: 418,051 symbols: 1,658
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-10 04:00:00 | AAPL | Stock | 171.63 | 171.63 | 171.2 | 171.2 | 2551.0 |
| 2023-05-10 04:05:00 | AAPL | Stock | 171.13 | 171.13 | 170.85 | 170.9 | 6540.0 |
| 2023-05-10 04:10:00 | AAPL | Stock | 170.93 | 170.98 | 170.86 | 170.98 | 1320.0 |
| 2023-05-10 04:15:00 | AAPL | Stock | 170.99 | 171.15 | 170.99 | 171.11 | 2098.0 |
| 2023-05-10 04:20:00 | AAPL | Stock | 171.12 | 171.12 | 171.08 | 171.08 | 867.0 |
| 2023-05-10 04:25:00 | AAPL | Stock | 171.2 | 171.2 | 171.18 | 171.18 | 1400.0 |
| 2023-05-10 04:30:00 | AAPL | Stock | 171.2 | 171.22 | 171.2 | 171.22 | 1166.0 |
| 2023-05-10 04:35:00 | AAPL | Stock | 171.23 | 171.29 | 171.23 | 171.29 | 1143.0 |
| 2023-05-10 04:40:00 | AAPL | Stock | 171.24 | 171.24 | 171.24 | 171.24 | 100.0 |
| 2023-05-10 04:45:00 | AAPL | Stock | 171.15 | 171.15 | 171.15 | 171.15 | 648.0 |
| 2023-05-10 04:55:00 | AAPL | Stock | 171.25 | 171.25 | 171.25 | 171.25 | 149.0 |
| 2023-05-10 05:10:00 | AAPL | Stock | 171.21 | 171.21 | 171.18 | 171.18 | 200.0 |
| 2023-05-10 05:30:00 | AAPL | Stock | 171.18 | 171.37 | 171.18 | 171.37 | 2484.0 |
| 2023-05-10 05:35:00 | AAPL | Stock | 171.23 | 171.23 | 171.23 | 171.23 | 275.0 |
| 2023-05-10 06:00:00 | AAPL | Stock | 171.26 | 171.26 | 171.26 | 171.26 | 378.0 |
| 2023-05-10 06:45:00 | AAPL | Stock | 171.31 | 171.35 | 171.31 | 171.35 | 518.0 |
| 2023-05-10 06:55:00 | AAPL | Stock | 171.4 | 171.41 | 171.4 | 171.41 | 200.0 |
| 2023-05-10 07:00:00 | AAPL | Stock | 171.41 | 171.54 | 171.41 | 171.48 | 2918.0 |
| 2023-05-10 07:05:00 | AAPL | Stock | 171.52 | 171.52 | 171.52 | 171.52 | 1175.0 |
| 2023-05-10 07:10:00 | AAPL | Stock | 171.53 | 171.53 | 171.47 | 171.53 | 4474.0 |
| 2023-05-10 07:15:00 | AAPL | Stock | 171.57 | 171.62 | 171.57 | 171.62 | 1663.0 |
| 2023-05-10 07:20:00 | AAPL | Stock | 171.59 | 171.69 | 171.58 | 171.65 | 4531.0 |
| 2023-05-10 07:25:00 | AAPL | Stock | 171.75 | 171.75 | 171.72 | 171.72 | 705.0 |
| 2023-05-10 07:30:00 | AAPL | Stock | 171.7 | 171.7 | 171.65 | 171.65 | 2496.0 |
| 2023-05-10 07:35:00 | AAPL | Stock | 171.65 | 171.65 | 171.6 | 171.61 | 4060.0 |
| 2023-05-10 07:40:00 | AAPL | Stock | 171.6 | 171.64 | 171.58 | 171.64 | 725.0 |
| 2023-05-10 07:45:00 | AAPL | Stock | 171.75 | 171.76 | 171.72 | 171.76 | 840.0 |
| 2023-05-10 07:50:00 | AAPL | Stock | 171.77 | 171.79 | 171.72 | 171.73 | 4225.0 |
| 2023-05-10 07:55:00 | AAPL | Stock | 171.8 | 171.8 | 171.7 | 171.7 | 3337.0 |
| 2023-05-10 08:00:00 | AAPL | Stock | 171.5987 | 171.86 | 171.19 | 171.78 | 27459.0 |
| 2023-05-10 08:05:00 | AAPL | Stock | 171.77 | 171.77 | 171.6 | 171.6 | 6142.0 |
| 2023-05-10 08:10:00 | AAPL | Stock | 171.58 | 171.66 | 171.53 | 171.66 | 8346.0 |
| 2023-05-10 08:15:00 | AAPL | Stock | 171.66 | 171.66 | 171.58 | 171.58 | 2900.0 |
| 2023-05-10 08:20:00 | AAPL | Stock | 171.63 | 171.75 | 171.62 | 171.74 | 7222.0 |
| 2023-05-10 08:25:00 | AAPL | Stock | 171.76 | 171.7807 | 171.6 | 171.7807 | 8420.0 |
| 2023-05-10 08:30:00 | AAPL | Stock | 171.79 | 172.72 | 171.79 | 172.25 | 97879.0 |
| 2023-05-10 08:35:00 | AAPL | Stock | 172.25 | 172.53 | 172.16 | 172.29 | 68079.0 |
| 2023-05-10 08:40:00 | AAPL | Stock | 172.31 | 173.11 | 172.23 | 172.85 | 91515.0 |
| 2023-05-10 08:45:00 | AAPL | Stock | 172.82 | 172.95 | 172.6872 | 172.95 | 60480.0 |
| 2023-05-10 08:50:00 | AAPL | Stock | 172.96 | 172.96 | 172.73 | 172.77 | 26285.0 |
| 2023-05-10 08:55:00 | AAPL | Stock | 172.82 | 173.23 | 172.82 | 173.11 | 167384.0 |
| 2023-05-10 09:00:00 | AAPL | Stock | 173.12 | 173.25 | 173.04 | 173.21 | 41569.0 |
| 2023-05-10 09:05:00 | AAPL | Stock | 173.21 | 173.35 | 173.2 | 173.24 | 57634.0 |
| 2023-05-10 09:10:00 | AAPL | Stock | 173.23 | 173.44 | 173.12 | 173.42 | 48081.0 |
| 2023-05-10 09:15:00 | AAPL | Stock | 173.44 | 173.44 | 173.05 | 173.11 | 65738.0 |
| 2023-05-10 09:20:00 | AAPL | Stock | 173.11 | 173.17 | 172.9 | 172.95 | 51158.0 |
| 2023-05-10 09:25:00 | AAPL | Stock | 172.84 | 173.15 | 172.7 | 173.01 | 46729.0 |
| 2023-05-10 09:30:00 | AAPL | Stock | 173.01 | 174.03 | 172.83 | 173.8467 | 2283457.0 |
| 2023-05-10 09:35:00 | AAPL | Stock | 173.87 | 173.93 | 173.3448 | 173.41 | 1004362.0 |
| 2023-05-10 09:40:00 | AAPL | Stock | 173.41 | 173.44 | 172.6 | 173.0107 | 956467.0 |
> showing 50 of 418,051 rows — these rows as CSV