select --date_trunc('hour',BLOCK_TIMESTAMP) as hour

sum(amount/1e6) as volume

,median(amount/1e6) as avg_volume

,count(distinct SENDER) as senders

,count(distinct TX_ID) as transfers

from lava.core.fact_transfers

where RECEIVER ilike'axelar%'

and CURRENCY='ulava'

and TRANSFER_TYPE='IBC_TRANSFER_OUT'

and BLOCK_TIMESTAMP::date>='2024-07-29'