kakamoraTerra bETH Collaterals
Updated 2021-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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