Eman-RazClaim Amount By Type Over Time
Updated 2024-07-09
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", sum(amount) as "Total Claim Amount", case
when to_address='0xa4bd562c37c19c569c5b4418d12d35fa9964931f' then '🐳Whale Vesting'
else '👥Real Circulating Airdrop'
end as "Airdrop Type"
from blast.core.ez_token_transfers
where origin_function_signature='0xcd9829d9'
and origin_to_address='0xf7be503166828fe8565c520d66645ac6a06bbdd7'
and contract_address='0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad'
and from_address='0xf7be503166828fe8565c520d66645ac6a06bbdd7'
group by 1,3
order by 1
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived