glass_blossomsbLUNA and bETH in and outs
Updated 2022-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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