eth_vol_in as (

SELECT

label,

sum(amount_usd) as eth_in

from

ethereum.core.ez_eth_transfers

--join ethereum.core.dim_contracts_extended on eth_from_address=contract_address

join ethereum.core.dim_labels on eth_from_address = address

WHERE

ethereum.core.ez_eth_transfers.block_timestamp::date >= current_date - 7

GROUP BY

1

),

eth_vol_out as (

SELECT

label,

sum(amount_usd) as eth_out

from

ethereum.core.ez_eth_transfers

--join ethereum.core.dim_contracts_extended on eth_to_address=contract_address

join ethereum.core.dim_labels on eth_to_address = address

WHERE

ethereum.core.ez_eth_transfers.block_timestamp::date >= current_date - 7

GROUP BY

1

),

token_vol_in as (

SELECT

label,

sum(amount_usd) as token_in

from

ethereum.core.ez_token_transfers

---join ethereum.core.dim_contracts_extended on from_address=creator_address

join ethereum.core.dim_labels on from_address = address

WHERE