PREVIEW / stock_5min / 2021-05-28
file: by_date/stock_5min/2021/2021-05-28.parquet size: 7.3 MB rows: 451,571 symbols: 2,967
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-05-28 04:00:00 | AAPL | Stock | 126.04 | 126.1 | 126.0 | 126.0 | 2705.0 |
| 2021-05-28 04:05:00 | AAPL | Stock | 126.08 | 126.15 | 126.08 | 126.15 | 545.0 |
| 2021-05-28 04:10:00 | AAPL | Stock | 126.15 | 126.18 | 126.14 | 126.15 | 1183.0 |
| 2021-05-28 04:20:00 | AAPL | Stock | 126.15 | 126.15 | 126.15 | 126.15 | 608.0 |
| 2021-05-28 04:25:00 | AAPL | Stock | 126.15 | 126.15 | 126.15 | 126.15 | 330.0 |
| 2021-05-28 04:30:00 | AAPL | Stock | 126.05 | 126.05 | 126.05 | 126.05 | 794.0 |
| 2021-05-28 04:40:00 | AAPL | Stock | 126.06 | 126.06 | 126.05 | 126.05 | 301.0 |
| 2021-05-28 04:50:00 | AAPL | Stock | 126.18 | 126.18 | 126.18 | 126.18 | 285.0 |
| 2021-05-28 04:55:00 | AAPL | Stock | 126.05 | 126.09 | 126.05 | 126.09 | 238.0 |
| 2021-05-28 05:05:00 | AAPL | Stock | 126.12 | 126.12 | 126.07 | 126.1 | 300.0 |
| 2021-05-28 05:10:00 | AAPL | Stock | 126.12 | 126.12 | 126.12 | 126.12 | 100.0 |
| 2021-05-28 05:20:00 | AAPL | Stock | 126.19 | 126.22 | 126.17 | 126.22 | 1106.0 |
| 2021-05-28 05:30:00 | AAPL | Stock | 126.23 | 126.23 | 126.2 | 126.2 | 2114.0 |
| 2021-05-28 05:35:00 | AAPL | Stock | 126.2 | 126.23 | 126.2 | 126.23 | 298.0 |
| 2021-05-28 05:40:00 | AAPL | Stock | 126.21 | 126.21 | 126.18 | 126.18 | 519.0 |
| 2021-05-28 05:45:00 | AAPL | Stock | 126.23 | 126.23 | 126.23 | 126.23 | 895.0 |
| 2021-05-28 05:50:00 | AAPL | Stock | 126.2 | 126.25 | 126.1 | 126.1 | 3053.0 |
| 2021-05-28 06:00:00 | AAPL | Stock | 126.17 | 126.18 | 126.17 | 126.18 | 734.0 |
| 2021-05-28 06:05:00 | AAPL | Stock | 126.11 | 126.12 | 126.11 | 126.12 | 300.0 |
| 2021-05-28 06:20:00 | AAPL | Stock | 126.1 | 126.1 | 126.1 | 126.1 | 121.0 |
| 2021-05-28 06:25:00 | AAPL | Stock | 126.05 | 126.05 | 126.05 | 126.05 | 412.0 |
| 2021-05-28 06:30:00 | AAPL | Stock | 126.09 | 126.18 | 126.05 | 126.18 | 2332.0 |
| 2021-05-28 06:35:00 | AAPL | Stock | 126.1 | 126.1 | 126.02 | 126.02 | 679.0 |
| 2021-05-28 06:40:00 | AAPL | Stock | 126.04 | 126.09 | 126.03 | 126.03 | 952.0 |
| 2021-05-28 06:45:00 | AAPL | Stock | 126.05 | 126.06 | 126.05 | 126.05 | 3259.0 |
| 2021-05-28 06:50:00 | AAPL | Stock | 126.1 | 126.26 | 126.1 | 126.24 | 5067.0 |
| 2021-05-28 06:55:00 | AAPL | Stock | 126.28 | 126.28 | 126.28 | 126.28 | 1350.0 |
| 2021-05-28 07:00:00 | AAPL | Stock | 126.17 | 126.28 | 126.14 | 126.14 | 4865.0 |
| 2021-05-28 07:05:00 | AAPL | Stock | 126.17 | 126.18 | 126.1 | 126.1 | 5053.0 |
| 2021-05-28 07:10:00 | AAPL | Stock | 126.07 | 126.1 | 125.7 | 125.93 | 47536.0 |
| 2021-05-28 07:15:00 | AAPL | Stock | 125.939 | 125.99 | 125.81 | 125.82 | 19578.0 |
| 2021-05-28 07:20:00 | AAPL | Stock | 125.82 | 126.09 | 125.8 | 125.96 | 20940.0 |
| 2021-05-28 07:25:00 | AAPL | Stock | 125.96 | 126.09 | 125.95 | 125.95 | 13860.0 |
| 2021-05-28 07:30:00 | AAPL | Stock | 125.94 | 125.96 | 125.81 | 125.88 | 13421.0 |
| 2021-05-28 07:35:00 | AAPL | Stock | 125.9 | 125.9 | 125.78 | 125.8 | 13252.0 |
| 2021-05-28 07:40:00 | AAPL | Stock | 125.81 | 125.82 | 125.73 | 125.82 | 27962.0 |
| 2021-05-28 07:45:00 | AAPL | Stock | 125.82 | 125.87 | 125.66 | 125.67 | 41774.0 |
| 2021-05-28 07:50:00 | AAPL | Stock | 125.67 | 125.7 | 125.65 | 125.66 | 6047.0 |
| 2021-05-28 07:55:00 | AAPL | Stock | 125.7 | 125.75 | 125.7 | 125.72 | 4389.0 |
| 2021-05-28 08:00:00 | AAPL | Stock | 126.0401 | 126.19 | 125.65 | 125.72 | 143505.0 |
| 2021-05-28 08:05:00 | AAPL | Stock | 125.71 | 125.71 | 125.37 | 125.45 | 75489.0 |
| 2021-05-28 08:10:00 | AAPL | Stock | 125.45 | 125.6 | 125.45 | 125.6 | 40436.0 |
| 2021-05-28 08:15:00 | AAPL | Stock | 125.6 | 125.68 | 125.55 | 125.5899 | 18293.0 |
| 2021-05-28 08:20:00 | AAPL | Stock | 125.5899 | 125.66 | 125.56 | 125.6 | 23744.0 |
| 2021-05-28 08:25:00 | AAPL | Stock | 125.59 | 125.62 | 125.52 | 125.58 | 16798.0 |
| 2021-05-28 08:30:00 | AAPL | Stock | 125.63 | 125.72 | 125.52 | 125.52 | 37183.0 |
| 2021-05-28 08:35:00 | AAPL | Stock | 125.52 | 125.59 | 125.36 | 125.5 | 93965.0 |
| 2021-05-28 08:40:00 | AAPL | Stock | 125.49 | 125.6 | 125.46 | 125.55 | 41991.0 |
| 2021-05-28 08:45:00 | AAPL | Stock | 125.55 | 125.56 | 125.41 | 125.48 | 40572.0 |
| 2021-05-28 08:50:00 | AAPL | Stock | 125.48 | 125.5 | 125.42 | 125.45 | 20063.0 |
> showing 50 of 451,571 rows — these rows as CSV