mz0111easy Q 1
    Updated 2023-09-18
    SELECT
    'ETH' as name,
    count( distinct TX_HASH) as "sales count",
    count(distinct SELLER_ADDRESS ) as "unique sellers num",
    count(distinct BUYER_ADDRESS ) as "unique buyers num",
    sum(PRICE_USD) as "USD amount",
    count( TX_HASH) /DATEDIFF(day, '2023-04-07', CURRENT_DATE) AS "AVG TX COUNT/DAY",
    count(DISTINCT BUYER_ADDRESS) / DATEDIFF(day, '2023-04-07', CURRENT_DATE) AS "AVG Unique buyer/DAY",
    count(DISTINCT SELLER_ADDRESS)/ DATEDIFF(day, '2023-04-07', CURRENT_DATE) AS "AVG Unique seller/DAY",
    sum(PRICE_USD) / DATEDIFF(day, '2023-04-07', CURRENT_DATE) AS "AVG USD Sales amount/DAY",
    "unique buyers num" / "unique sellers num" AS "unique buyers num / unique sellers num",
    "USD amount" / "sales count" AS "USD amount / sales count"
    from ethereum.core.ez_nft_sales
    where BLOCK_TIMESTAMP >= current_date - {{period}}
    and 1=1
    and EVENT_TYPE = 'sale'
    Run a query to Download Data