Query editor
with daily as (selectchain,count(*) as daily_txs-- count(distinct token) as type_of_tokensfrom wormhole_ethereum.TokenBridge_call_transferTokens weleft join dune.hashed_official.result_wormhole_chain_id wc on we.recipientChain=wc.chainIdwhere call_successand call_block_time >= now() - interval '24' hourgroup by 1order by 2 desc),weekly as (selectchain,count(*) as weekly_txsfrom wormhole_ethereum.TokenBridge_call_transferTokens weleft join dune.hashed_official.result_wormhole_chain_id wc on we.recipientChain=wc.chainIdwhere call_successand call_block_time >= now() - interval '7' daygroup by 1order by 2 desc),monthly as (selectchain,count(*) as monthly_txsfrom wormhole_ethereum.TokenBridge_call_transferTokens weleft join dune.hashed_official.result_wormhole_chain_id wc on we.recipientChain=wc.chainIdwhere call_successand call_block_time >= now() - interval '30' daygroup by 1order by 2 desc),total as (selectchain,count(*) as total_txsfrom wormhole_ethereum.TokenBridge_call_transferTokens weleft join dune.hashed_official.result_wormhole_chain_id wc on we.recipientChain=wc.chainIdwhere call_successgroup by 1order by 2 desc)selectrow_number() over(order by daily_txs desc) rk,*from totalleft join daily using(chain)left join weekly using(chain)left join monthly using(chain)order by rk asc