kasadeghDaily Polygon NFT' Transaction Percentage
    Updated 2022-07-14
    select BLOCK_TIMESTAMP::date as day, (count(distinct TX_HASH)/(select count(*) from polygon.core.fact_token_transfers))*100 as transaction_percentage
    from polygon.core.dim_labels as label
    join polygon.core.fact_token_transfers as transfers
    on transfers.CONTRACT_ADDRESS=label.ADDRESS
    where LABEL_TYPE='nft'
    group by day
    order by day
    Run a query to Download Data