PREVIEW / stock_30min / 2021-10-20
file: by_date/stock_30min/2021/2021-10-20.parquet size: 2.2 MB rows: 108,296 symbols: 2,648
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-10-20 04:00:00 | AAPL | Stock | 148.58 | 148.62 | 148.43 | 148.53 | 9066.0 |
| 2021-10-20 04:30:00 | AAPL | Stock | 148.54 | 148.66 | 148.54 | 148.58 | 9064.0 |
| 2021-10-20 05:00:00 | AAPL | Stock | 148.59 | 148.59 | 148.48 | 148.59 | 4849.0 |
| 2021-10-20 05:30:00 | AAPL | Stock | 148.63 | 148.75 | 148.62 | 148.72 | 6378.0 |
| 2021-10-20 06:00:00 | AAPL | Stock | 148.7 | 148.71 | 148.65 | 148.67 | 1956.0 |
| 2021-10-20 06:30:00 | AAPL | Stock | 148.69 | 148.76 | 148.64 | 148.76 | 4989.0 |
| 2021-10-20 07:00:00 | AAPL | Stock | 148.68 | 148.76 | 148.6 | 148.68 | 37655.0 |
| 2021-10-20 07:30:00 | AAPL | Stock | 148.68 | 148.68 | 148.46 | 148.53 | 34538.0 |
| 2021-10-20 08:00:00 | AAPL | Stock | 148.53 | 148.77 | 148.46 | 148.7 | 197376.0 |
| 2021-10-20 08:30:00 | AAPL | Stock | 148.69 | 148.74 | 148.6 | 148.65 | 95879.0 |
| 2021-10-20 09:00:00 | AAPL | Stock | 148.64 | 148.8047 | 148.62 | 148.72 | 174471.0 |
| 2021-10-20 09:30:00 | AAPL | Stock | 148.72 | 149.7539 | 148.7 | 148.99 | 10515390.0 |
| 2021-10-20 10:00:00 | AAPL | Stock | 148.995 | 149.46 | 148.7 | 149.45 | 5151076.0 |
| 2021-10-20 10:30:00 | AAPL | Stock | 149.44 | 149.485 | 149.08 | 149.2288 | 3568701.0 |
| 2021-10-20 11:00:00 | AAPL | Stock | 149.23 | 149.485 | 149.065 | 149.44 | 3484693.0 |
| 2021-10-20 11:30:00 | AAPL | Stock | 149.4482 | 149.74 | 149.36 | 149.6721 | 2985036.0 |
| 2021-10-20 12:00:00 | AAPL | Stock | 149.675 | 149.7 | 149.16 | 149.19 | 2312859.0 |
| 2021-10-20 12:30:00 | AAPL | Stock | 149.19 | 149.36 | 149.03 | 149.2 | 2088058.0 |
| 2021-10-20 13:00:00 | AAPL | Stock | 149.19 | 149.26 | 148.12 | 148.3982 | 3958992.0 |
| 2021-10-20 13:30:00 | AAPL | Stock | 148.3907 | 148.545 | 148.18 | 148.48 | 2310544.0 |
| 2021-10-20 14:00:00 | AAPL | Stock | 148.485 | 148.71 | 148.44 | 148.65 | 1710533.0 |
| 2021-10-20 14:30:00 | AAPL | Stock | 148.66 | 148.86 | 148.63 | 148.81 | 1871127.0 |
| 2021-10-20 15:00:00 | AAPL | Stock | 148.815 | 149.01 | 148.78 | 148.845 | 2142446.0 |
| 2021-10-20 15:30:00 | AAPL | Stock | 148.845 | 149.42 | 148.75 | 149.345 | 5769221.0 |
| 2021-10-20 16:00:00 | AAPL | Stock | 149.34 | 149.38 | 149.03 | 149.08 | 4152812.0 |
| 2021-10-20 16:30:00 | AAPL | Stock | 149.1 | 149.26 | 148.96 | 149.08 | 16766.0 |
| 2021-10-20 17:00:00 | AAPL | Stock | 149.07 | 149.07 | 149.01 | 149.05 | 15590.0 |
| 2021-10-20 17:30:00 | AAPL | Stock | 149.01 | 149.06 | 149.01 | 149.05 | 3827.0 |
| 2021-10-20 18:00:00 | AAPL | Stock | 149.09 | 149.1199 | 148.95 | 148.95 | 13096.0 |
| 2021-10-20 18:30:00 | AAPL | Stock | 148.97 | 149.0 | 148.95 | 148.95 | 7998.0 |
| 2021-10-20 19:00:00 | AAPL | Stock | 148.95 | 149.06 | 148.92 | 148.97 | 19482.0 |
| 2021-10-20 19:30:00 | AAPL | Stock | 148.98 | 148.99 | 148.82 | 148.88 | 23116.0 |
| 2021-10-20 04:00:00 | MSFT | Stock | 308.7 | 308.7 | 308.65 | 308.65 | 504.0 |
| 2021-10-20 05:00:00 | MSFT | Stock | 308.67 | 308.87 | 308.67 | 308.81 | 1755.0 |
| 2021-10-20 05:30:00 | MSFT | Stock | 309.0 | 309.24 | 309.0 | 309.24 | 427.0 |
| 2021-10-20 06:00:00 | MSFT | Stock | 309.21 | 309.5 | 309.01 | 309.01 | 1594.0 |
| 2021-10-20 06:30:00 | MSFT | Stock | 309.01 | 309.1 | 309.0 | 309.1 | 1067.0 |
| 2021-10-20 07:00:00 | MSFT | Stock | 309.05 | 309.4 | 309.01 | 309.06 | 4989.0 |
| 2021-10-20 07:30:00 | MSFT | Stock | 309.18 | 309.18 | 308.69 | 309.0 | 6642.0 |
| 2021-10-20 08:00:00 | MSFT | Stock | 309.4269 | 309.85 | 308.77 | 309.75 | 30573.0 |
| 2021-10-20 08:30:00 | MSFT | Stock | 309.82 | 309.87 | 309.5 | 309.56 | 5925.0 |
| 2021-10-20 09:00:00 | MSFT | Stock | 309.43 | 309.5 | 309.18 | 309.3 | 15303.0 |
| 2021-10-20 09:30:00 | MSFT | Stock | 309.2 | 309.7 | 308.51 | 308.681 | 1738345.0 |
| 2021-10-20 10:00:00 | MSFT | Stock | 308.73 | 308.73 | 307.6448 | 308.55 | 938043.0 |
| 2021-10-20 10:30:00 | MSFT | Stock | 308.54 | 308.7873 | 307.701 | 307.7336 | 574488.0 |
| 2021-10-20 11:00:00 | MSFT | Stock | 307.75 | 307.8998 | 306.98 | 307.3 | 902512.0 |
| 2021-10-20 11:30:00 | MSFT | Stock | 307.31 | 307.555 | 307.02 | 307.2354 | 672804.0 |
| 2021-10-20 12:00:00 | MSFT | Stock | 307.2301 | 307.33 | 307.06 | 307.12 | 498752.0 |
| 2021-10-20 12:30:00 | MSFT | Stock | 307.12 | 307.38 | 306.82 | 307.31 | 449827.0 |
| 2021-10-20 13:00:00 | MSFT | Stock | 307.33 | 307.42 | 306.11 | 306.36 | 719656.0 |
> showing 50 of 108,296 rows — these rows as CSV