PREVIEW / stock_30min / 2020-12-16
file: by_date/stock_30min/2020/2020-12-16.parquet size: 2.2 MB rows: 108,466 symbols: 2,682
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-12-16 04:00:00 | AAPL | Stock | 128.08 | 128.7 | 128.08 | 128.6 | 30674.0 |
| 2020-12-16 04:30:00 | AAPL | Stock | 128.55 | 128.61 | 128.55 | 128.59 | 12075.0 |
| 2020-12-16 05:00:00 | AAPL | Stock | 128.58 | 128.59 | 128.5 | 128.57 | 7950.0 |
| 2020-12-16 05:30:00 | AAPL | Stock | 128.57 | 128.6 | 128.5 | 128.6 | 12172.0 |
| 2020-12-16 06:00:00 | AAPL | Stock | 128.6 | 128.6 | 127.88 | 127.95 | 23939.0 |
| 2020-12-16 06:30:00 | AAPL | Stock | 128.0 | 128.1 | 126.88 | 127.64 | 77821.0 |
| 2020-12-16 07:00:00 | AAPL | Stock | 127.53 | 127.88 | 127.26 | 127.74 | 243937.0 |
| 2020-12-16 07:30:00 | AAPL | Stock | 127.77 | 127.88 | 127.72 | 127.84 | 74912.0 |
| 2020-12-16 08:00:00 | AAPL | Stock | 127.28 | 127.99 | 127.26 | 127.7 | 367587.0 |
| 2020-12-16 08:30:00 | AAPL | Stock | 127.68 | 127.85 | 127.5 | 127.74 | 161484.0 |
| 2020-12-16 09:00:00 | AAPL | Stock | 127.76 | 127.8 | 126.98 | 127.38 | 481087.0 |
| 2020-12-16 09:30:00 | AAPL | Stock | 127.39 | 127.7 | 126.56 | 127.16 | 14101107.0 |
| 2020-12-16 10:00:00 | AAPL | Stock | 127.185 | 127.87 | 126.81 | 127.092 | 8107472.0 |
| 2020-12-16 10:30:00 | AAPL | Stock | 127.1 | 127.45 | 126.911 | 126.99 | 4692225.0 |
| 2020-12-16 11:00:00 | AAPL | Stock | 126.995 | 127.37 | 126.69 | 127.04 | 4721930.0 |
| 2020-12-16 11:30:00 | AAPL | Stock | 127.033 | 127.83 | 127.02 | 127.8 | 4647783.0 |
| 2020-12-16 12:00:00 | AAPL | Stock | 127.8 | 128.02 | 127.36 | 127.555 | 4592945.0 |
| 2020-12-16 12:30:00 | AAPL | Stock | 127.55 | 127.81 | 127.34 | 127.775 | 2720835.0 |
| 2020-12-16 13:00:00 | AAPL | Stock | 127.77 | 127.789 | 127.26 | 127.375 | 2721175.0 |
| 2020-12-16 13:30:00 | AAPL | Stock | 127.375 | 127.94 | 127.34 | 127.66 | 3615913.0 |
| 2020-12-16 14:00:00 | AAPL | Stock | 127.67 | 127.8 | 127.285 | 127.4 | 4243727.0 |
| 2020-12-16 14:30:00 | AAPL | Stock | 127.4 | 128.235 | 127.38 | 128.11 | 5302458.0 |
| 2020-12-16 15:00:00 | AAPL | Stock | 128.12 | 128.17 | 127.7 | 128.105 | 4648563.0 |
| 2020-12-16 15:30:00 | AAPL | Stock | 128.11 | 128.37 | 127.69 | 127.75 | 8946804.0 |
| 2020-12-16 16:00:00 | AAPL | Stock | 127.81 | 127.83 | 127.475 | 127.65 | 10166217.0 |
| 2020-12-16 16:30:00 | AAPL | Stock | 127.63 | 127.89 | 127.62 | 127.81 | 58187.0 |
| 2020-12-16 17:00:00 | AAPL | Stock | 127.81 | 127.81 | 127.72 | 127.72 | 13150.0 |
| 2020-12-16 17:30:00 | AAPL | Stock | 127.75 | 127.91 | 127.7 | 127.78 | 28851.0 |
| 2020-12-16 18:00:00 | AAPL | Stock | 127.83 | 127.93 | 127.83 | 127.89 | 19046.0 |
| 2020-12-16 18:30:00 | AAPL | Stock | 127.88 | 127.93 | 127.82 | 127.9 | 15492.0 |
| 2020-12-16 19:00:00 | AAPL | Stock | 127.88 | 127.9 | 127.65 | 127.69 | 21091.0 |
| 2020-12-16 19:30:00 | AAPL | Stock | 127.72 | 127.84 | 127.67 | 127.8 | 61764.0 |
| 2020-12-16 04:00:00 | MSFT | Stock | 214.4 | 214.4 | 214.4 | 214.4 | 2000.0 |
| 2020-12-16 04:30:00 | MSFT | Stock | 214.49 | 214.5 | 214.49 | 214.5 | 961.0 |
| 2020-12-16 05:30:00 | MSFT | Stock | 214.32 | 214.32 | 214.18 | 214.22 | 1726.0 |
| 2020-12-16 06:00:00 | MSFT | Stock | 214.31 | 214.95 | 214.3 | 214.77 | 8985.0 |
| 2020-12-16 06:30:00 | MSFT | Stock | 214.77 | 215.1 | 214.77 | 215.01 | 8554.0 |
| 2020-12-16 07:00:00 | MSFT | Stock | 215.0 | 215.0 | 214.64 | 214.7 | 10956.0 |
| 2020-12-16 07:30:00 | MSFT | Stock | 214.7 | 214.98 | 214.7 | 214.8 | 3396.0 |
| 2020-12-16 08:00:00 | MSFT | Stock | 214.83 | 214.969 | 213.6 | 214.5 | 16282.0 |
| 2020-12-16 08:30:00 | MSFT | Stock | 214.48 | 214.64 | 214.409 | 214.5 | 10761.0 |
| 2020-12-16 09:00:00 | MSFT | Stock | 214.5 | 214.85 | 214.45 | 214.73 | 17297.0 |
| 2020-12-16 09:30:00 | MSFT | Stock | 214.88 | 216.643 | 214.72 | 215.98 | 3221485.0 |
| 2020-12-16 10:00:00 | MSFT | Stock | 215.909 | 216.74 | 215.72 | 216.672 | 1672600.0 |
| 2020-12-16 10:30:00 | MSFT | Stock | 216.66 | 217.66 | 216.572 | 217.13 | 2032136.0 |
| 2020-12-16 11:00:00 | MSFT | Stock | 217.13 | 218.17 | 217.13 | 217.995 | 1566954.0 |
| 2020-12-16 11:30:00 | MSFT | Stock | 217.99 | 219.19 | 217.934 | 219.18 | 1826075.0 |
| 2020-12-16 12:00:00 | MSFT | Stock | 219.19 | 219.35 | 218.6 | 218.77 | 1362934.0 |
| 2020-12-16 12:30:00 | MSFT | Stock | 218.77 | 219.03 | 218.42 | 218.9 | 1543146.0 |
| 2020-12-16 13:00:00 | MSFT | Stock | 218.884 | 219.28 | 218.79 | 218.93 | 861549.0 |
> showing 50 of 108,466 rows — these rows as CSV