zakkisyedSecondary Sales on Opensea Drops
    Updated 2023-04-06
    with secondary_sales as (

    select date_trunc(day,block_timestamp) as dt,
    count(*) as sale_count,
    sum(price) as eth_volume,
    sum(price_usd) as usd_volume,
    platform_name
    from ethereum.core.ez_nft_sales
    where nft_address = lower('{{contract}}') -- SHARI
    and origin_from_address != '0x0000000000000000000000000000000000000000'
    --and status = 'SUCCESS'
    group by 1,5
    order by 1 asc
    )

    select * from secondary_sales
    Run a query to Download Data