PREVIEW / stock_30min / 2020-10-29
file: by_date/stock_30min/2020/2020-10-29.parquet size: 1.9 MB rows: 98,305 symbols: 2,492
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-29 04:00:00 | AAPL | Stock | 112.79 | 113.14 | 112.5 | 112.95 | 45721.0 |
| 2020-10-29 04:30:00 | AAPL | Stock | 112.98 | 113.07 | 112.75 | 112.75 | 11277.0 |
| 2020-10-29 05:00:00 | AAPL | Stock | 112.82 | 113.69 | 112.82 | 113.53 | 21255.0 |
| 2020-10-29 05:30:00 | AAPL | Stock | 113.56 | 113.56 | 113.07 | 113.18 | 26537.0 |
| 2020-10-29 06:00:00 | AAPL | Stock | 113.18 | 113.24 | 112.75 | 112.92 | 29791.0 |
| 2020-10-29 06:30:00 | AAPL | Stock | 112.88 | 113.29 | 112.76 | 113.28 | 22387.0 |
| 2020-10-29 07:00:00 | AAPL | Stock | 113.18 | 113.24 | 112.39 | 112.39 | 215993.0 |
| 2020-10-29 07:30:00 | AAPL | Stock | 112.4 | 112.72 | 111.7 | 111.7 | 256773.0 |
| 2020-10-29 08:00:00 | AAPL | Stock | 112.94 | 113.1 | 111.7 | 112.04 | 556885.0 |
| 2020-10-29 08:30:00 | AAPL | Stock | 112.08 | 112.8 | 112.03 | 112.59 | 565001.0 |
| 2020-10-29 09:00:00 | AAPL | Stock | 112.58 | 112.77 | 112.3 | 112.37 | 426411.0 |
| 2020-10-29 09:30:00 | AAPL | Stock | 112.37 | 114.2 | 112.2 | 114.025 | 14907065.0 |
| 2020-10-29 10:00:00 | AAPL | Stock | 114.02 | 114.365 | 113.41 | 114.36 | 7859211.0 |
| 2020-10-29 10:30:00 | AAPL | Stock | 114.37 | 114.6 | 113.76 | 113.97 | 6593861.0 |
| 2020-10-29 11:00:00 | AAPL | Stock | 113.97 | 114.949 | 113.6 | 114.71 | 5899303.0 |
| 2020-10-29 11:30:00 | AAPL | Stock | 114.71 | 114.98 | 114.17 | 114.505 | 5795558.0 |
| 2020-10-29 12:00:00 | AAPL | Stock | 114.504 | 115.25 | 114.36 | 115.04 | 5431365.0 |
| 2020-10-29 12:30:00 | AAPL | Stock | 115.04 | 115.24 | 114.9 | 115.07 | 4457681.0 |
| 2020-10-29 13:00:00 | AAPL | Stock | 115.07 | 115.97 | 114.995 | 115.924 | 5754691.0 |
| 2020-10-29 13:30:00 | AAPL | Stock | 115.925 | 116.22 | 115.73 | 116.195 | 5939177.0 |
| 2020-10-29 14:00:00 | AAPL | Stock | 116.2 | 116.83 | 116.19 | 116.74 | 7663150.0 |
| 2020-10-29 14:30:00 | AAPL | Stock | 116.74 | 116.93 | 115.82 | 116.04 | 8644742.0 |
| 2020-10-29 15:00:00 | AAPL | Stock | 116.05 | 116.63 | 115.71 | 116.318 | 9304503.0 |
| 2020-10-29 15:30:00 | AAPL | Stock | 116.315 | 116.73 | 114.52 | 114.52 | 14047553.0 |
| 2020-10-29 16:00:00 | AAPL | Stock | 114.52 | 116.22 | 113.27 | 115.96 | 10549179.0 |
| 2020-10-29 16:30:00 | AAPL | Stock | 115.94 | 115.94 | 109.2 | 109.96 | 8695758.0 |
| 2020-10-29 17:00:00 | AAPL | Stock | 109.9 | 112.65 | 109.01 | 109.8 | 2770508.0 |
| 2020-10-29 17:30:00 | AAPL | Stock | 109.89 | 110.5 | 108.77 | 109.26 | 1794086.0 |
| 2020-10-29 18:00:00 | AAPL | Stock | 109.29 | 109.92 | 108.59 | 109.19 | 783083.0 |
| 2020-10-29 18:30:00 | AAPL | Stock | 109.17 | 110.47 | 109.01 | 110.33 | 723110.0 |
| 2020-10-29 19:00:00 | AAPL | Stock | 110.34 | 111.15 | 110.3 | 110.6 | 558764.0 |
| 2020-10-29 19:30:00 | AAPL | Stock | 110.55 | 110.9 | 110.35 | 110.45 | 372475.0 |
| 2020-10-29 04:00:00 | MSFT | Stock | 204.99 | 205.84 | 204.0 | 204.9 | 6051.0 |
| 2020-10-29 04:30:00 | MSFT | Stock | 204.8 | 204.9 | 204.63 | 204.66 | 2390.0 |
| 2020-10-29 05:00:00 | MSFT | Stock | 204.85 | 205.58 | 204.71 | 205.58 | 2288.0 |
| 2020-10-29 05:30:00 | MSFT | Stock | 205.51 | 205.51 | 205.0 | 205.32 | 4333.0 |
| 2020-10-29 06:00:00 | MSFT | Stock | 205.18 | 205.18 | 204.6 | 204.6 | 4070.0 |
| 2020-10-29 06:30:00 | MSFT | Stock | 204.88 | 204.88 | 204.6 | 204.6 | 1219.0 |
| 2020-10-29 07:00:00 | MSFT | Stock | 205.0 | 205.09 | 203.8 | 203.8 | 37683.0 |
| 2020-10-29 07:30:00 | MSFT | Stock | 203.8 | 204.04 | 202.7 | 202.73 | 34068.0 |
| 2020-10-29 08:00:00 | MSFT | Stock | 204.15 | 205.0 | 202.66 | 203.0 | 62988.0 |
| 2020-10-29 08:30:00 | MSFT | Stock | 203.08 | 203.69 | 202.65 | 203.41 | 58378.0 |
| 2020-10-29 09:00:00 | MSFT | Stock | 203.224 | 204.12 | 203.22 | 203.95 | 66733.0 |
| 2020-10-29 09:30:00 | MSFT | Stock | 203.96 | 205.07 | 203.37 | 204.72 | 3750927.0 |
| 2020-10-29 10:00:00 | MSFT | Stock | 204.72 | 205.47 | 204.0 | 205.25 | 2198542.0 |
| 2020-10-29 10:30:00 | MSFT | Stock | 205.22 | 205.41 | 204.12 | 204.85 | 1305771.0 |
| 2020-10-29 11:00:00 | MSFT | Stock | 204.87 | 205.23 | 204.18 | 205.04 | 1095129.0 |
| 2020-10-29 11:30:00 | MSFT | Stock | 205.02 | 205.25 | 203.95 | 204.31 | 1320290.0 |
| 2020-10-29 12:00:00 | MSFT | Stock | 204.33 | 204.74 | 204.21 | 204.53 | 812127.0 |
| 2020-10-29 12:30:00 | MSFT | Stock | 204.55 | 205.14 | 204.25 | 204.8 | 1013048.0 |
> showing 50 of 98,305 rows — these rows as CSV