select from_address,

block_timestamp,

tx_hash,

to_address,

row_number () over (partition by from_address order by block_timestamp asc) as rn

from monad.testnet.fact_transactions

where block_timestamp >= '2025-02-19'),

t2 as (

select block_timestamp::date as date,

case when to_address = '0xb33d7138c53e516871977094b249c8f2ab89a4f4' then 'OPEN EDITION CHOGSTAR'

when to_address = '0xbb444821e159dd6401bb92fb18c2ac0a37113025' then 'Fantasy USD'

when to_address = lower ('0x760AfE86e5de5fa0Ee542fc7B7B713e1c5425701') or to_address = lower ('0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7') then 'Uniswap'

when to_address = lower ('0x0b29Cef134e58e4B47F070D4b307DA50AA1b77DA') then 'Owlto ERC20 Contract Creation'

when to_address = lower ('0x6FD94C28a955ABB6Db0C1ABC4e81128e2C847252') then 'Owlto Basic Contract Creation'

when to_address = '0x79911986ff0dd4b83ca241eccc2edca31c056cd9' then 'Morkie Monad NFT'

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

when to_address = '0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e' then 'Chapter 1: Genesis NFT'

when to_address = '0xfcc20dddb395dc684750a68933ad553ef8923266' then 'ERC20 Test Token'

when to_address = '0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7' then 'Layer3 Cube'

else to_address end as destination,

count (distinct tx_hash) as Transactions,

count (distinct from_address) as Users,

row_number () over (partition by date order by users desc) as rn

from t1

where rn = '1'

and to_address is not null

group by 1,2 )

select *

from t2

where rn <= 3