Monitize AINeuron 1
Updated 2024-07-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with claimt as (
select
date_trunc('day', BLOCK_TIMESTAMP) as dates,
count(distinct TO_ADDRESS) as users,
sum(amount) as claimed_amount,
sum(amount_usd) as claim_usd_amt
from arbitrum.core.ez_token_transfers
where CONTRACT_ADDRESS = lower('0xdadeca1167fe47499e53Eb50F261103630974905')
and FROM_ADDRESS = lower('0xb063f2af926af95f08515fd9d5f2397ce97148bf')
and ORIGIN_FUNCTION_SIGNATURE = '0x2f0879f7'
group by 1
),
airdrop_contract as (
select
sum(amount) as claimable_amount
from arbitrum.core.ez_token_transfers
where CONTRACT_ADDRESS = lower('0xdadeca1167fe47499e53Eb50F261103630974905')
and TO_ADDRESS = lower('0xb063f2af926af95f08515fd9d5f2397ce97148bf')
)
select
dates,
ifnull(claimed_amount,0) as claimed_amount,
ifnull(users,0) as claimers,
sum(ifnull(claimed_amount,0)) over(order by dates asc) as cum_claimed_amount,
claimable_amount - sum(ifnull(claimed_amount,0)) over(order by dates asc) as cum_unclaimed_amount,
sum(ifnull(users,0)) over(order by dates asc) as cum_claimers
from claimt,airdrop_contract
where dates > '2024-06-23'
--group by claimable_amount
order by 1 asc
QueryRunArchived: QueryRun has been archived