kasadeghNFT Transaction Percentage
    Updated 2022-07-16
    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