CONTRACT_NAME | TRANSACTION_COUNT | |
|---|---|---|
1 | Other Contract | 13848104 |
2 | Wrapped Ether | 3762270 |
3 | UniswapV3Pool | 404644 |
4 | ZNS Connect | 214285 |
5 | Uniswap V3 Positions NFT-V1 | 164471 |
6 | Kraken | 81989 |
7 | EndpointV2 | 78304 |
8 | ReceiveUln302 | 54499 |
9 | SquidSwap | 21539 |
picasot-tx
Updated 2025-04-06
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
CASE
WHEN CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000006' THEN 'Wrapped Ether'
WHEN CONTRACT_ADDRESS = '0xfb2cd41a8aec89efbb19575c6c48d872ce97a0a5' THEN 'ZNS Connect'
WHEN CONTRACT_ADDRESS = '0xd5aa1bd330a94332f071da5bb3651ec372ea6926' THEN 'UniswapV3Pool'
WHEN CONTRACT_ADDRESS = '0xc0836e5b058bbe22ae2266e1ac488a1a0fd8dce8' THEN 'Uniswap V3 Positions NFT-V1'
WHEN CONTRACT_ADDRESS = '0xd0a60907f65ac19f61b7636606e1c4e33d055c24' THEN 'UniswapV3Pool'
WHEN CONTRACT_ADDRESS = '0xaa2712ef69803b515dd17de24e3bab7882dddb64' THEN 'UniswapV3Pool'
WHEN CONTRACT_ADDRESS = '0xca5f2ccbd9c40b32657df57c716de44237f80f05' THEN 'Kraken'
WHEN CONTRACT_ADDRESS = '0xca29f3a6f966cb2fc0de625f8f325c0c46dbe958' THEN 'EndpointV2'
WHEN CONTRACT_ADDRESS = '0xbf0cafcbaaf0be8221ae8d630500984edc908861' THEN 'SquidSwap'
WHEN CONTRACT_ADDRESS = '0x473132bb594caef281c68718f4541f73fe14dc89' THEN 'ReceiveUln302'
ELSE 'Other Contract'
END AS CONTRACT_NAME,
COUNT(*) AS transaction_count
FROM
ink.core.ez_decoded_event_logs
WHERE
CONTRACT_ADDRESS IS NOT NULL
GROUP BY
CASE
WHEN CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000006' THEN 'Wrapped Ether'
WHEN CONTRACT_ADDRESS = '0xfb2cd41a8aec89efbb19575c6c48d872ce97a0a5' THEN 'ZNS Connect'
WHEN CONTRACT_ADDRESS = '0xd5aa1bd330a94332f071da5bb3651ec372ea6926' THEN 'UniswapV3Pool'
WHEN CONTRACT_ADDRESS = '0xc0836e5b058bbe22ae2266e1ac488a1a0fd8dce8' THEN 'Uniswap V3 Positions NFT-V1'
WHEN CONTRACT_ADDRESS = '0xd0a60907f65ac19f61b7636606e1c4e33d055c24' THEN 'UniswapV3Pool'
WHEN CONTRACT_ADDRESS = '0xaa2712ef69803b515dd17de24e3bab7882dddb64' THEN 'UniswapV3Pool'
WHEN CONTRACT_ADDRESS = '0xca5f2ccbd9c40b32657df57c716de44237f80f05' THEN 'Kraken'
WHEN CONTRACT_ADDRESS = '0xca29f3a6f966cb2fc0de625f8f325c0c46dbe958' THEN 'EndpointV2'
WHEN CONTRACT_ADDRESS = '0xbf0cafcbaaf0be8221ae8d630500984edc908861' THEN 'SquidSwap'
WHEN CONTRACT_ADDRESS = '0x473132bb594caef281c68718f4541f73fe14dc89' THEN 'ReceiveUln302'
ELSE 'Other Contract'
END
ORDER BY
transaction_count DESC;
Last run: 22 days ago
9
224B
2s