'Ethereum' as chain

,date_trunc('{{Date_Grouping}}',block_timestamp)::date as date

,datediff(day,min(block_timestamp),max(block_timestamp)) as Activity_days

,count(DISTINCT tx_hash) as tx_count

,count(DISTINCT FROM_ADDRESS) as wallets

,sum(amount) as volume

,avg(amount) as avg_volume

from ethereum.core.ez_token_transfers

where block_timestamp::date>=CURRENT_DATE-{{Days}}

and SYMBOL = 'USDC' --USDC in ETH

and amount_usd>0

group by 1,2

union all

select

'Solana' as chain

,date_trunc('{{Date_Grouping}}',block_timestamp)::date as date

,datediff(day,min(block_timestamp),max(block_timestamp)) as Activity_days

,count(DISTINCT tx_id) as tx_count

,count(DISTINCT tx_from) as wallets

,sum(amount) as volume

,avg(amount) as avg_volume

from solana.core.fact_transfers

where block_timestamp::date>=CURRENT_DATE-{{Days}}

and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --USDC in Solana

group by 1,2

union all

select

'Algorand' as chain

,date_trunc('{{Date_Grouping}}',block_timestamp)::date as date

,datediff(day,min(block_timestamp),max(block_timestamp)) as Activity_days

,count(DISTINCT tx_id) as tx_count