PREVIEW / stock_5min / 2021-09-21
file: by_date/stock_5min/2021/2021-09-21.parquet size: 7.3 MB rows: 448,152 symbols: 2,669
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-09-21 04:00:00 | AAPL | Stock | 144.72 | 144.72 | 144.11 | 144.61 | 20577.0 |
| 2021-09-21 04:05:00 | AAPL | Stock | 144.62 | 144.8 | 144.5 | 144.65 | 21609.0 |
| 2021-09-21 04:10:00 | AAPL | Stock | 144.47 | 144.49 | 144.43 | 144.49 | 920.0 |
| 2021-09-21 04:15:00 | AAPL | Stock | 144.5 | 144.6 | 144.5 | 144.6 | 14360.0 |
| 2021-09-21 04:20:00 | AAPL | Stock | 144.51 | 144.57 | 144.44 | 144.47 | 2343.0 |
| 2021-09-21 04:25:00 | AAPL | Stock | 144.43 | 144.46 | 144.42 | 144.46 | 842.0 |
| 2021-09-21 04:30:00 | AAPL | Stock | 144.5 | 144.59 | 144.5 | 144.58 | 889.0 |
| 2021-09-21 04:35:00 | AAPL | Stock | 144.57 | 144.76 | 144.57 | 144.75 | 1422.0 |
| 2021-09-21 04:40:00 | AAPL | Stock | 144.72 | 144.79 | 144.72 | 144.79 | 1140.0 |
| 2021-09-21 04:45:00 | AAPL | Stock | 144.77 | 144.8 | 144.77 | 144.8 | 1744.0 |
| 2021-09-21 04:50:00 | AAPL | Stock | 144.8 | 144.8 | 144.67 | 144.67 | 3047.0 |
| 2021-09-21 04:55:00 | AAPL | Stock | 144.67 | 144.67 | 144.45 | 144.55 | 2943.0 |
| 2021-09-21 05:00:00 | AAPL | Stock | 144.5 | 144.56 | 144.5 | 144.56 | 557.0 |
| 2021-09-21 05:05:00 | AAPL | Stock | 144.6 | 144.6 | 144.5 | 144.5 | 1963.0 |
| 2021-09-21 05:10:00 | AAPL | Stock | 144.5 | 144.54 | 144.4 | 144.4 | 2009.0 |
| 2021-09-21 05:15:00 | AAPL | Stock | 144.4 | 144.4 | 144.15 | 144.15 | 5047.0 |
| 2021-09-21 05:20:00 | AAPL | Stock | 144.25 | 144.39 | 144.2 | 144.39 | 1459.0 |
| 2021-09-21 05:25:00 | AAPL | Stock | 144.42 | 144.45 | 144.35 | 144.45 | 1454.0 |
| 2021-09-21 05:30:00 | AAPL | Stock | 144.45 | 144.45 | 144.41 | 144.44 | 5339.0 |
| 2021-09-21 05:35:00 | AAPL | Stock | 144.41 | 144.5 | 144.39 | 144.5 | 4721.0 |
| 2021-09-21 05:40:00 | AAPL | Stock | 144.57 | 144.57 | 144.55 | 144.57 | 978.0 |
| 2021-09-21 05:45:00 | AAPL | Stock | 144.55 | 144.55 | 144.51 | 144.55 | 3121.0 |
| 2021-09-21 05:50:00 | AAPL | Stock | 144.66 | 144.69 | 144.65 | 144.69 | 2114.0 |
| 2021-09-21 05:55:00 | AAPL | Stock | 144.55 | 144.55 | 144.5 | 144.53 | 4027.0 |
| 2021-09-21 06:00:00 | AAPL | Stock | 144.59 | 144.6 | 144.55 | 144.55 | 1643.0 |
| 2021-09-21 06:05:00 | AAPL | Stock | 144.58 | 144.6 | 144.55 | 144.55 | 3016.0 |
| 2021-09-21 06:10:00 | AAPL | Stock | 144.55 | 144.59 | 144.45 | 144.45 | 7200.0 |
| 2021-09-21 06:15:00 | AAPL | Stock | 144.48 | 144.52 | 144.48 | 144.52 | 1242.0 |
| 2021-09-21 06:20:00 | AAPL | Stock | 144.47 | 144.52 | 144.47 | 144.52 | 401.0 |
| 2021-09-21 06:25:00 | AAPL | Stock | 144.46 | 144.59 | 144.4 | 144.59 | 1219.0 |
| 2021-09-21 06:30:00 | AAPL | Stock | 144.47 | 144.47 | 144.4 | 144.45 | 7008.0 |
| 2021-09-21 06:40:00 | AAPL | Stock | 144.54 | 144.54 | 144.4 | 144.41 | 902.0 |
| 2021-09-21 06:45:00 | AAPL | Stock | 144.4 | 144.4 | 144.4 | 144.4 | 853.0 |
| 2021-09-21 06:50:00 | AAPL | Stock | 144.45 | 144.45 | 144.45 | 144.45 | 993.0 |
| 2021-09-21 06:55:00 | AAPL | Stock | 144.48 | 144.5 | 144.48 | 144.5 | 1157.0 |
| 2021-09-21 07:00:00 | AAPL | Stock | 144.45 | 144.53 | 144.15 | 144.18 | 106077.0 |
| 2021-09-21 07:05:00 | AAPL | Stock | 144.18 | 144.23 | 144.11 | 144.13 | 6421.0 |
| 2021-09-21 07:10:00 | AAPL | Stock | 144.14 | 144.18 | 144.05 | 144.05 | 3805.0 |
| 2021-09-21 07:15:00 | AAPL | Stock | 144.07 | 144.16 | 144.07 | 144.12 | 2913.0 |
| 2021-09-21 07:20:00 | AAPL | Stock | 144.11 | 144.25 | 144.1 | 144.21 | 12884.0 |
| 2021-09-21 07:25:00 | AAPL | Stock | 144.22 | 144.24 | 144.17 | 144.2 | 17803.0 |
| 2021-09-21 07:30:00 | AAPL | Stock | 144.2 | 144.29 | 144.19 | 144.2 | 12687.0 |
| 2021-09-21 07:35:00 | AAPL | Stock | 144.19 | 144.35 | 144.04 | 144.09 | 45732.0 |
| 2021-09-21 07:40:00 | AAPL | Stock | 144.12 | 144.22 | 144.12 | 144.17 | 6033.0 |
| 2021-09-21 07:45:00 | AAPL | Stock | 144.16 | 144.3 | 144.12 | 144.23 | 23775.0 |
| 2021-09-21 07:50:00 | AAPL | Stock | 144.2 | 144.21 | 144.17 | 144.2 | 3499.0 |
| 2021-09-21 07:55:00 | AAPL | Stock | 144.23 | 144.31 | 144.23 | 144.31 | 12887.0 |
| 2021-09-21 08:00:00 | AAPL | Stock | 144.1999 | 144.5 | 143.297 | 144.22 | 129672.0 |
| 2021-09-21 08:05:00 | AAPL | Stock | 144.25 | 144.47 | 144.25 | 144.4 | 48666.0 |
| 2021-09-21 08:10:00 | AAPL | Stock | 144.35 | 144.4099 | 144.0 | 144.0 | 51485.0 |
> showing 50 of 448,152 rows — these rows as CSV