PROJECT_NAME | COUNT(*) | |
|---|---|---|
1 | aave | 44383 |
2 | beefy finance | 23709 |
3 | benqi finance | 2471 |
4 | gmx | 1558 |
5 | platypus | 973 |
mattkstewDEFI Whales 4
Updated 2025-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
project_name,
count(*)
from avalanche.core.ez_decoded_event_logs left outer join avalanche.core.dim_labels
on contract_address = address
where origin_from_address in ('0x013b646fe54562a3ff6e3469fcc8c4efc2337656', '0x77134cbc06cb00b66f4c7e623d5fdbf6777635ec', '0xd464ecbd0c16169c098abd367124c3e4ee46a9f5','0xa1dd9d42425cb0e096428fe583ed157115d60511',
'0x3de0de4e7417253c92fcdbb0e72e0230554c9024', '0x51af494f1b4d3f77835951fa827d66fc4a18dae8','0xcdc8bbc2c740e44e9231dc3a8842800aa2433d18',
'0x46f80018211d5cbbc988e853a8683501fca4ee9b','0xd275e5cb559d6dc236a5f8002a5f0b4c8e610701','0x4aefa39caeadd662ae31ab0ce7c8c2c9c0a013e8',
'0x0e0100ab771e9288e0aa97e11557e6654c3a9665','0x00e39085c877328619fdb2a47d995c516a5fa869', '0x1bc2efcc22e22d7d380b58b2736f9b6144c1e34a',
'0x1c634af3d63e62fd4b1236e891573ffa88bf5f6f', '0x3a23f943181408eac424116af7b7790c94cb97a5', '0x3d40b3cf4194866e636b490df675a1a3a6bfdf4a',
'0x4aefa39caeadd662ae31ab0ce7c8c2c9c0a013e8', '0x4e95c70321055fa370767e230f30aca620bc0de0','0x7731f8df999a9441ae10519617c24568dc82f697', '0x73f9b272abda7a97cb1b237d85f9a7236edb6f16')
and label_type like 'defi'
and project_name is not null
and event_Name in ('Transfer', 'Withdraw', 'Supply', 'Borrow', 'Swap')
group by 1
order by 2 desc
limit 5
Last run: about 1 month ago
5
93B
22s