banksywatsUntitled Query
    Updated 2022-08-10
    select date_trunc('day', block_timestamp) as day, count(distinct event_to) as Seller
    from ethereum.nft_events
    left outer join ethereum.nft_metadata
    on nft_events.contract_address=nft_metadata.contract_address
    where nft_metadata.project_name like '%avers%'
    and event_type='sale'
    group by 1