john-adamUntitled Query
    Updated 2022-10-22
    with optimisim_address as (select address from ethereum.core.dim_labels where label_type='layer2' and label like '%optimism%')

    select count(*),sum(AMOUNT_USD),ADDRESS_NAME from ethereum.core.ez_token_transfers inner join ethereum.core.dim_labels
    on ethereum.core.dim_labels.address=ethereum.core.ez_token_transfers.FROM_ADDRESS
    where TO_ADDRESS in (select address from optimisim_address) and ADDRESS_NAME!=''
    group by 3
    having sum(AMOUNT_USD) is not null
    Run a query to Download Data