with toooop as (SELECT

CASE when ADDRESS_NAME is NULL then ORIGIN_FROM_ADDRESS else ADDRESS_NAME end as type,ORIGIN_FROM_ADDRESS,

count (DISTINCT TX_HASH) as TX,

sum (AMOUNT) as Amount,

sum (AMOUNT_USD) as USD

FROM ethereum.core.ez_eth_transfers

LEFT JOIN ethereum.core.dim_labels on ORIGIN_FROM_ADDRESS = ADDRESS

WHERE ETH_FROM_ADDRESS = '0x889edc2edab5f40e902b864ad4d7ade8e412f9b1'

and BLOCK_TIMESTAMP >= '2023-05-15'

GROUP BY 1,2 ORDER BY AMOUNT DESC limit 10)

CASE when ADDRESS_NAME is NULL then ETH_TO_ADDRESS else ADDRESS_NAME end as type,ETH_TO_ADDRESS,

sum (AMOUNT) as AMOUNTs

FROM ethereum.core.ez_eth_transfers

LEFT JOIN ethereum.core.dim_labels on ETH_TO_ADDRESS = ADDRESS

WHERE ETH_FROM_ADDRESS in (SELECT ORIGIN_FROM_ADDRESS from toooop )

and BLOCK_TIMESTAMP >= '2023-05-15'

GROUP BY 1,2