NavidCopy of Untitled Query
    Updated 2022-11-07
    select
    initcap(l.PROJECT_NAME, ' ') as type,
    count(distinct ORIGIN_FROM_ADDRESS) as user_count,
    count(distinct tx_hash) as transactions_count,
    row_number() over (order by transactions_count desc) as rn,
    concat(lpad(rn,3,'0'),' - ',type) as type_rn
    from
    optimism.core.fact_event_logs
    JOIN optimism.core.dim_labels l ON ADDRESS=ORIGIN_TO_ADDRESS
    where
    contract_address='0x4200000000000000000000000000000000000042' and
    TX_STATUS = 'SUCCESS'
    GROUP BY
    1
    ORDER BY
    type_rn asc
    limit 20
    Run a query to Download Data