binhachonFinancial Imagineering: Anchor Protocol - Yield reserve external transfer
    Updated 2022-01-28
    with Anchor_yield_reserve_external_transfer as (
    select
    date_trunc('quarter', block_timestamp) as blocktime,
    sum(
    case
    when event_from = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8' then -event_amount_usd
    else event_amount_usd end
    ) as amount_received
    from terra.transfers
    where (event_from = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8' or event_to = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8')
    group by blocktime
    )
    select
    *
    from Anchor_yield_reserve_external_transfer
    order by blocktime desc
    Run a query to Download Data