alitaslimiAirdrop Overview
Updated 2023-04-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
25
26
27
28
29
30
31
32
›
⌄
WITH
recipients AS (
SELECT
COUNT(DISTINCT CONCAT('0x', RIGHT(topics[1], 40))) as users,
SUM(ethereum.public.udf_hex_to_int(data)) / POW(10, 18) AS amount
FROM
arbitrum.core.fact_event_logs
WHERE
tx_status = 'SUCCESS'
AND contract_address = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
AND topics[0] = '0x87aeeb9eda09a064caef63d00f62c15063631980bfc422ad7dd30c8a79f0cbb7'
),
claimers AS (
SELECT
COUNT(DISTINCT to_address) AS users,
SUM(raw_amount) / POW(10, 18) AS amount
FROM
arbitrum.core.fact_token_transfers
WHERE
from_address = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9' -- Distributor
AND contract_address = '0x912ce59144191c1204e64559fe8253a0e49e6548' -- ARB
)
SELECT
10000000000 AS "Initial Supply Cap",
recipients.users AS "Recipients",
claimers.users AS "Claimers",
"Claimers" / "Recipients" * 100 AS "User Share",
recipients.amount AS "Claimable Tokens",
claimers.amount AS "Claimed Tokens",
"Claimed Tokens" / "Claimable Tokens" * 100 AS "Token Share"
FROM
recipients, claimers
Run a query to Download Data