An example query showing how to use a (abuse?) group by to break out multiple columns of prices.

Since cryptocurrencies trade on days when securities won't, we need to use a left or full join on the date to merge them together.

The MAX aggregate function has no real effect, since the FILTER expression will limit the aggregate to take the max of only one value.