Eman-RazTotal Claim Stats
Updated 2025-01-24
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
›
⌄
with tab1 as (select block_timestamp, origin_from_address, amount, amount_usd,
token_price, tx_hash
from base.core.ez_token_transfers
where origin_function_signature='0x2f52ebb7'
and origin_to_address='0x584cb7dae5158be594aa1022fb38017c791af2a0' -- $CARV Airdrop
and contract_address='0xc08cd26474722ce93f4d0c34d16201461c10aa8c' -- $CARV Token
and from_address=origin_to_address
and to_address=origin_from_address
and symbol='CARV')
select count(distinct origin_from_address) as "Claimer Count", '40000000' as "Round.1 Allocated Tokens",
sum(amount) as "Amount ($CARV)", (sum(amount)/40000000)*100 as "% of Tokens Claimed",
avg(amount) as "Avg", '1000000000' as "Total Supply", '100000000' as "Total Allocated Tokens",
median(amount) as "Median",
max(amount) as "Max",
sum(amount_usd) as "Amount ($USD)"
FROM TAB1
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived