binhachonSaber and daoSOL
    Updated 2022-02-17
    with add_liquidity_transactions as (
    select
    block_timestamp::date as blocktime,
    inner_instruction:instructions[2]:parsed:info:account::string as account,
    inner_instruction:instructions[2]:parsed:info:amount/1e9 as amount
    from solana.events
    where block_timestamp::date >= '2021-12-19'
    and inner_instruction:instructions[2]:parsed:type::string = 'mintTo'
    and inner_instruction:instructions[2]:parsed:info:mint::string = 'monKYjV2bHTjbJVWCCcwhxE8C96sdTKR2HUNUHCjh4z'
    and inner_instruction:instructions[2]:programId::string = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
    ),
    add_liquidity as (
    select
    blocktime,
    sum(amount) as amount,
    count(distinct account) as number_of_liquidity_providers
    from add_liquidity_transactions
    group by blocktime
    ),
    remove_liquidity_transactions as (
    select
    block_timestamp::date as blocktime,
    inner_instruction:instructions[2]:parsed:info:account::string as account,
    inner_instruction:instructions[2]:parsed:info:amount/1e9 as amount
    from solana.events
    where block_timestamp::date >= '2021-12-19'
    and inner_instruction:instructions[2]:parsed:info:mint::string = 'monKYjV2bHTjbJVWCCcwhxE8C96sdTKR2HUNUHCjh4z'
    and inner_instruction:instructions[2]:programId::string = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
    and inner_instruction:instructions[2]:parsed:type::string = 'burn'
    ),
    remove_liquidity as (
    select
    blocktime,
    sum(amount) as amount,
    count(distinct account) as number_of_liquidity_withdrawers
    from remove_liquidity_transactions
    Run a query to Download Data