PapasotYieldly daily staking (volume)
    Updated 2023-01-02
    -- original analyst adriaparcerisas
    -- https://app.flipsidecrypto.com/dashboard/yieldly-staking-pool-GHNNQX
    -- The SQL query was adjusted for another bounty submission about YDLY staking


    with
    add_liquidity as (
    select
    block_id,
    sum(asset_amount/1e6) as liquidity_in from algorand.asset_transfer_transaction where asset_receiver='FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY' and asset_transferred ='226701642' and asset_amount<1e11 and asset_amount is not null
    group by 1
    ),
    remove_liquidity as (
    select
    block_id,
    sum(asset_amount/1e6) as liquidity_out from algorand.asset_transfer_transaction where sender='FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY' and asset_transferred ='226701642' and asset_amount<1e11 and asset_amount is not null
    group by 1
    ),
    datetimes as (
    SELECT
    block_timestamp,
    block_id
    from algorand.block
    ),
    total_liquidity as (
    select
    block_timestamp,
    liquidity_in as liqin,
    liquidity_out as liqout
    from add_liquidity x
    left outer join remove_liquidity y on x.block_id = y.block_id
    left outer join datetimes z on x.block_id = z.block_id
    )
    SELECT
    trunc(block_timestamp,'day') as date,
    sum(liqin) as liquidity_in,
    Run a query to Download Data