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