binhachonMirror Funding Mechanisms - #3
    Updated 2022-06-24
    select
    date_trunc('week', block_timestamp) as time,
    case when eth_from_address = '0x835f86ff1670917a786b72d1fd8dcc385e27dd77' then 'Auction' else 'Crowsource' end as source,
    sum(amount) as weekly_amount,
    sum(weekly_amount) over (order by time) as total_amount
    from ethereum.core.ez_eth_transfers
    where eth_to_address = lower('0x138c3d30A724de380739aad9ec94E59e613a9008')
    group by 1, 2
    Run a query to Download Data