kakamoraTerra bETH Collaterals
    Updated 2021-09-21
    with beth_deposits AS (
    SELECT
    date(block_timestamp) as date,
    msg_value:execute_msg:send:amount / POW(10, 6) as beth_amount
    FROM terra.msgs
    WHERE
    msg_value:contract::string = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun'
    and msg_type = 'wasm/MsgExecuteContract'
    and msg_value:execute_msg:send:msg:deposit_collateral IS NOT NULL
    and tx_status = 'SUCCEEDED'
    and block_timestamp >= '2021-08-01'
    and beth_amount > 0
    )
    SELECT
    date,
    count(*) as txns,
    sum(beth_amount) as deposits
    FROM beth_deposits
    GROUP BY date
    Run a query to Download Data