discodolphinAnchor Mariner Hunt
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
case
when tx_id = '5625787DFB6831AA030A76E4A137CA6F2EEA98ABE25E1D9266BB354AFCE17C60' then ' 1: Supply bETH as collateral'
when tx_id = '36A606B6684404A5295BBCBE33CA3E598DB2D31928482E487F8189DDFBA69123' then ' 0: Stake ANC'
when tx_id = 'DED51C4EF3ED3F1D03291BF274074E241CAD1CEDA339E6C7491FE0B4C730B663' then ' 2: Take out a loan'
end as anchor_event,
tx_id
from
terra.msgs
where
block_timestamp::date >= '2021-08-21'
and tx_status = 'SUCCEEDED'
and msg_index = 0
and tx_id in ('5625787DFB6831AA030A76E4A137CA6F2EEA98ABE25E1D9266BB354AFCE17C60',
'36A606B6684404A5295BBCBE33CA3E598DB2D31928482E487F8189DDFBA69123',
'DED51C4EF3ED3F1D03291BF274074E241CAD1CEDA339E6C7491FE0B4C730B663')
order by
anchor_event
Run a query to Download Data