shreexsafe
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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