LTirrellspectrum_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
24
25
26
27
28
29
30
›
⌄
select
date_trunc("day", block_timestamp ::date) as datetime,
case
when tx_id in (
'635FB825ACFD4EC88665EF746197AFE51D1EAF6806D516F1438D2E8170BF2F22'
) then '1. Provide liquidity to the bLUNA-LUNA autocompounding pool on Spectrum'
when tx_id in (
'5F685C95F16D708F067998137028FE6475D4C81D4D90EFFF69FC709CC283229B'
) then '2. Trade UST for SPEC'
when tx_id in (
'2A5FA1171720EBB8FBA86431E7BD5158A07DD798B05E1FB77A60DC2A1DDEE39D'
) then '3. Deposit SPEC into governance'
else null
end as Description,
tx_id
from
terra.msgs
where
tx_id in (
'635FB825ACFD4EC88665EF746197AFE51D1EAF6806D516F1438D2E8170BF2F22',
'5F685C95F16D708F067998137028FE6475D4C81D4D90EFFF69FC709CC283229B',
'2A5FA1171720EBB8FBA86431E7BD5158A07DD798B05E1FB77A60DC2A1DDEE39D'
)
and datetime > '2022-01-25'
group by
datetime,
Description,
tx_id
order by
Description
Run a query to Download Data