select

date(hour::date) as day

,symbol

,avg(price) as avg_price

from crosschain.price.ez_hourly_token_prices

group by 1,2

select

-- amount*avg_price as tt

-- ,*

token_symbol

,count(DISTINCT tx_hash) as transactions

,count(sender) as wallets

,sum(amount*avg_price) as amount_usd

,avg(amount*avg_price) as avg_usd_volume

from axelar.defi.ez_bridge_satellite

join lst_price on symbol = token_symbol

and block_timestamp::date = day

-- and ( SOURCE_CHAIN='axelar' or DESTINATION_CHAIN = 'axelar')

-- where token_symbol = 'LUNA'

group by 1

order by amount_usd desc