PREVIEW / stock_5min / 2022-05-09
file: by_date/stock_5min/2022/2022-05-09.parquet size: 7.7 MB rows: 478,963 symbols: 2,523
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-09 04:00:00 | AAPL | Stock | 155.26 | 155.32 | 154.83 | 155.0 | 10549.0 |
| 2022-05-09 04:05:00 | AAPL | Stock | 154.91 | 155.07 | 154.82 | 155.0 | 3181.0 |
| 2022-05-09 04:10:00 | AAPL | Stock | 155.1 | 155.26 | 155.09 | 155.15 | 3522.0 |
| 2022-05-09 04:15:00 | AAPL | Stock | 155.02 | 155.02 | 155.0 | 155.0 | 848.0 |
| 2022-05-09 04:20:00 | AAPL | Stock | 154.9 | 155.0 | 154.67 | 154.75 | 4107.0 |
| 2022-05-09 04:25:00 | AAPL | Stock | 154.96 | 155.0 | 154.67 | 154.78 | 3875.0 |
| 2022-05-09 04:30:00 | AAPL | Stock | 154.72 | 154.72 | 154.2 | 154.2 | 6465.0 |
| 2022-05-09 04:35:00 | AAPL | Stock | 154.3 | 154.4 | 154.14 | 154.35 | 9615.0 |
| 2022-05-09 04:40:00 | AAPL | Stock | 154.46 | 154.46 | 154.34 | 154.37 | 4809.0 |
| 2022-05-09 04:45:00 | AAPL | Stock | 154.43 | 154.61 | 154.43 | 154.61 | 17190.0 |
| 2022-05-09 04:50:00 | AAPL | Stock | 154.67 | 154.68 | 154.56 | 154.68 | 3901.0 |
| 2022-05-09 04:55:00 | AAPL | Stock | 154.59 | 154.62 | 154.43 | 154.43 | 6848.0 |
| 2022-05-09 05:00:00 | AAPL | Stock | 154.45 | 154.45 | 154.45 | 154.45 | 100.0 |
| 2022-05-09 05:05:00 | AAPL | Stock | 154.45 | 154.5 | 154.39 | 154.39 | 4754.0 |
| 2022-05-09 05:10:00 | AAPL | Stock | 154.51 | 154.67 | 154.4 | 154.67 | 2975.0 |
| 2022-05-09 05:15:00 | AAPL | Stock | 154.6 | 154.6 | 154.59 | 154.59 | 300.0 |
| 2022-05-09 05:20:00 | AAPL | Stock | 154.63 | 154.86 | 154.63 | 154.68 | 3706.0 |
| 2022-05-09 05:25:00 | AAPL | Stock | 154.6 | 154.6 | 154.41 | 154.41 | 1888.0 |
| 2022-05-09 05:30:00 | AAPL | Stock | 154.48 | 154.53 | 154.4 | 154.4 | 3568.0 |
| 2022-05-09 05:35:00 | AAPL | Stock | 154.36 | 154.37 | 154.16 | 154.16 | 7605.0 |
| 2022-05-09 05:40:00 | AAPL | Stock | 154.19 | 154.37 | 154.15 | 154.37 | 11892.0 |
| 2022-05-09 05:45:00 | AAPL | Stock | 154.31 | 154.31 | 154.11 | 154.2 | 4668.0 |
| 2022-05-09 05:50:00 | AAPL | Stock | 154.28 | 154.31 | 154.25 | 154.25 | 2070.0 |
| 2022-05-09 05:55:00 | AAPL | Stock | 154.21 | 154.29 | 153.99 | 154.29 | 10994.0 |
| 2022-05-09 06:00:00 | AAPL | Stock | 154.28 | 154.3 | 154.18 | 154.23 | 1076.0 |
| 2022-05-09 06:05:00 | AAPL | Stock | 154.23 | 154.25 | 154.2 | 154.2 | 426.0 |
| 2022-05-09 06:10:00 | AAPL | Stock | 154.25 | 154.26 | 154.19 | 154.25 | 5148.0 |
| 2022-05-09 06:15:00 | AAPL | Stock | 154.19 | 154.29 | 154.19 | 154.29 | 499.0 |
| 2022-05-09 06:20:00 | AAPL | Stock | 154.24 | 154.33 | 154.24 | 154.25 | 1526.0 |
| 2022-05-09 06:25:00 | AAPL | Stock | 154.29 | 154.29 | 154.01 | 154.19 | 5051.0 |
| 2022-05-09 06:30:00 | AAPL | Stock | 154.1 | 154.1 | 153.82 | 153.82 | 6027.0 |
| 2022-05-09 06:35:00 | AAPL | Stock | 153.81 | 153.82 | 153.59 | 153.61 | 8571.0 |
| 2022-05-09 06:40:00 | AAPL | Stock | 153.62 | 153.7 | 153.3 | 153.35 | 10005.0 |
| 2022-05-09 06:45:00 | AAPL | Stock | 153.45 | 153.61 | 153.17 | 153.49 | 6611.0 |
| 2022-05-09 06:50:00 | AAPL | Stock | 153.31 | 153.5 | 153.16 | 153.46 | 4596.0 |
| 2022-05-09 06:55:00 | AAPL | Stock | 153.39 | 153.54 | 153.32 | 153.4 | 1568.0 |
| 2022-05-09 07:00:00 | AAPL | Stock | 153.46 | 154.0 | 153.45 | 153.65 | 37332.0 |
| 2022-05-09 07:05:00 | AAPL | Stock | 153.65 | 153.9 | 153.5 | 153.52 | 16417.0 |
| 2022-05-09 07:10:00 | AAPL | Stock | 153.5 | 153.65 | 153.3 | 153.46 | 34538.0 |
| 2022-05-09 07:15:00 | AAPL | Stock | 153.39 | 153.48 | 153.25 | 153.33 | 11379.0 |
| 2022-05-09 07:20:00 | AAPL | Stock | 153.25 | 153.25 | 152.92 | 153.0 | 62836.0 |
| 2022-05-09 07:25:00 | AAPL | Stock | 153.04 | 153.09 | 152.87 | 152.95 | 15286.0 |
| 2022-05-09 07:30:00 | AAPL | Stock | 152.95 | 153.22 | 152.78 | 153.22 | 39080.0 |
| 2022-05-09 07:35:00 | AAPL | Stock | 153.26 | 153.29 | 152.97 | 152.97 | 14981.0 |
| 2022-05-09 07:40:00 | AAPL | Stock | 153.01 | 153.31 | 152.95 | 153.24 | 28720.0 |
| 2022-05-09 07:45:00 | AAPL | Stock | 153.11 | 153.57 | 153.11 | 153.48 | 11571.0 |
| 2022-05-09 07:50:00 | AAPL | Stock | 153.42 | 153.78 | 153.42 | 153.63 | 20538.0 |
| 2022-05-09 07:55:00 | AAPL | Stock | 153.68 | 153.93 | 153.5 | 153.72 | 36764.0 |
| 2022-05-09 08:00:00 | AAPL | Stock | 153.6989 | 155.7 | 152.78 | 153.87 | 324451.0 |
| 2022-05-09 08:05:00 | AAPL | Stock | 153.79 | 154.21 | 153.75 | 153.9 | 89579.0 |
> showing 50 of 478,963 rows — these rows as CSV