barbodAnchor Emissions
Updated 2022-02-24
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
distinct msg_value:sender as user_address,
sum (msg_value:execute_msg:borrow_stable:borrow_amount) / 1e6 as borrow_amount_UST
from terra.msgs
where msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'
and msg_value:execute_msg:borrow_stable is not NULL
and tx_status = 'SUCCEEDED'
and block_timestamp >= CURRENT_DATE - 90
group by 1
order by 2 DESC
Run a query to Download Data