flipside

    Getting Started With Marinade Finance Bounties
    adambalaGetting Started With Marinade Finance Bounties
    Updated 2022-03-15
    with table_1 as (select date_trunc('day', block_timestamp) as day,
    count(distinct(inner_instruction:instructions[1]:parsed:info:source)) as unique_wallets1
    from solana.events
    where instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
    and inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE'
    and block_timestamp >= '2022-03-01'
    and succeeded = 'TRUE'
    --and tx_id = '2LbYwrQfNzKzQLpsTWNnLYSvWk95szvwWaGofwxxBCwNqbxmbNQhrAhLnndYWw3MxxbwBXKxjyzDePeSDXwFu3sd'
    group by 1),

    --Deposits through Marinade referral program
    table_2 as (select date_trunc('day', block_timestamp) as day,
    count(distinct(inner_instruction:instructions[2]:parsed:info:source)) as unique_wallets2
    from solana.events
    where block_timestamp >= '2022-03-01'
    and inner_instruction:instructions[1]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE'
    and instruction:programId = 'mRefx8ypXNxE59NhoBqwqb3vTvjgf8MYECp4kgJWiDY'
    and succeeded = 'TRUE'
    --and tx_id = '5iF9jt3A61BkYPpGdC2Rs1rMKS8ifLtakoWnvL42PC6uiYMCjVeRvG5AZujCh6yp4HEKdVArVwcnEPjbn966ixT9'
    group by 1)

    select table_1.day,
    unique_wallets1 + unique_wallets2 as unique_wallets
    from table_1
    join table_2 on table_1.day = table_2.day
    group by 1,2
    order by 1
    Run a query to Download Data