CONTRACT_NAME | USER_COUNT | |
---|---|---|
1 | Wrapped Flow | 1376 |
2 | PunchSwap V2 | 1071 |
3 | Bridged USDC (Celer) | 867 |
4 | GreenConChicken | 506 |
5 | Avocado | 425 |
6 | 0xfd734fa1970f2750a4e54e4f12c54e670fda80ba | 421 |
7 | pump.flow | 403 |
8 | BETA | 340 |
9 | 0x576be17f4dfa0e4964034e2e3dd29465b225b8d4 | 211 |
10 | Ankr Staked FLOW EVM | 211 |
yasmin4 copy
Updated 2025-01-26
999
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
CASE
WHEN LOWER(contract_address) IN (
'0x4b07f2d19028a7fb7bf5e9258f9666a9673da331',
'0x5656c4972827e93e921bcfe6d60148720fce8b55',
'0xe41572a814d660d13b97d5bd33fbb4850b85b421',
'0x21faa90e0c1ca27c1896b96942b1459cce01cb46'
) THEN 'PunchSwap V2'
WHEN LOWER(contract_address) = '0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e' THEN 'Wrapped Flow'
WHEN LOWER(contract_address) = '0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52' THEN 'Bridged USDC (Celer)'
WHEN LOWER(contract_address) = '0x4bd2a1649e5698f97a1ab0515ee407ebc8a3abe7' THEN 'GreenConChicken'
WHEN LOWER(contract_address) = '0x995258cea49c25595cd94407fad9e99b81406a84' THEN 'Avocado'
WHEN LOWER(contract_address) = '0x68eb683a393c8a1c816255b4fc4b89d73c52ad4b' THEN 'pump.flow'
WHEN LOWER(contract_address) = '0xd8ad8ae8375aa31bff541e17dc4b4917014ebdaa' THEN 'BETA'
WHEN LOWER(contract_address) = '0x1b97100ea1d7126c4d60027e231ea4cb25314bdb' THEN 'Ankr Staked FLOW EVM'
ELSE LOWER(contract_address)
END AS contract_name,
COUNT(DISTINCT origin_from_address) AS user_count
FROM flow.core_evm.fact_event_logs
GROUP BY contract_name
ORDER BY user_count DESC
LIMIT 10;
-- Wrapped Flow 0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e
-- Bridged USDC (Celer) 0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52
-- PunchSwap V2 0x4b07f2d19028a7fb7bf5e9258f9666a9673da331----
-- GreenConChicken 0x4bd2a1649e5698f97a1ab0515ee407ebc8a3abe7
-- Avocado 0x995258cea49c25595cd94407fad9e99b81406a84
-- 0x68eb683a393C8a1C816255b4FC4B89d73C52AD4b
Last run: 20 days ago
10
276B
1s