bobby_danielmodest-silver
    Updated 2025-04-02
    with labels as (
    Select
    Address,
    Address_name,
    From solana.core.dim_labels
    ),

    swap_raw as (
    Select
    BLOCK_TIMESTAMP::date as day,
    SWAP_PROGRAM,
    TX_ID,
    SWAPPER,
    SWAP_FROM_AMOUNT,
    SWAP_FROM_MINT,
    l.address_name as swap_from_mint_name,
    SWAP_TO_AMOUNT,
    SWAP_TO_MINT,
    m.address_name as swap_to_mint_name,
    case when Swap_from_mint = 'So11111111111111111111111111111111111111112' then 'Sold'
    when swap_to_mint = 'So11111111111111111111111111111111111111112' then 'Bought' end as category
    From solana.defi.fact_swaps s
    Left Join labels l on l.address = s.SWAP_FROM_MINT
    Left Join labels m on m.address = s.SWAP_TO_MINT
    Where
    Block_timestamp >= '2025-03-01'
    AND SUCCEEDED = 'TRUE'
    AND ( SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112' or SWAP_TO_MINT = 'So11111111111111111111111111111111111111112' )
    Group by all
    )

    Select
    day,
    category
    From swap_raw
    Limit 10
    Last run: 2 months ago
    ADDRESS
    ADDRESS_NAME
    1
    3LfHzbwohxdqFqwU4injRUQZdYMWfocMY77UwCEbwZJvbinance deposit_wallet
    2
    2DStCx88HGLZdAcRgKuWGuhwobPmMZZkfgro8yA3NS5Pkucoin deposit_wallet
    3
    3x4FuhKvE3PVifJ2wq7xSHYit6snmViP9vJyAV935HoPcoinbase deposit_wallet
    4
    8DBAKNA8qnzbZKpqFKfXJcGGQzvFdVrXdpyTh8MpxBsaswissborg deposit_wallet
    5
    Gcutfz5iEjfCoqeePkYk5JMV8z5WdTwmiWrdAMMhUSivkucoin deposit_wallet
    6
    UGNmLxqjF1qQ1psbtKZXRUSWkUYZw6w5pph7QxoZKFVkucoin deposit_wallet
    7
    4Rw9VR6CwH1YWyTvzHKkL3XryzxusW6BAX2BmbnaDo71gate.io deposit_wallet
    8
    4bYFdh2mg6Mh8dduw3eZv1YgJDHAXLvqzF4ySq3tHV9Fcoinbase deposit_wallet
    9
    GKkTJsZk9wTwhxPMDhGAK35WZDTRBZpcmQNW8dTWMzgKcrypto.com deposit_wallet
    10
    6jDNe4EcdYYBDCZrb7nxaz3BwnVwnHAkvdwykYgHPE5kcoinbase deposit_wallet
    10
    745B
    2s