freemartianTotal claim
Updated 2 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with datas as (
select
-- *
block_timestamp, tx_hash, to_address as user_address, amount,
from base.core.ez_token_transfers
where from_address = '0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'
and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'
and origin_function_signature = '0x69659658'
-- and tx_hash = '0x86a6bacdce3799c129a3b596a506bb6aa73b1d885e80179f46624fe8fdbda201'
)
select
count(tx_hash) as transactions,
count(distinct user_address) as users,
sum(amount) as amounts,
100 * (sum(amount) / 100000000) as claimed_percentage,
100 - claimed_percentage as unclaimed_percentage,
0.0015*transactions as fee_collected
from datas