MLDZMNANKA2
    Updated 2023-03-14
    with t1 as (select
    BLOCK_TIMESTAMP::date as date,
    count(distinct tx_hash) as no_txn,
    count(distinct FROM_ADDRESS) as no_sender,
    sum(AMOUNT_USD) as volume_usd,
    avg(AMOUNT_USD) as average_volume,
    Median(AMOUNT_USD) as median_volume,
    avg(average_volume) OVER (ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days,
    sum(no_sender) over (order by date) as total_users,
    sum(no_txn) over (order by date) as total_donate,
    sum(volume_usd) over (order by date) as total_volume
    from ethereum.core.ez_token_transfers
    where TO_ADDRESS in (
    lower('0xce4d5b5933b369e9c937ffcfbb9e3aeb3d2c265b'), -- ANKA relief
    lower('0xbe4cde5eeeed1f0a97a9457f6ef5b71eae108652'), -- ihtiyac haritasi
    lower('0xEd67922e36eD2422d391306f6f6ECC19d58EAa4f'), -- refikanadol
    lower('0xe1935271D1993434A1a59fE08f24891Dc5F398Cd'), -- Ahbap
    lower('0x64A994CC850a56e87331d880A23A69b16dbFC8ea'), -- AFAD
    lower('0x9b40f98ccc326beaa0bfb94cfa8bfc6383a267e5'), -- Community Volunteers Foundation
    lower('0x9842453c14f3d0eda2073259a258ee2bdee827a8'), -- Support To Life
    lower('0x17517d7e79543750983735B0Fe3Ec6aff8eFD55f'), -- Support To Life
    lower('0xf4016873Cca7c516CE2e5659Ccbb55b2E7AC58c9'), -- Basic Needs Association
    lower('0x1fc82b7a62c0414163A332693Ec66EC91f4cd1dE'), -- KIZILAY
    lower('0x3b816b03B9b6b46376D5423C62aFBb311ff9218F'), -- AKUT
    lower('0x25d1A1F25aF8340Ab45dB7f1686F5A225BF9e07E'), -- NEF
    lower('0x93d9ef15f0b410abcbb599d2e6acc1afad97363f') -- Unicef
    )
    and block_timestamp>='2023-02-06'
    group by 1
    union all
    select
    BLOCK_TIMESTAMP::date as date,
    count(distinct tx_hash) as no_txn,
    count(distinct ETH_FROM_ADDRESS) as no_sender,
    sum(AMOUNT_USD) as volume_usd,
    avg(AMOUNT_USD) as average_volume,
    Run a query to Download Data