adam10Anchor Mariner Hunt
Updated 2021-09-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select left(block_timestamp::date,10) as block_date
,tx_id
, case when tx_id in ('328075252D38048DEA7394B3C28BB3F64969159955540A308F9E5E87E4385141') then 'Deposit UST to Anchor'
when tx_id in ('C5FEF81070443D74790AF9095696B7B9F105F6DBCB493DEBB44AE6DBF563AAF7') then 'Borrow UST from Anchor Market'
when tx_id in ('890DBA94F50D5B2EF15AA9BE6BD2B265B28A771CB5742AFF24761D6D63B5F6F2') then 'Provide bLuna'
when tx_id in ('F0763345A744C6C110A878478CA751BD8288A51F059715E8DBF6EAF128EEEBFB') then 'Swap Luna for bLUNA'
else null end as Tx_Description
from terra.msgs
where tx_id in ('328075252D38048DEA7394B3C28BB3F64969159955540A308F9E5E87E4385141'
,'C5FEF81070443D74790AF9095696B7B9F105F6DBCB493DEBB44AE6DBF563AAF7'
,'890DBA94F50D5B2EF15AA9BE6BD2B265B28A771CB5742AFF24761D6D63B5F6F2'
,'F0763345A744C6C110A878478CA751BD8288A51F059715E8DBF6EAF128EEEBFB'
)
group by 1,2,3
order by 3
Run a query to Download Data