select
left(block_timestamp :: date, 10) as block_date,
case
when TX_ID in (
'03B25A2606E0025E93DD379B571EAD2B03719B9062957D65AAEE9C18E107A4A1'
) then 'Swap Rune for BTC (BEP-2)'
else null
end as Description,
TX_ID
from
thorchain.swaps
where
TX_ID in (
'03B25A2606E0025E93DD379B571EAD2B03719B9062957D65AAEE9C18E107A4A1'
)
group by
1,
2,
3
order by
2
-- select * from thorchain.swaps
-- LIMIT 50