glass_blossomsbLUNA and bETH in and outs
    Updated 2022-03-26
    with bluna_ins as (
    select
    date_trunc('day', block_timestamp) as date,
    sum((msg_value:execute_msg:lock_collateral:collaterals[0])[1]::string /1e6) as bluna_in,
    sum(bluna_in) over (order by date) as cum_bluna_in
    from terra.msgs
    where msg_value:contract = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8'
    and (msg_value:execute_msg:lock_collateral:collaterals[0])[0]::string = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' --bluna contract address
    and tx_status = 'SUCCEEDED' and msg_value:execute_msg:lock_collateral is not null
    group by date
    ),
    bluna_outs as (
    select
    date_trunc('day', block_timestamp) as date,
    sum(msg_value:execute_msg:withdraw_collateral:amount / 1e6) as bluna_out,
    sum(bluna_out) over (order by date) as cum_bluna_out
    from terra.msgs
    where msg_value:contract = 'terra1ptjp2vfjrwh0j0faj9r6katm640kgjxnwwq9kn' --bluna contract outs
    and tx_status = 'SUCCEEDED' and msg_value:execute_msg:withdraw_collateral is not null
    group by date
    ),
    beth_ins as (
    select
    date_trunc('day', block_timestamp) as date,
    sum((msg_value:execute_msg:lock_collateral:collaterals[0])[1]::string /1e6) as beth_in,
    sum(beth_in) over (order by date) as cum_beth_in
    from terra.msgs
    where msg_value:contract = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8'
    and (msg_value:execute_msg:lock_collateral:collaterals[0])[0]::string = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun' --beth contract address
    and tx_status = 'SUCCEEDED' and msg_value:execute_msg:lock_collateral is not null
    group by date),
    beth_outs as (
    select
    date_trunc('day', block_timestamp) as date,
    sum(msg_value:execute_msg:withdraw_collateral:amount / 1e6) as beth_out,
    sum(beth_out) over (order by date) as total_beth_withdraw
    Run a query to Download Data