Top Monad Contracts 2 copy

mamad-5XN3k3Top Monad Contracts 2 copy

Updated 3 days ago

-- forked from Top Monad Contracts 2 @ https://flipsidecrypto.xyz/studio/queries/5b154475-4b4b-447d-8647-0484cfae96a6

-- forked from Top Monad Contracts 1 @ https://flipsidecrypto.xyz/studio/queries/f42bdc7a-10d5-40c8-90b3-332eec8beae7

with contractt as (

select

address,

symbol,

name

from monad.testnet.dim_contracts

)

select

case when tx_rank <= 8 then label else 'other' end as contract_tx,

case when user_rank <= 8 then label else 'other' end as contract_user,

case when fee_rank <= 8 then label else 'other' end as contract_fee,

from(

select

distinct contract_address,

case

when contract_address = '0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7' then 'Pump4gains'

when contract_address = '0x8462c247356d7deb7e26160dbfab16b351eef242' then 'Wrapping and Unwrapping Monad'

when contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' then 'Wrapped Monad (WMON)'

when contract_address = '0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0' then 'Uniswap'

when contract_address = '0xca810d095e90daae6e867c19df6d9a8c56db2c89' then 'Bean DEX'

when contract_address = '0xb33d7138c53e516871977094b249c8f2ab89a4f4' then 'OPEN EDITION CHOGSTAR'

when contract_address = '0xbb444821e159dd6401bb92fb18c2ac0a37113025' then 'FANTASY USD'

when contract_address = '0xb2f82d0f38dc453d596ad40a37799446cc89274a' then 'aPriori Monad LST'

when contract_address = '0x2a0d96bc211ec8cdc61c92ba6204bf2df228caba' then 'EMMY ON MONAD'

when contract_address = '0x758d80767a751fc1634f579d76e1ccaab3485c9c' then 'Nad Name Service'

when contract_address = '0x836047a99e11f376522b447bffb6e3495dd0637c' then 'ETH'

when contract_address = '0x436ee7219bb099f71c9db9c7de8862a9bde891ae' then 'Monad x Alchemy'

when contract_address = '0xc816865f172d640d93712c68a7e1f83f3fa63235' then 'Kuru'

when contract_address = '0xf6ffe4f3fdc8bbb7f70ffd48e61f17d1e343ddfd' then 'IZUMI Swap'

Last run: 3 days ago

	CONTRACT_TX	CONTRACT_USER	CONTRACT_FEE	CONTRACT_ADDRESS	LABEL	TXS	PAID_FEE	USERS	TX_RANK	USER_RANK	FEE_RANK
1	other	other	other	0xba0facfb8fd4971be4765eb336136bcf7e524ba2	0xba0facfb8fd4971be4765eb336136bcf7e524ba2	220319	11056.625862154	32149	87	182	40
2	other	other	other	0x14742dba465304a68084ca83e0b1221715b6e659	0x14742dba465304a68084ca83e0b1221715b6e659	731	3.609973485	567	2120	1982	2517
3	other	other	other	0x73c03bc8f8f094c61c668ae9833d7ed6c04fdc21	0x73c03bc8f8f094c61c668ae9833d7ed6c04fdc21	8312	25.649352044	5365	467	450	813
4	other	other	other	0x73fb3429032e1e19a50d86462892bf884b3cc2f9	0x73fb3429032e1e19a50d86462892bf884b3cc2f9	3797	41.244580677	3356	673	558	650
5	other	other	other	0x0ec3e6d5aa197f9d3ca0e7e9521204f7dc42c04f	0x0ec3e6d5aa197f9d3ca0e7e9521204f7dc42c04f	482	5.5700102	368	2525	2360	2130
6	other	other	other	0x9442e24203e999db4ae87e35dc0c8f3c610c29a0	0x9442e24203e999db4ae87e35dc0c8f3c610c29a0	36941	795.407159441	1728	243	1006	215
7	other	other	other	0x0ea460b7b876009b5ab296fa752293793c0c053b	0x0ea460b7b876009b5ab296fa752293793c0c053b	102	3.23395127	101	4483	4418	2616
8	other	other	other	0x005ab6afaa95ad49b3ed08226dc59a889395466c	0x005ab6afaa95ad49b3ed08226dc59a889395466c	172	4.065187801	102	3756	4361	2411
9	other	other	other	0xbae6acbaee7b0785085a856e4cfe18aaddae7f76	0xbae6acbaee7b0785085a856e4cfe18aaddae7f76	2954	18.506630802	2775	793	646	1043
10	other	other	other	0xcd2ade9312372852bd2beb957c02321616b81a26	0xcd2ade9312372852bd2beb957c02321616b81a26	1000	26.291178131	206	1853	3008	800
11	other	other	other	0xae2aead8d1bbc7551633359ada38132509bca2f5	0xae2aead8d1bbc7551633359ada38132509bca2f5	437	2.384227421	380	2633	2331	2865
12	other	other	other	0x940d351678b73c44dcdb20ff4995f3653cee4863	0x940d351678b73c44dcdb20ff4995f3653cee4863	154	0.3653838562	136	3900	3664	4289
13	other	other	other	0x503e0229f51b8b04c187436883b2a8c34adc4631	0x503e0229f51b8b04c187436883b2a8c34adc4631	581	3.045492643	362	2351	2383	2670
14	other	other	other	0xfbfd213933fb3cb1ab75b603baa823fffb5bdb27	0xfbfd213933fb3cb1ab75b603baa823fffb5bdb27	109	0.286234	104	4416	4297	4407
15	other	other	other	0xa81d122ad586ab60573694f7805556a92efafa9b	0xa81d122ad586ab60573694f7805556a92efafa9b	1316	10.988868659	1151	1589	1447	1500
16	other	other	other	0x50ff23e9a8d5dac05744c367c9ddd588d027982b	0x50ff23e9a8d5dac05744c367c9ddd588d027982b	28744	778.567243576	18434	281	251	217
17	other	other	other	0xeb784975287cb3705bd4d4f1b5d2a28966b2d7db	0xeb784975287cb3705bd4d4f1b5d2a28966b2d7db	3499	30.301715231	2183	701	801	735
18	other	other	other	0xd80fde1b1a9f2a1c47100798d9d38f321a559f6e	0xd80fde1b1a9f2a1c47100798d9d38f321a559f6e	220131	618.391785364	23377	88	215	241
19	other	other	other	0x0d9065aa58962e695ee804ee7de2ee47c62d69ea	0x0d9065aa58962e695ee804ee7de2ee47c62d69ea	160	0.8040590092	134	3842	3696	3847
20	other	other	other	0xb0e1f6d26b5065a1fa078d373a0e46fbc7a2b1e4	0xb0e1f6d26b5065a1fa078d373a0e46fbc7a2b1e4	340	6.349200437	230	2937	2877	2001

...

4485

664KB

125s