amelia-leeUntitled Query
    Updated 2022-08-01
    SELECT
    date_trunc('week', block_timestamp) as date,
    MONTH_NAME,
    count(DISTINCT tx_id) as tx_cnt,
    count(DISTINCT from_address) as user_cnt,
    sum(AMOUNT) as eth_amt,
    sum(AMOUNT_USD) as usd_amt
    from polygon.udm_events a join ethereum.core.dim_dates c on a.block_timestamp::date = c.DATE_DAY
    where to_address in ('0x5b3256965e7c3cf26e11fcaf296dfc8807c01073','0xad79e2ea4424781ec61c52cd2464f6ad525e2a5d','0x0eb9198b6375d5deb55101dc7b82ad6654d3301b')
    and symbol = 'WETH'
    and event_name = 'transfer'
    group by 1, 2


    --0xHaM☰d
    Run a query to Download Data