PREVIEW / stock_5min / 2021-11-26
file: by_date/stock_5min/2021/2021-11-26.parquet size: 5.2 MB rows: 308,033 symbols: 2,605
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-26 04:00:00 | AAPL | Stock | 160.0 | 160.59 | 159.0 | 159.53 | 26666.0 |
| 2021-11-26 04:05:00 | AAPL | Stock | 159.44 | 159.53 | 158.88 | 159.0 | 19203.0 |
| 2021-11-26 04:10:00 | AAPL | Stock | 159.0 | 159.0 | 158.75 | 158.85 | 17405.0 |
| 2021-11-26 04:15:00 | AAPL | Stock | 158.86 | 158.97 | 157.96 | 157.98 | 25923.0 |
| 2021-11-26 04:20:00 | AAPL | Stock | 158.0 | 158.61 | 158.0 | 158.5 | 8554.0 |
| 2021-11-26 04:25:00 | AAPL | Stock | 158.48 | 158.54 | 158.13 | 158.15 | 6583.0 |
| 2021-11-26 04:30:00 | AAPL | Stock | 158.29 | 158.29 | 158.0 | 158.25 | 24391.0 |
| 2021-11-26 04:35:00 | AAPL | Stock | 158.25 | 158.25 | 157.85 | 158.24 | 24162.0 |
| 2021-11-26 04:40:00 | AAPL | Stock | 158.28 | 158.4 | 158.13 | 158.3 | 17617.0 |
| 2021-11-26 04:45:00 | AAPL | Stock | 158.4 | 158.41 | 158.08 | 158.09 | 11994.0 |
| 2021-11-26 04:50:00 | AAPL | Stock | 158.12 | 158.4 | 158.09 | 158.4 | 4246.0 |
| 2021-11-26 04:55:00 | AAPL | Stock | 158.2 | 158.35 | 158.2 | 158.28 | 601.0 |
| 2021-11-26 05:00:00 | AAPL | Stock | 158.16 | 158.57 | 158.16 | 158.57 | 2550.0 |
| 2021-11-26 05:05:00 | AAPL | Stock | 158.79 | 158.84 | 158.61 | 158.7 | 3260.0 |
| 2021-11-26 05:10:00 | AAPL | Stock | 158.79 | 158.79 | 158.72 | 158.74 | 3292.0 |
| 2021-11-26 05:15:00 | AAPL | Stock | 158.56 | 158.6 | 158.32 | 158.32 | 4608.0 |
| 2021-11-26 05:20:00 | AAPL | Stock | 158.25 | 158.57 | 158.25 | 158.57 | 3830.0 |
| 2021-11-26 05:25:00 | AAPL | Stock | 158.55 | 158.74 | 158.55 | 158.74 | 1426.0 |
| 2021-11-26 05:30:00 | AAPL | Stock | 158.76 | 158.77 | 158.64 | 158.7 | 2769.0 |
| 2021-11-26 05:35:00 | AAPL | Stock | 158.55 | 158.7 | 158.55 | 158.64 | 956.0 |
| 2021-11-26 05:40:00 | AAPL | Stock | 158.65 | 158.65 | 158.6 | 158.65 | 1518.0 |
| 2021-11-26 05:45:00 | AAPL | Stock | 158.6 | 158.61 | 158.5 | 158.5 | 2218.0 |
| 2021-11-26 05:50:00 | AAPL | Stock | 158.5 | 158.63 | 158.45 | 158.5 | 1735.0 |
| 2021-11-26 05:55:00 | AAPL | Stock | 158.5 | 158.65 | 158.44 | 158.49 | 15280.0 |
| 2021-11-26 06:00:00 | AAPL | Stock | 158.49 | 158.68 | 158.45 | 158.5 | 8540.0 |
| 2021-11-26 06:05:00 | AAPL | Stock | 158.64 | 159.0 | 158.5 | 159.0 | 2739.0 |
| 2021-11-26 06:10:00 | AAPL | Stock | 159.0 | 159.01 | 158.83 | 159.0 | 6866.0 |
| 2021-11-26 06:15:00 | AAPL | Stock | 159.19 | 159.2 | 158.61 | 159.01 | 8214.0 |
| 2021-11-26 06:20:00 | AAPL | Stock | 159.1 | 159.37 | 159.0 | 159.0 | 3766.0 |
| 2021-11-26 06:25:00 | AAPL | Stock | 159.15 | 159.19 | 159.0 | 159.0 | 6216.0 |
| 2021-11-26 06:30:00 | AAPL | Stock | 159.0 | 159.0 | 158.9 | 158.96 | 3493.0 |
| 2021-11-26 06:35:00 | AAPL | Stock | 158.61 | 158.61 | 158.32 | 158.5 | 5233.0 |
| 2021-11-26 06:40:00 | AAPL | Stock | 158.6 | 159.2 | 158.58 | 159.06 | 6055.0 |
| 2021-11-26 06:45:00 | AAPL | Stock | 159.05 | 159.05 | 158.83 | 158.83 | 2289.0 |
| 2021-11-26 06:50:00 | AAPL | Stock | 158.97 | 159.0 | 158.77 | 158.77 | 5864.0 |
| 2021-11-26 06:55:00 | AAPL | Stock | 158.9 | 158.99 | 158.9 | 158.99 | 1155.0 |
| 2021-11-26 07:00:00 | AAPL | Stock | 158.75 | 159.6 | 158.58 | 159.59 | 56776.0 |
| 2021-11-26 07:05:00 | AAPL | Stock | 159.56 | 159.62 | 159.34 | 159.35 | 43817.0 |
| 2021-11-26 07:10:00 | AAPL | Stock | 159.34 | 159.76 | 159.22 | 159.57 | 17878.0 |
| 2021-11-26 07:15:00 | AAPL | Stock | 159.52 | 159.75 | 159.49 | 159.67 | 7291.0 |
| 2021-11-26 07:20:00 | AAPL | Stock | 159.66 | 159.7 | 159.36 | 159.36 | 9974.0 |
| 2021-11-26 07:25:00 | AAPL | Stock | 159.38 | 159.5 | 159.0 | 159.19 | 26593.0 |
| 2021-11-26 07:30:00 | AAPL | Stock | 159.19 | 159.41 | 159.19 | 159.34 | 15328.0 |
| 2021-11-26 07:35:00 | AAPL | Stock | 159.34 | 159.52 | 159.31 | 159.46 | 19852.0 |
| 2021-11-26 07:40:00 | AAPL | Stock | 159.43 | 159.48 | 159.34 | 159.4 | 10576.0 |
| 2021-11-26 07:45:00 | AAPL | Stock | 159.41 | 159.72 | 159.41 | 159.72 | 21047.0 |
| 2021-11-26 07:50:00 | AAPL | Stock | 159.67 | 159.72 | 159.37 | 159.39 | 24853.0 |
| 2021-11-26 07:55:00 | AAPL | Stock | 159.41 | 159.5 | 159.3 | 159.36 | 13706.0 |
| 2021-11-26 08:00:00 | AAPL | Stock | 159.51 | 161.536 | 158.79 | 159.3 | 330551.0 |
| 2021-11-26 08:05:00 | AAPL | Stock | 159.31 | 159.44 | 159.26 | 159.33 | 34319.0 |
> showing 50 of 308,033 rows — these rows as CSV