with token_price as

SELECT

date_trunc('day', RECORDED_HOUR) as date,

median(price) as usd_price

FROM osmosis.price.ez_prices

WHERE symbol = 'AXL'

GROUP BY 1

,

main as (

SELECT

block_timestamp::date as dates,

tx_id,

amount/pow(10,decimal) as amounts,

(amount/pow(10, decimal)) * b.usd_price as amount_usd,

sender,

receiver

FROM axelar.core.fact_transfers a

LEFT JOIN token_price b ON date_trunc('d', block_timestamp) = b.date

WHERE currency = 'uaxl'

SELECT

date,

n_transfer,

ZEROIFNULL((n_transfer - LAG(n_transfer) over (ORDER BY date)) / LAG(n_transfer) over (ORDER BY date)) * 100 as "n_transfer. Δ (%)",

IFF( n_transfer > LAG(n_transfer) over (ORDER BY date), '🟢','🔴') as " ",

amounts_usd,

ZEROIFNULL((amounts_usd - LAG(amounts_usd) over (ORDER BY date)) / LAG(amounts_usd) over (ORDER BY date)) * 100 as "Amount[USD]. Δ (%)",

IFF(amounts_usd > LAG(amounts_usd) over (ORDER BY date), '🟢','🔴') as " ",