PREVIEW / stock_5min / 2022-05-16
file: by_date/stock_5min/2022/2022-05-16.parquet size: 7.1 MB rows: 445,478 symbols: 2,432
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-05-16 04:00:00 | AAPL | Stock | 146.68 | 146.68 | 145.86 | 146.05 | 8512.0 |
| 2022-05-16 04:05:00 | AAPL | Stock | 146.0 | 146.0 | 145.75 | 145.75 | 3174.0 |
| 2022-05-16 04:10:00 | AAPL | Stock | 145.7 | 145.85 | 145.66 | 145.85 | 2303.0 |
| 2022-05-16 04:15:00 | AAPL | Stock | 145.9 | 146.09 | 145.9 | 146.09 | 1627.0 |
| 2022-05-16 04:20:00 | AAPL | Stock | 146.04 | 146.04 | 146.04 | 146.04 | 175.0 |
| 2022-05-16 04:25:00 | AAPL | Stock | 146.15 | 146.15 | 146.05 | 146.05 | 1323.0 |
| 2022-05-16 04:30:00 | AAPL | Stock | 146.05 | 146.18 | 146.02 | 146.18 | 1551.0 |
| 2022-05-16 04:35:00 | AAPL | Stock | 146.2 | 146.2 | 146.2 | 146.2 | 100.0 |
| 2022-05-16 04:40:00 | AAPL | Stock | 146.08 | 146.08 | 146.04 | 146.04 | 611.0 |
| 2022-05-16 04:45:00 | AAPL | Stock | 146.05 | 146.05 | 146.05 | 146.05 | 504.0 |
| 2022-05-16 04:50:00 | AAPL | Stock | 146.11 | 146.45 | 146.11 | 146.45 | 1723.0 |
| 2022-05-16 04:55:00 | AAPL | Stock | 146.53 | 146.53 | 146.53 | 146.53 | 691.0 |
| 2022-05-16 05:00:00 | AAPL | Stock | 146.55 | 146.59 | 146.55 | 146.59 | 762.0 |
| 2022-05-16 05:05:00 | AAPL | Stock | 146.62 | 146.62 | 146.47 | 146.55 | 1994.0 |
| 2022-05-16 05:15:00 | AAPL | Stock | 146.67 | 146.67 | 146.56 | 146.56 | 424.0 |
| 2022-05-16 05:20:00 | AAPL | Stock | 146.57 | 146.57 | 146.36 | 146.36 | 309.0 |
| 2022-05-16 05:25:00 | AAPL | Stock | 146.34 | 146.35 | 146.3 | 146.3 | 4052.0 |
| 2022-05-16 05:30:00 | AAPL | Stock | 146.24 | 146.25 | 146.2 | 146.2 | 594.0 |
| 2022-05-16 05:35:00 | AAPL | Stock | 146.25 | 146.26 | 146.14 | 146.14 | 1477.0 |
| 2022-05-16 05:40:00 | AAPL | Stock | 146.11 | 146.11 | 146.11 | 146.11 | 148.0 |
| 2022-05-16 05:45:00 | AAPL | Stock | 146.1 | 146.19 | 146.1 | 146.19 | 328.0 |
| 2022-05-16 05:50:00 | AAPL | Stock | 146.19 | 146.23 | 145.8 | 145.8 | 7451.0 |
| 2022-05-16 05:55:00 | AAPL | Stock | 145.9 | 145.9 | 145.7 | 145.7 | 3258.0 |
| 2022-05-16 06:00:00 | AAPL | Stock | 145.82 | 145.99 | 145.82 | 145.84 | 2859.0 |
| 2022-05-16 06:05:00 | AAPL | Stock | 145.94 | 145.94 | 145.89 | 145.9 | 1131.0 |
| 2022-05-16 06:10:00 | AAPL | Stock | 145.88 | 145.95 | 145.86 | 145.95 | 1305.0 |
| 2022-05-16 06:15:00 | AAPL | Stock | 145.95 | 145.98 | 145.92 | 145.98 | 768.0 |
| 2022-05-16 06:20:00 | AAPL | Stock | 145.92 | 145.92 | 145.92 | 145.92 | 300.0 |
| 2022-05-16 06:25:00 | AAPL | Stock | 145.99 | 146.15 | 145.99 | 146.14 | 4600.0 |
| 2022-05-16 06:30:00 | AAPL | Stock | 145.93 | 145.93 | 145.81 | 145.81 | 964.0 |
| 2022-05-16 06:35:00 | AAPL | Stock | 145.93 | 146.05 | 145.93 | 146.03 | 1225.0 |
| 2022-05-16 06:40:00 | AAPL | Stock | 146.11 | 146.11 | 146.11 | 146.11 | 150.0 |
| 2022-05-16 06:50:00 | AAPL | Stock | 146.09 | 146.11 | 146.09 | 146.11 | 689.0 |
| 2022-05-16 06:55:00 | AAPL | Stock | 146.07 | 146.14 | 146.07 | 146.14 | 1194.0 |
| 2022-05-16 07:00:00 | AAPL | Stock | 146.19 | 146.22 | 146.09 | 146.1 | 3484.0 |
| 2022-05-16 07:05:00 | AAPL | Stock | 146.17 | 146.45 | 146.16 | 146.35 | 3936.0 |
| 2022-05-16 07:10:00 | AAPL | Stock | 146.35 | 146.4 | 146.28 | 146.3 | 2718.0 |
| 2022-05-16 07:15:00 | AAPL | Stock | 146.3 | 146.35 | 146.2 | 146.33 | 4152.0 |
| 2022-05-16 07:20:00 | AAPL | Stock | 146.34 | 146.35 | 146.25 | 146.35 | 30404.0 |
| 2022-05-16 07:25:00 | AAPL | Stock | 146.41 | 146.41 | 146.15 | 146.25 | 8954.0 |
| 2022-05-16 07:30:00 | AAPL | Stock | 146.25 | 146.26 | 146.08 | 146.08 | 2153.0 |
| 2022-05-16 07:35:00 | AAPL | Stock | 146.15 | 146.22 | 146.13 | 146.2 | 2188.0 |
| 2022-05-16 07:40:00 | AAPL | Stock | 146.23 | 146.35 | 146.2 | 146.35 | 1405.0 |
| 2022-05-16 07:45:00 | AAPL | Stock | 146.33 | 146.36 | 146.3 | 146.36 | 2674.0 |
| 2022-05-16 07:50:00 | AAPL | Stock | 146.33 | 146.5 | 146.25 | 146.5 | 9498.0 |
| 2022-05-16 07:55:00 | AAPL | Stock | 146.37 | 146.39 | 146.31 | 146.39 | 1693.0 |
| 2022-05-16 08:00:00 | AAPL | Stock | 146.18 | 146.5 | 145.99 | 146.2601 | 154797.0 |
| 2022-05-16 08:05:00 | AAPL | Stock | 146.29 | 146.3345 | 146.0508 | 146.23 | 33126.0 |
| 2022-05-16 08:10:00 | AAPL | Stock | 146.23 | 146.47 | 146.2283 | 146.47 | 26408.0 |
| 2022-05-16 08:15:00 | AAPL | Stock | 146.42 | 146.5 | 146.3833 | 146.5 | 4087.0 |
> showing 50 of 445,478 rows — these rows as CSV