shreexsafe
    Updated 2022-09-29
    select
    date_trunc('hour',block_timestamp) as date,
    sum(amount) as airdropped_safe,
    count(distinct origin_from_address) as airdroppers,
    sum(airdropped_safe) over (order by date) as cumulative_safe_airdropped,
    sum(airdroppers ) over (order by date) as cumulative_safe_airdroppers
    from ethereum.core.ez_token_transfers
    where from_address='0xa0b937d5c8e32a80e3a8ed4227cd020221544ee6' -- safe airdrop address
    and symbol='SAFE' and contract_address='0x5afe3855358e112b5647b952709e6165e1c1eeee'
    GROUP BY date
    ORDER BY date
    Run a query to Download Data