MLDZMNUni2
    Updated 2023-04-13
    with tb1 as (select
    tx_hash
    from ethereum.core.fact_transactions
    where (to_address='0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b' or from_address='0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b')
    )

    select
    block_timestamp::date as date,
    count(distinct tx_hash) as sale_no,
    count(distinct BUYER_ADDRESS) as buyer_no,
    count(distinct TOKENID) as no_NFTs,
    sum(PRICE) as volume,
    sum(PRICE_USD) as volume_usd,
    avg(PRICE_USD) as average_volume,
    Median(PRICE_USD) as median_volume,
    avg(average_volume) OVER (ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days,
    sum(buyer_no) over (order by date) as cum_buyers,
    sum(sale_no) over (order by date) as cum_sale,
    sum(volume_usd) over (order by date) as cum_volume
    from ethereum.core.ez_nft_sales
    where tx_hash in (select tx_hash from tb1)
    and PRICE_USD>0
    group by 1
    order by 1
    Run a query to Download Data