token,

token_contract,

avg (price_usd) as USDPrice

from flow.core.fact_prices

where token != 'Blocto'

group by 1, 2, 3

)

select token, direction,

count (distinct tx_id) as bridges,

count (distinct flow_wallet_address) as bridgers,

sum (amount*usdprice) as USD_Volume,

avg (amount*usdprice) as Average_USD_Volume,

min (amount*usdprice) as Min_USD_Volume,

max (amount*usdprice) as Max_USD_Volume

from flow.core.ez_bridge_transactions a join price b on a.block_timestamp::date = b.day and a.token_contract = b.token_contract

where token in ('USDC', 'Flow', 'Starly', 'Sportium', 'REVV', 'FUSD', 'Blocto Token', 'USDT')

group by 1, 2

order by 2 desc