LTirrellAnchor_hunt
Updated 2022-01-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
date_trunc("day", block_timestamp ::date) as datetime,
case
when tx_id in (
'43503C501507DBD4AF52ED37A69D4CF00047E9EFD9DEBCCB63712223250B03D1'
) then '1. Deposit UST into Anchor Earn'
else null
end as Description,
tx_id
from
terra.msgs
where
tx_id in (
'43503C501507DBD4AF52ED37A69D4CF00047E9EFD9DEBCCB63712223250B03D1'
)
and datetime > '2022-01-25'
group by
datetime,
Description,
tx_id
order by
Description
Run a query to Download Data