john-adamUntitled Query
Updated 2022-10-22
9
1
2
3
4
5
6
7
›
⌄
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