Ali3NFirst Destinations of Monad Users
    Updated 2025-02-26
    -- forked from Top First Destinations of Monad Users @ https://flipsidecrypto.xyz/studio/queries/693121f6-bcaa-403f-960d-c0b2ddcb0ff3

    with maintable as (
    select from_address,
    block_timestamp,
    to_address,
    tx_hash,
    tx_fee,
    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')


    select 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 Liquid Staking'
    when to_address = '0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e' then 'Chapter 1: Genesis NFT'
    when to_address = '0xfcc20dddb395dc684750a68933ad553ef8923266' then 'ERC20 Test Token'
    when to_address = '0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7' then 'Layer3 Cube'
    when to_address = lower ('0xe25c57fF3EeA05d0F8bE9aaAE3F522DdC803cA4E') then 'Monadverse Land NFT'
    when to_address = lower ('0x758D80767a751fc1634f579D76e1CcaAb3485c9c') then 'NAD Domains'
    when to_address = '0x800f8cacc990dda9f4b3f1386c84983ffb65ce94' then 'LaMouchNFT'
    when to_address = '0xd227d3bCE59b91380b7bc4A61A045B528B509439' then 'aiCraft.fun Vote'
    when to_address = lower ('0x88B96aF200c8a9c35442C8AC6cd3D22695AaE4F0') then 'Ambient Finance'
    when to_address = lower ('0xD7a24d1F1435CD314E86736E139f8431D4498D4e') then 'aPriori MON Faucet'
    when to_address = lower ('0xb2d64FA9A19eD9b653b70ae648AA70D1e9547e06') then 'Bean Exchange Swap'
    when to_address = lower ('0xCa810D095e90Daae6e867c19DF6D9A8C56db2c89') then 'Bean Exchange LP'
    when to_address = lower ('0x15e47CF518073bd980f10a1064231db14238858A') then 'Bima MON Faucet'
    when to_address = lower ('0xaC63A28044200Ceb0ff005725E65a2E431D7Eedf') then 'Bima USBD Pool'
    when to_address = lower ('0x2f930b339DE82F34FDbe54e872Eb4A2855B76EA2') then 'Curvance Faucet'
    when to_address = lower ('0xA8dC4371856188185689958244CcA0a6e389eDF6') then 'Curvance Deposit'
    when to_address = lower ('0x40BbC2eB72f5427027fc8E2501872D1c352d1672') then 'Curvance Lending'
    QueryRunArchived: QueryRun has been archived