Monitize AIMOCA Claimants
Updated 2024-10-22
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
from_ADDRESS AS "Airdrop Address",
to_ADDRESS AS "Claimant",
MIN(RTRIM(BLOCK_TIMESTAMP::date)) AS "Claim Date",
SUM(amount) AS "Claimed Amount"
FROM ethereum.core.ez_token_transfers
WHERE contract_address = LOWER('0xF944e35f95E819E752f3cCB5Faf40957d311e8c5')
AND to_ADDRESS != LOWER('0x4c362f82d398625d9e328e1faaa573f8bba8e48c')
AND (from_ADDRESS = LOWER('0xDc066677B5ee2c577132b69ac13DA6cf8A50c1C7')
OR from_ADDRESS=LOWER('0x96a95810c7d28245f64d6e065584500328897531'))
GROUP BY from_ADDRESS,to_ADDRESS
ORDER BY "Claimed Amount" DESC
select
distinct CONTRACT_ADDRESS,
PLATFORM,
count(distinct tx_hash) as txs,
count(distinct ORIGIN_FROM_ADDRESS) as user,
count(distinct SENDER) as users,
sum(AMOUNT_IN_USD) as amount
from ethereum.defi.ez_dex_swaps
where (TOKEN_IN = LOWER('0xF944e35f95E819E752f3cCB5Faf40957d311e8c5') or TOKEN_OUT = LOWER('0xF944e35f95E819E752f3cCB5Faf40957d311e8c5'))
group by 1,2
/*
SELECT
from_ADDRESS AS "Airdrop Address",
to_ADDRESS AS "Claimant",
MIN(RTRIM(BLOCK_TIMESTAMP::date)) AS "Claim Date",
SUM(amount) AS "Claimed Amount"
FROM ethereum.core.ez_token_transfers
WHERE contract_address = LOWER('0xF944e35f95E819E752f3cCB5Faf40957d311e8c5')
AND to_ADDRESS != LOWER('0x4c362f82d398625d9e328e1faaa573f8bba8e48c')
AND (from_ADDRESS = LOWER('0xDc066677B5ee2c577132b69ac13DA6cf8A50c1C7')
OR from_ADDRESS=LOWER('0x96a95810c7d28245f64d6e065584500328897531'))
GROUP BY from_ADDRESS,to_ADDRESS
QueryRunArchived: QueryRun has been archived