daily change of crypto prices

f_crypto_prices_daily_change.sql

with yest AS (
    SELECT currency, price
    FROM f_crypto_prices
    WHERE TRUNC(datetime, 'day') = '20220315')
, today AS (
    SELECT currency, price
    FROM f_crypto_prices
    WHERE TRUNC(datetime, 'day') = '20220316')

SELECT
  currency,
  (today.price - yest.price) / yest.price * 100 AS pct_change
FROM yest, today
WHERE currency = 'BTC'