p_crypt00All NFT transactions
    Updated 2022-07-14
    with
    addresses_of_nfts as
    (
    Select *
    from polygon.core.DIM_LABELS
    where label_type='nft'
    ),
    all_txs as (
    Select *
    from polygon.core.fact_token_transfers
    inner join addresses_of_nfts
    where addresses_of_nfts.address=fact_token_transfers.contract_address
    )
    Select date_trunc(day, block_timestamp) as daily, count(*), contract_address from all_txs group by contract_address, daily


    Run a query to Download Data