where origin_to_address=lower('0x881D40237659C251811CEC9c364ef91dC08D300C'))

,tbl_in as (select sum(amount) as amount_in , eth_to_address from ethereum.core.ez_eth_transfers

where eth_to_address in (select origin_from_address from metamask) and amount>0

group by eth_to_address)

,tbl_out as (select sum(amount) as amount_out , eth_from_address from ethereum.core.ez_eth_transfers

where eth_from_address in (select origin_from_address from metamask) and amount>0

group by eth_from_address)

,holders as (select (amount_in-amount_out) as amount,eth_to_address from tbl_in left join tbl_out

on eth_to_address=eth_from_address

where (amount_in-amount_out)>0

, staking as (select

count(distinct to_address)

from ethereum.core.ez_token_transfers

where

from_address = '0x0000000000000000000000000000000000000000'

and to_address != '0x0000000000000000000000000000000000000000' and to_address in (select origin_from_address from metamask))

, transactions_daily as (select count(*) as count , date_trunc('day', block_timestamp) as date from ethereum.core.fact_transactions where to_address in (select origin_from_address from metamask)

group by date)

, transactions_weekly as (select count(*) as count , date_trunc('week', block_timestamp) as date from ethereum.core.fact_transactions where to_address in (select origin_from_address from metamask)

group by date)

, transactions_monthly as (select count(*) as count , date_trunc('month', block_timestamp) as date from ethereum.core.fact_transactions where to_address in (select origin_from_address from metamask)

group by date)

, transactions_yearly as (select count(*) as count , date_trunc('year', block_timestamp) as date from ethereum.core.fact_transactions where to_address in (select origin_from_address from metamask)

group by date)

select * from transactions_yearly