boomer77Untitled Query
Updated 2021-12-12
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('day', block_timestamp) as dt,
msg_value:contract::string as asset, case
when asset = 'terra1ptjp2vfjrwh0j0faj9r6katm640kgjxnwwq9kn' then 'bLUNA'
when asset = 'terra10cxuzggyvvv44magvrh3thpdnk9cmlgk93gmx2' then 'bETH'
else null end as bAsset,
sum(msg_value:execute_msg:withdraw_collateral:amount/1e6) as amount
from terra.msgs
where msg_value:execute_msg:withdraw_collateral is not null and tx_status = 'SUCCEEDED'
group by 1,2
Run a query to Download Data