takamoritrying to get veefriends
    select
    A.date, B.median, B.avg, max(sales-buys)

    from

    (select date(block_timestamp) as date, seller_address, count(*) as sales from ethereum.core.ez_nft_sales where nft_address = {{nft}} and platform_name = 'blur'
    and block_timestamp > {{date}}

    group by 1, 2, 3) as A

    left join

    (select date(block_timestamp) as date, buyer_address, count(*) as buys from ethereum.core.ez_nft_sales where nft_address = {{nft}} and platform_name = 'blur'
    and block_timestamp > {{date}}

    group by 1, 2) as C

    on A.date = C.date and A.seller_address = C.buyer_address

    JOIN

    (select date(block_timestamp) as date, median(price) as median, sum(price)/count(price) as avg
    from ethereum.core.ez_nft_sales where nft_address = {{nft}} and platform_name = 'blur'
    and block_timestamp > {{date}}

    group by 1
    ) as B

    on

    A.date = B.date

    group by 1 order by 1 desc

    Run a query to Download Data