PREVIEW / stock_5min / 2022-08-03
file: by_date/stock_5min/2022/2022-08-03.parquet size: 7.2 MB rows: 443,019 symbols: 2,335
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 |
|---|---|---|---|---|---|---|---|
| 2022-08-03 04:00:00 | AAPL | Stock | 160.28 | 160.28 | 160.02 | 160.14 | 4976.0 |
| 2022-08-03 04:05:00 | AAPL | Stock | 160.02 | 160.02 | 159.84 | 159.88 | 1770.0 |
| 2022-08-03 04:10:00 | AAPL | Stock | 159.89 | 160.0 | 159.89 | 160.0 | 3661.0 |
| 2022-08-03 04:15:00 | AAPL | Stock | 159.91 | 160.0 | 159.9 | 160.0 | 3279.0 |
| 2022-08-03 04:20:00 | AAPL | Stock | 160.05 | 160.22 | 160.05 | 160.22 | 2094.0 |
| 2022-08-03 04:25:00 | AAPL | Stock | 160.28 | 160.3 | 160.25 | 160.25 | 3288.0 |
| 2022-08-03 04:30:00 | AAPL | Stock | 160.25 | 160.34 | 160.25 | 160.34 | 2694.0 |
| 2022-08-03 04:35:00 | AAPL | Stock | 160.3 | 160.31 | 160.3 | 160.31 | 1557.0 |
| 2022-08-03 04:40:00 | AAPL | Stock | 160.3 | 160.3 | 160.3 | 160.3 | 260.0 |
| 2022-08-03 04:45:00 | AAPL | Stock | 160.33 | 160.33 | 160.33 | 160.33 | 262.0 |
| 2022-08-03 04:50:00 | AAPL | Stock | 160.31 | 160.32 | 160.31 | 160.32 | 691.0 |
| 2022-08-03 04:55:00 | AAPL | Stock | 160.36 | 160.43 | 160.32 | 160.32 | 1308.0 |
| 2022-08-03 05:00:00 | AAPL | Stock | 160.28 | 160.3 | 160.24 | 160.3 | 1690.0 |
| 2022-08-03 05:05:00 | AAPL | Stock | 160.39 | 160.39 | 160.39 | 160.39 | 245.0 |
| 2022-08-03 05:10:00 | AAPL | Stock | 160.4 | 160.46 | 160.4 | 160.46 | 1807.0 |
| 2022-08-03 05:15:00 | AAPL | Stock | 160.64 | 160.88 | 160.63 | 160.8 | 4511.0 |
| 2022-08-03 05:20:00 | AAPL | Stock | 160.8 | 160.88 | 160.8 | 160.8 | 3445.0 |
| 2022-08-03 05:25:00 | AAPL | Stock | 160.8 | 160.85 | 160.8 | 160.85 | 5427.0 |
| 2022-08-03 05:30:00 | AAPL | Stock | 160.86 | 160.97 | 160.86 | 160.97 | 974.0 |
| 2022-08-03 05:35:00 | AAPL | Stock | 160.99 | 161.14 | 160.91 | 160.98 | 3257.0 |
| 2022-08-03 05:40:00 | AAPL | Stock | 160.96 | 160.97 | 160.92 | 160.92 | 1599.0 |
| 2022-08-03 05:45:00 | AAPL | Stock | 160.85 | 160.85 | 160.83 | 160.83 | 1811.0 |
| 2022-08-03 05:55:00 | AAPL | Stock | 160.91 | 160.93 | 160.91 | 160.93 | 280.0 |
| 2022-08-03 06:00:00 | AAPL | Stock | 160.99 | 161.0 | 160.93 | 160.93 | 1122.0 |
| 2022-08-03 06:05:00 | AAPL | Stock | 160.89 | 160.89 | 160.89 | 160.89 | 945.0 |
| 2022-08-03 06:10:00 | AAPL | Stock | 160.89 | 160.9 | 160.89 | 160.9 | 205.0 |
| 2022-08-03 06:15:00 | AAPL | Stock | 160.86 | 160.86 | 160.8 | 160.8 | 4632.0 |
| 2022-08-03 06:30:00 | AAPL | Stock | 160.89 | 160.89 | 160.89 | 160.89 | 500.0 |
| 2022-08-03 06:35:00 | AAPL | Stock | 160.8 | 160.8 | 160.78 | 160.78 | 502.0 |
| 2022-08-03 06:40:00 | AAPL | Stock | 160.73 | 160.73 | 160.73 | 160.73 | 283.0 |
| 2022-08-03 06:50:00 | AAPL | Stock | 160.8 | 160.8 | 160.8 | 160.8 | 100.0 |
| 2022-08-03 06:55:00 | AAPL | Stock | 160.8 | 160.8 | 160.8 | 160.8 | 100.0 |
| 2022-08-03 07:00:00 | AAPL | Stock | 160.84 | 161.09 | 160.84 | 161.05 | 3599.0 |
| 2022-08-03 07:05:00 | AAPL | Stock | 161.04 | 161.25 | 161.04 | 161.18 | 8505.0 |
| 2022-08-03 07:10:00 | AAPL | Stock | 161.2 | 161.3 | 161.2 | 161.27 | 9294.0 |
| 2022-08-03 07:15:00 | AAPL | Stock | 161.29 | 161.31 | 161.2 | 161.2 | 5459.0 |
| 2022-08-03 07:20:00 | AAPL | Stock | 161.17 | 161.17 | 161.06 | 161.09 | 3372.0 |
| 2022-08-03 07:25:00 | AAPL | Stock | 161.15 | 161.23 | 161.15 | 161.23 | 749.0 |
| 2022-08-03 07:30:00 | AAPL | Stock | 161.23 | 161.23 | 161.05 | 161.05 | 5546.0 |
| 2022-08-03 07:35:00 | AAPL | Stock | 161.07 | 161.13 | 161.0 | 161.01 | 5185.0 |
| 2022-08-03 07:40:00 | AAPL | Stock | 160.98 | 161.11 | 160.98 | 161.11 | 3024.0 |
| 2022-08-03 07:45:00 | AAPL | Stock | 161.09 | 161.2 | 161.09 | 161.2 | 3424.0 |
| 2022-08-03 07:50:00 | AAPL | Stock | 161.29 | 161.29 | 161.25 | 161.28 | 2500.0 |
| 2022-08-03 07:55:00 | AAPL | Stock | 161.26 | 161.26 | 161.2 | 161.21 | 3919.0 |
| 2022-08-03 08:00:00 | AAPL | Stock | 160.9443 | 161.33 | 159.61 | 161.17 | 105804.0 |
| 2022-08-03 08:05:00 | AAPL | Stock | 161.15 | 161.18 | 161.0 | 161.0679 | 13327.0 |
| 2022-08-03 08:10:00 | AAPL | Stock | 161.09 | 161.3 | 161.09 | 161.3 | 21649.0 |
| 2022-08-03 08:15:00 | AAPL | Stock | 161.3 | 161.47 | 161.3 | 161.39 | 58935.0 |
| 2022-08-03 08:20:00 | AAPL | Stock | 161.44 | 161.53 | 161.25 | 161.2898 | 27773.0 |
| 2022-08-03 08:25:00 | AAPL | Stock | 161.2854 | 161.5 | 161.26 | 161.5 | 15407.0 |
> showing 50 of 443,019 rows — these rows as CSV