discodolphinLido Raindrop Hunt
Updated 2021-11-11
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
›
⌄
select
left(block_timestamp :: date, 10) as block_date,
case
when tx_id = '8CEE4B43E68A929167D70AC9F8BB5BCDCF74310BAD53161B8B25407501A9656C' then ' 0: Minting bETH'
when tx_id = '5625787DFB6831AA030A76E4A137CA6F2EEA98ABE25E1D9266BB354AFCE17C60' then ' 1: Deposit bETH on Anchor'
when tx_id = '712D0D550B530E13B5BE8015142DE34B4F05138583F3957AB13E084BA5A51C1F' then ' 2: Borrow UST on Anchor'
when tx_id = '3E4680493B81241991D4ED8590584F2266C9C7A6AB82891A5F96837F1418BE66' then ' 3: Deposit UST on Anchor Earn'
end as Lido_event,
tx_id
from
terra.msgs
where
block_timestamp::date >= '2021-09-01'
and tx_status = 'SUCCEEDED'
and msg_index = 0
and tx_id in ('8CEE4B43E68A929167D70AC9F8BB5BCDCF74310BAD53161B8B25407501A9656C',
'5625787DFB6831AA030A76E4A137CA6F2EEA98ABE25E1D9266BB354AFCE17C60',
'712D0D550B530E13B5BE8015142DE34B4F05138583F3957AB13E084BA5A51C1F',
'3E4680493B81241991D4ED8590584F2266C9C7A6AB82891A5F96837F1418BE66')
order by
Lido_event
Run a query to Download Data