greyswanbonk selling flows
    Updated 2024-02-20
    with raw as (
    select
    swap_to_mint,
    sum(swap_from_amount) as bonk_sold,
    count(distinct swapper) as users,
    count (tx_id) as txs
    from
    solana.defi.fact_swaps
    where
    swap_from_mint = '27G8MtK7VtTcCHkpASjSDdkWWYfoqT6ggEuKidVJidD4'
    and BLOCK_TIMESTAMP >= current_date - 5
    group by
    swap_to_mint
    order by
    sum(swap_from_amount) desc
    ),
    raw1 as (
    select
    token_name,
    swap_to_mint,
    bonk_sold,
    users,
    txs
    from
    raw
    left join solana.core.dim_tokens on swap_to_mint = TOKEN_ADDRESS
    )
    select
    token_name,
    --bonk_sold / sum(bonk_sold) as share,
    bonk_sold,
    users,
    txs,
    swap_to_mint
    from
    raw1
    Last run: 12 months ago
    TOKEN_NAME
    BONK_SOLD
    USERS
    TXS
    SWAP_TO_MINT
    1
    USDC3967496.2686346953596EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v
    2
    Tether1130720.0108682131059Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB
    3
    Wrapped Solana1033377.77140616134055So11111111111111111111111111111111111111112
    4
    Jupiter232852.933923340595JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN
    5
    BlazeStake Staked SOL98065.4275633843bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1
    6
    dogwifhat61649.7756383559EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm
    7
    Wrapped BTC (Wormhole)47347.437145211203NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh
    8
    Ethereum (Wormhole)34112.99589521837vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs
    9
    Render28222.4256672383rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof
    10
    Jito26467.9287282959jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL
    11
    Popcat26384.12304141017GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr
    12
    Nosana23421.3967252862nosXBVoaCTtYdLvKY6Csb4AC8JCdQKKAaWYtx2ZMoo7
    13
    Whales Market22858.5835754277GTH3wG3NErjwcf7VGCoXEXkgXSHvYhx5gtATeeM5JAS1
    14
    Dither19930.02453126169E1kvzJNxShvvWTrudokpzuc789vRiDXfXG3duCuY6ooE
    15
    Pyth Network19226.22178785117HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3
    16
    Shadow Token17585.0860972544SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y
    17
    Wen16094.59105473140WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk
    18
    Bonk15909.39087380104DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263
    19
    Marinade staked SOL7449.8349351624mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So
    20
    tBTC7157.305472336DNSN2BJsaPFdFFc1zP37kkeNe4Usc1Sqkzr9C9vPWcU
    ...
    212
    15KB
    10s