fabre-basepoolynft-avg
    Updated 2022-06-22

    with nft_rn as (
    select
    nft_to_address,
    nft_address,
    tokenid,
    row_number() over (partition by nft_address, tokenid order by block_timestamp desc) rn
    from ethereum.core.ez_nft_transfers
    where
    nft_address in (
    lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'),
    lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'),
    lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'))
    )
    select
    count(1) mints, count(distinct nft_to_address) wallets, mints / wallets *1.0
    from nft_rn
    where rn = 1



    Run a query to Download Data