Monitize AIBubble 1
Updated 2024-07-17
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
›
⌄
⌄
⌄
select
distinct from_address,
ORIGIN_FUNCTION_SIGNATURE,
min(BLOCK_TIMESTAMP) as min_date,
--date_trunc('hour', BLOCK_TIMESTAMP) as dates,
count(distinct TO_ADDRESS) as users,
sum(amount) as claimed_amount
from ethereum.core.ez_token_transfers
where CONTRACT_ADDRESS = lower('0xe9689028eDE16c2FDFE3D11855D28f8E3fC452a3')
and FROM_ADDRESS in ('0xa364afa0696ca0f0c75ba068c436346d815a5998')
and ORIGIN_FUNCTION_SIGNATURE in ('0xe86e7b44','0x302f7cd7')
group by 1,2
order by 4 desc
--)
/*airdrop_contract as (
select
sum(amount) as claimable_amount
from ethereum.core.ez_token_transfers
where CONTRACT_ADDRESS = lower('0x63696Fc66795B51d02c1590b536484A41fbDDF9a')
and TO_ADDRESS in ('0x3db08a08434bfb774271e46d277468f8da0da144')
)*/
/*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,
1260000000 - 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
--group by claimable_amount
order by 1 asc */
QueryRunArchived: QueryRun has been archived