-- forked from 0136c15a-7fa6-402c-9ac6-c30e2f5f57e0
select
PROJECT_NAME AS Project,
count(*) AS "Transcations Count"
from
arbitrum.core.fact_transactions
inner join arbitrum.core.dim_labels on address=To_Address
where
BLOCK_TIMESTAMP >= dateadd(
Day,
- {{Last-N-Days}},
current_date) and LABEL_TYPE not in ('chadmin', 'token')
group by 1 order by 2 desc limit 10