crypto_alerts.sql

with begin as
  (select currency,
          max(price) as price
   from crypto_prices_delta
   where date_key = {{date_key | sqlsafe}}
     and datetime =
       (select min(datetime)
        from crypto_prices_delta
        where date_key = {{date_key | sqlsafe}})
   group by currency), end as
  (select currency,
          max(price) as price
   from crypto_prices_delta
   where date_key = {{date_key | sqlsafe}}
     and datetime =
       (select max(datetime)
        from crypto_prices_delta
        where date_key = {{date_key | sqlsafe}})
   group by currency)
select begin.currency,
       end.price as end_price,
       begin.price as begin_price,
       round((end.price - begin.price) / begin.price, 4) *100 as pct_change
from begin,
     end
where begin.currency = end.currency