Delamir-6014WC01 MLB Number of NFT transfer over time
    Updated 2022-11-22

    select
    date(BLOCK_TIMESTAMP) as date,
    count(distinct tx_hash) as Number_TX,
    count (distinct nft_froM_address) as Num_sender,
    count (distinct nft_to_address) as Num_reciever,
    count (distinct tokenid) as Number_tokens
    from ethereum.core.ez_nft_transfers
    where NFT_ADDRESS = lower('0xC43c97cFEBfE912906c52A268Ed5B6e21c8CC39d')
    and EVENT_TYPE != 'mint'
    group by 1