PREVIEW / stock_5min / 2023-10-23
file: by_date/stock_5min/2023/2023-10-23.parquet size: 6.5 MB rows: 395,980 symbols: 1,356
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-10-23 04:00:00 | AAPL | Stock | 172.6 | 172.6 | 171.68 | 171.7 | 3620.0 |
| 2023-10-23 04:05:00 | AAPL | Stock | 171.68 | 171.98 | 171.68 | 171.98 | 7638.0 |
| 2023-10-23 04:10:00 | AAPL | Stock | 171.96 | 172.06 | 171.95 | 172.05 | 6674.0 |
| 2023-10-23 04:15:00 | AAPL | Stock | 172.01 | 172.01 | 171.98 | 171.99 | 4491.0 |
| 2023-10-23 04:20:00 | AAPL | Stock | 171.97 | 172.0 | 171.94 | 171.97 | 6176.0 |
| 2023-10-23 04:25:00 | AAPL | Stock | 171.95 | 171.95 | 171.75 | 171.75 | 4528.0 |
| 2023-10-23 04:30:00 | AAPL | Stock | 171.76 | 171.76 | 171.7 | 171.7 | 4406.0 |
| 2023-10-23 04:35:00 | AAPL | Stock | 171.86 | 171.86 | 171.83 | 171.84 | 1372.0 |
| 2023-10-23 04:40:00 | AAPL | Stock | 171.84 | 171.86 | 171.84 | 171.86 | 1085.0 |
| 2023-10-23 04:45:00 | AAPL | Stock | 171.82 | 171.82 | 171.82 | 171.82 | 313.0 |
| 2023-10-23 04:50:00 | AAPL | Stock | 171.7 | 171.71 | 171.7 | 171.7 | 1689.0 |
| 2023-10-23 04:55:00 | AAPL | Stock | 171.7 | 171.7 | 171.7 | 171.7 | 249.0 |
| 2023-10-23 05:00:00 | AAPL | Stock | 171.67 | 171.67 | 171.11 | 171.12 | 6183.0 |
| 2023-10-23 05:05:00 | AAPL | Stock | 171.15 | 171.18 | 170.0 | 170.29 | 19419.0 |
| 2023-10-23 05:10:00 | AAPL | Stock | 170.5 | 170.55 | 170.2 | 170.46 | 9739.0 |
| 2023-10-23 05:15:00 | AAPL | Stock | 170.4 | 170.85 | 170.39 | 170.85 | 5365.0 |
| 2023-10-23 05:20:00 | AAPL | Stock | 170.89 | 170.89 | 170.7 | 170.71 | 3747.0 |
| 2023-10-23 05:25:00 | AAPL | Stock | 170.8 | 170.8 | 170.6 | 170.6 | 1670.0 |
| 2023-10-23 05:30:00 | AAPL | Stock | 170.61 | 170.61 | 170.35 | 170.39 | 5409.0 |
| 2023-10-23 05:35:00 | AAPL | Stock | 170.5 | 170.51 | 170.35 | 170.4 | 1891.0 |
| 2023-10-23 05:40:00 | AAPL | Stock | 170.36 | 170.51 | 170.3 | 170.39 | 6625.0 |
| 2023-10-23 05:45:00 | AAPL | Stock | 170.33 | 170.33 | 170.23 | 170.24 | 4972.0 |
| 2023-10-23 05:50:00 | AAPL | Stock | 170.3 | 170.37 | 170.29 | 170.33 | 2037.0 |
| 2023-10-23 05:55:00 | AAPL | Stock | 170.49 | 170.49 | 170.2 | 170.2 | 4894.0 |
| 2023-10-23 06:00:00 | AAPL | Stock | 170.22 | 170.36 | 170.2 | 170.36 | 1594.0 |
| 2023-10-23 06:05:00 | AAPL | Stock | 170.33 | 170.39 | 170.3 | 170.3 | 1511.0 |
| 2023-10-23 06:10:00 | AAPL | Stock | 170.42 | 170.42 | 170.27 | 170.27 | 7764.0 |
| 2023-10-23 06:15:00 | AAPL | Stock | 170.34 | 170.49 | 170.34 | 170.49 | 776.0 |
| 2023-10-23 06:20:00 | AAPL | Stock | 170.44 | 170.44 | 170.3 | 170.3 | 1776.0 |
| 2023-10-23 06:25:00 | AAPL | Stock | 170.36 | 170.49 | 170.36 | 170.36 | 1617.0 |
| 2023-10-23 06:30:00 | AAPL | Stock | 170.39 | 170.42 | 170.39 | 170.42 | 422.0 |
| 2023-10-23 06:35:00 | AAPL | Stock | 170.48 | 170.58 | 170.48 | 170.58 | 2964.0 |
| 2023-10-23 06:40:00 | AAPL | Stock | 170.65 | 170.65 | 170.65 | 170.65 | 330.0 |
| 2023-10-23 06:45:00 | AAPL | Stock | 170.57 | 170.7 | 170.57 | 170.64 | 3121.0 |
| 2023-10-23 06:50:00 | AAPL | Stock | 170.56 | 170.69 | 170.51 | 170.69 | 1288.0 |
| 2023-10-23 06:55:00 | AAPL | Stock | 170.65 | 170.66 | 170.65 | 170.66 | 476.0 |
| 2023-10-23 07:00:00 | AAPL | Stock | 170.6 | 171.17 | 170.6 | 170.7 | 12698.0 |
| 2023-10-23 07:05:00 | AAPL | Stock | 170.73 | 170.77 | 170.63 | 170.72 | 3461.0 |
| 2023-10-23 07:10:00 | AAPL | Stock | 170.64 | 170.76 | 170.64 | 170.76 | 2389.0 |
| 2023-10-23 07:15:00 | AAPL | Stock | 170.77 | 170.9 | 170.75 | 170.89 | 2264.0 |
| 2023-10-23 07:20:00 | AAPL | Stock | 170.87 | 170.87 | 170.8 | 170.8 | 816.0 |
| 2023-10-23 07:25:00 | AAPL | Stock | 170.78 | 170.92 | 170.78 | 170.92 | 3428.0 |
| 2023-10-23 07:30:00 | AAPL | Stock | 170.98 | 171.04 | 170.92 | 171.0 | 7530.0 |
| 2023-10-23 07:35:00 | AAPL | Stock | 171.0 | 171.22 | 171.0 | 171.22 | 4325.0 |
| 2023-10-23 07:40:00 | AAPL | Stock | 171.23 | 171.32 | 171.12 | 171.32 | 4756.0 |
| 2023-10-23 07:45:00 | AAPL | Stock | 171.15 | 171.31 | 171.11 | 171.21 | 4632.0 |
| 2023-10-23 07:50:00 | AAPL | Stock | 171.2 | 171.27 | 171.2 | 171.21 | 5594.0 |
| 2023-10-23 07:55:00 | AAPL | Stock | 171.2 | 171.2 | 170.7 | 170.81 | 30495.0 |
| 2023-10-23 08:00:00 | AAPL | Stock | 171.04 | 173.08 | 170.6 | 170.83 | 70635.0 |
| 2023-10-23 08:05:00 | AAPL | Stock | 170.8999 | 170.99 | 170.85 | 170.9 | 7861.0 |
> showing 50 of 395,980 rows — these rows as CSV