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'
    Last run: about 2 months ago
    DESTINATION
    USERS
    1
    Uniswap477271
    2
    Fantasy USD256792
    3
    OPEN EDITION CHOGSTAR232112
    4
    0x2a0d96bc211ec8cdc61c92ba6204bf2df228caba162450
    5
    0x18c9534dfe16a0314b66395f48549716fff9aa66101117
    6
    0x836047a99e11f376522b447bffb6e3495dd0637c84291
    7
    Chapter 1: Genesis NFT83745
    8
    0x8462c247356d7deb7e26160dbfab16b351eef24271939
    9
    0x436ee7219bb099f71c9db9c7de8862a9bde891ae70672
    10
    0xd97bce4518b886a36e345764333d77b5faf6fe2c60519
    11
    NAD Domains59880
    12
    aPriori Monad Liquid Staking59621
    13
    Bean Exchange LP26883
    14
    0xcbe623d259261ffa0cfaff44484bff46c1b7d6c225195
    15
    Ambient Finance23257
    16
    0x66b655de495268eb4c7b70bf4ac1ab4094589f9321939
    17
    0xe302573df83276f943e1cc96ac524d26c26ab10116084
    18
    Morkie Monad NFT15854
    19
    Curvance Faucet15745
    20
    Kuru Swap15108
    ...
    1000
    49KB
    7s