MLDZMNBehavior of Mavia Airdrop claimers - order by highest received volume
Updated 2025-01-15
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
›
⌄
-- forked from marqu / Jupiter Airdrop - Claimers Leaderboard - Top 5,000 @ https://flipsidecrypto.xyz/marqu/q/arcsoNwueoEf/jupiter-airdrop---claimers-leaderboard---top-5-000
with
aggregated as (
select
distinct ORIGIN_FROM_ADDRESS as claimer,
sum(AMOUNT_PRECISE) as total_mavia,
min(BLOCK_TIMESTAMP) as first_claim
from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS = '0x7ad4c1647aa947d1c05425a8d4d155ef811a5f9e'
and CONTRACT_ADDRESS = '0x24fcfc492c1393274b6bcd568ac9e225bec93584'
and ORIGIN_FUNCTION_SIGNATURE = '0x497de662'
group by 1
),
swap_activity as (
select
claimer,
sum(iff(TOKEN_IN = '0x24fcfc492c1393274b6bcd568ac9e225bec93584', AMOUNT_IN, 0)) as swap_from_amount,
sum(iff(TOKEN_OUT = '0x24fcfc492c1393274b6bcd568ac9e225bec93584', AMOUNT_OUT, 0)) as swap_to_amount
from ethereum.defi.ez_dex_swaps s
inner join aggregated
on s.ORIGIN_FROM_ADDRESS = aggregated.claimer
where (TOKEN_IN = '0x24fcfc492c1393274b6bcd568ac9e225bec93584'
or TOKEN_OUT = '0x24fcfc492c1393274b6bcd568ac9e225bec93584')
group by 1
),
transfer_activity as (
QueryRunArchived: QueryRun has been archived