mucryptoEthereum, current top 10 dapps
    Updated 2023-04-06
    with number as (select
    count(tx_hash) as txs,
    to_address
    from ethereum.core.fact_transactions
    where block_timestamp::date = current_date
    group by 2),

    label as (select
    distinct label,
    address
    from ethereum.core.dim_labels
    where label_type = 'dapp')

    select
    number.txs,
    number.to_address,
    label.label
    from number
    join label
    on number.to_address = label.address
    order by number.txs desc
    limit 10
    Run a query to Download Data