kasadeghNFT Transaction Percentage
Updated 2022-07-16
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select 'NFT' type , count(DISTINCT TX_HASH) as tranasction_count
from polygon.core.dim_labels as lbl
join polygon.core.fact_event_logs as event
on lbl.ADDRESS = event.CONTRACT_ADDRESS
where lbl.LABEL_TYPE = 'nft' and lower(event_name) like '%transfer%'
union
select 'Other' type, count(DISTINCT TX_HASH) as tranasction_count
from polygon.core.dim_labels as lbl
join polygon.core.fact_event_logs as event
on lbl.ADDRESS = event.CONTRACT_ADDRESS
where lbl.LABEL_TYPE != 'nft' and lower(event_name) like '%transfer%'
Run a query to Download Data