mucryptodex label
    Updated 2023-02-16
    with ethereum as (select
    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
    Run a query to Download Data