MLDZMNcubiuser3
    Updated 2023-07-26
    select
    case
    when transfer.tx_to='EJLdiLBgdZQ8j8ANawZqpb9iB2t3NP3iVCeh3JA8Ft3s' then 'CAVYAR'
    when transfer.tx_to='xoEhFjEinwKbAtPWRUGePcvbd8ZnQ3gYynyguHwrBr9' then 'Cubik'
    when transfer.tx_to='4wdY2XpJKRRxWmDdEHPKgHSPaE5bUJnCSjjw65eFf2x4' then 'Fetcch'
    when transfer.tx_to='5yWszmTvoiWhJ2X1gdvkUtwzowxeDuCQSeSwwZqpx7oA' then 'Soda'
    when transfer.tx_to='2LYpAa2F55jimCbdKrKjZE4AFTbAs4r3oBTUY2QjFe6g' then 'Re:naissance'
    when transfer.tx_to='B7NTVBcFpXvuT3K6Lk54vmkemNhWwr7VAtGTVNnSyXhS' then 'Session Keys'
    when transfer.tx_to='Ea6sE5JYweU7W6wRkwfRw74HrNC36RJhttXk7r4wGkcs' then 'Solsend'
    when transfer.tx_to='73AJG869PUntaUyZ8H2tDKd74wZ6QVYHqMD3n6on9PAS' then 'Arsnal'
    when transfer.tx_to='9LDTG2zYanqvxHiGQsGxCvAxsAfBcGhdCwFjtWiDhZjY' then 'StartOnWormhole'
    when transfer.tx_to='8ijGsQBJqy8H2BFHsafRARth9LQSiXNjTdautKsvbtDY' then 'Tinydancer'
    when transfer.tx_to='HtfqrZ6CY1VMbfJtRxXzZkp9a74eLKHdt6Bc7vasj2Kk' then 'OpenBook'
    when transfer.tx_to='6eiQJAjq8Vo2WyCaoP35uTSbCzggV4av83uj2VdDayDQ' then 'GraphQLana'
    when transfer.tx_to='DRYFVFfBBcavxRZEtKUz9oAt7TPJ9W17AX2bSJZUpzXB' then 'SIMD research'
    when transfer.tx_to='9tusixcaw3Qv6ZbFGQGxz5G5Jeh7k26RqegkRbEZo1CA' then 'Solex'
    when transfer.tx_to='xoEhFjEinwKbAtPWRUGePcvbd8ZnQ3gYynyguHwrBr9' then 'Solana Unity SDK'
    when transfer.tx_to='5TtrUDiHGP3TjeQmcBZu2FLCzBeUzUgsaPBh9THrbYGT' then 'Saganize'
    when transfer.tx_to='CEfbK6rugjYyEzzfUissPiGNbBvZGXymuVomxvXNLp1m' then 'HotKeys'
    when transfer.tx_to='6vBdbXsaetZpuqFvAW4m9VktjikKKhowQk6PkSU9SduN' then 'SolDisperse'
    when transfer.tx_to='GBA264tMDtgypmMgb5DZuzQW2aBx4cgzsD8JvCnZtjSF' then 'Phase Labs'
    when transfer.tx_to='7Eammqr9HC5HhaRhy6XoFZSyXcWmWugLrykXaeBbxaC1' then 'AnchorPy'
    when transfer.tx_to='G2rz6P2figvjyoueX22AkqgL8vJCAoURTeTSzF8LRNK9' then 'Solathon'
    when transfer.tx_to='5dUakZngdms3U87mYa2H4tNkdr6ueLvhK5adhjuvFy1J' then 'Espresso Cash'
    end as projects,
    sum(transfer.amount) as total_volume
    from solana.core.fact_transactions s
    join (select distinct block_timestamp, tx_id
    from solana.core.fact_events where succeeded = True
    and program_id = 'SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu') events -- Squad MultiSig Program
    using(tx_id, block_timestamp)
    join (select *
    from solana.core.fact_transfers where mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') transfer
    using(tx_id, block_timestamp)
    where BLOCK_TIMESTAMP>='2023-06-15' --between '2023-06-23' and '2023-07-03'
    and transfer.tx_from='5bn8VFUS2UKZ1uAR1tSsmq67GvxKFpNB87WSiRHhq2Vs'
    Run a query to Download Data