'Ethereum' as chain ,

count(distinct tx_hash) as txns,

count(distinct FROM_ADDRESS) as senders,

count(distinct TO_ADDRESS) as receivers,

sum(AMOUNT_USD) as trns_amt,

avg(AMOUNT_USD) as avg_amount,

median(AMOUNT_USD) as median_amount,

trns_amt/txns as amt_per_txn,

trns_amt/senders as amt_per_sender,

trns_amt/receivers as amt_per_receiver,

trns_amt/{{days_back}} as amt_per_day,

txns/{{days_back}} as txns_per_day,

senders/{{days_back}} as senders_per_day,

receivers/{{days_back}} as receivers_per_day

from

ethereum.core.ez_token_transfers

where

SYMBOL ilike 'usdc'

and

BLOCK_TIMESTAMP::date >= CURRENT_DATE - {{days_back}}

union all

select

'Algorand' as chain ,

count(distinct tx_id) as txns,

count(distinct ASSET_SENDER) as senders,

count(distinct receiver) as receivers,

sum(amount) as trns_amt,