No Data to Display
mamad-5XN3k3Most Popular Klaytn contracts copy
Updated 2025-04-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
›
⌄
⌄
with contracts as (
select
distinct contract_address,
min(block_timestamp) as min_date
from kaia.core.fact_event_logs
group by 1
)
/*select *
from(*/
select
--date_trunc('week', block_timestamp) as date,
--distinct contract_address,
case
when CONTRACT_ADDRESS = '0x2a85e9a06275c2df2a6ac13ecbdb8158412b9274' then 'WEMIX TOKEN (WEMIX)'
when CONTRACT_ADDRESS = '0xf50782a24afcb26acb85d086cf892bfffb5731b5' then 'SwapScanner'
when CONTRACT_ADDRESS = '0x68f762d28cebad501c090949e4680697e56848fc' then 'DragonSwap V3 Positions NFT'
when CONTRACT_ADDRESS = '0xf9d92bad7b1410dffb0a204b7aa418c9fd5a898f' then 'CN V2: Neopin 3'
when CONTRACT_ADDRESS = '0x77777779ee2d933da027ee1fb3590c41529046c8' then 'KLAYstation: Ozys V2'
when CONTRACT_ADDRESS = '0xe4c3f5454a752bddda18ccd239bb1e00ca42d371' then 'iKLAY(IKLAY)'
when CONTRACT_ADDRESS = '0x51d233b5ae7820030a29c75d6788403b8b5d317b' then 'KLAYswap V3 Positions NFT'
when CONTRACT_ADDRESS = '0xb0bb95ac3195a266ab924596ba32c2a10e245a95' then 'Staked KLAY(npKLAY)'
when CONTRACT_ADDRESS = '0xf6f6b8bd0ac500639148f8ca5a590341a97de0de' then 'Wrapped Klaytn(WKLAY)'
when CONTRACT_ADDRESS = '0xa1338309658d3da331c747518d0bb414031f22fd' then 'Kommune KLAY(KoKLAY)'
when CONTRACT_ADDRESS = '0x0000049f63ef0d60abe49fdd8bebfa5a68822222' then 'Mememorphosis(L2PASS)'
when CONTRACT_ADDRESS = '0xd85eff20288ca72ea9eecffb428f89ee5066ca5c' then 'Token IconISKRA TOKEN(ISK)'
when CONTRACT_ADDRESS = '0xd02ffae68d902453b44a9e45dc257aca54fb88b2' then 'Merkly ONFT(MERK)'
when CONTRACT_ADDRESS = '0x3012cc7a5a137362f97ab1fc69e61f927ac70973' then 'KlaySwap LP KLAY-PER(KSLP)'
when CONTRACT_ADDRESS = '0x6d8eeeeb90f8ba283aa8bef90c2f78e4aa191bf4' then 'Merkly OFT(MERK)'
when CONTRACT_ADDRESS = '0x34cf46c21539e03deb26e4fa406618650766f3b9' then 'KlaySwap LP KLAY-KSP(KSLP)'
when CONTRACT_ADDRESS = '0x79db0f1a83f8e743550eeb5dd5b0b83334f2f083' then 'LayerZero'
when CONTRACT_ADDRESS = '0x6d5b86eac9097ea4a94b2b69cd4854678b89f839' then 'DFK Item Bridge'
when CONTRACT_ADDRESS = '0x5b08ac39eaed75c0439fc750d9fe7e1f9dd0193f' then 'Mysticland Coin (MYTH)'
when CONTRACT_ADDRESS = '0xac6bea4ff99b5a911278e431af4dc922687aac70' then 'Silicon Stable (SI)'
when CONTRACT_ADDRESS = '0xee258ef5f4338b37e9ba9de6a56382adb32056e2' then 'DFK Hero Bridge'
when CONTRACT_ADDRESS = '0x5b08ac39eaed75c0439fc750d9fe7e1f9dd0193f' then 'Mysticland Coin (MYTH)'
Last run: 14 days ago
0
2B
1s