LTirrellthor_hunt
Updated 2022-04-08
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 (
'EF0BD45F473B5100ADD7407FC378A5B9B7D63F281947D1B97463FEB05F0C83D5'
) then 'Supply RUNE to the RUNE-UST pool'
else null
end as Description,
tx_id
from
thorchain.liquidity_actions
where
tx_id in (
'EF0BD45F473B5100ADD7407FC378A5B9B7D63F281947D1B97463FEB05F0C83D5'
)
and datetime > '2022-04-06'
group by
datetime,
Description,
tx_id
order by
Description
Run a query to Download Data