adambalaApetimism 11
Updated 2022-09-02
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
count (distinct tx_hash) as vSwap,
count (distinct origin_from_address) as vSwappers ,
ADDRESS ,
PROJECT_NAME,
LABEL_TYPE
from OPTIMISM.core.fact_event_logs inner join OPTIMISM.core.dim_labels
on origin_to_address =ADDRESS where LABEL_TYPE ilike '%nft%'
group by 3,4,5
Run a query to Download Data