discodolphinPylon Hunt
Updated 2021-10-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
left(block_timestamp :: date, 10) as block_date,
case
when tx_id = '0C3C2901293E772FAEEA35B49057B250E1A4BF95E124C0F0EA6B45E98FAEFE4C' then ' 0: Swap UST for MINE'
when tx_id = '1EAA441A2EEAF35114AF628CCFF9A331EACEA641D7C271EAA5594942E3A8968B' then ' 1: Stake MINE on Pylon'
end as Pylon_event,
tx_id
from
terra.msgs
where
block_timestamp::date >= '2021-10-01'
and tx_status = 'SUCCEEDED'
and msg_index = 0
and tx_id in ('0C3C2901293E772FAEEA35B49057B250E1A4BF95E124C0F0EA6B45E98FAEFE4C',
'1EAA441A2EEAF35114AF628CCFF9A331EACEA641D7C271EAA5594942E3A8968B')
order by
Pylon_event
Run a query to Download Data