distinct to_address, from_address,

sum(eth_value) as eth,

count(distinct tx_hash) as txs

from ethereum.core.fact_transactions

where block_timestamp::date = '2022-05-04'

group by to_address, from_address

order by eth desc

limit 100),

cex as (select

address,

address_name

from ethereum.core.dim_labels

where label_type = 'dex')

select ethereum.eth, ethereum.to_address, ethereum.txs, cex.address_name

from ethereum

join cex

on ethereum.to_address=cex.address

order by ethereum.eth