KaskoazulPRISM Scavenger TX in Block
Updated 2022-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
block_id,
--date_trunc('MINUTE', block_timestamp),
count (tx_id),
CASE tx_id
WHEN '360751456618BA6D2D8E99BD57B02DE12A90F97AE6D81CC7E613C320851C8737' then 'Refract to yLUNA/pLUNA'
WHEN '3ED868E63F66028C675783F36D6BE19C8B5C8A4D0A90D42F9B2076D2F547C27D' then 'yLUNA/PRISM Swap'
WHEN '990BA1887F0790EDB5204365A4D8752097E283C645934C57BCA211150723D20F' then 'LP pLUNA-PRISM'
ELSE 'Not_my_tx'
END AS label
FROM
terra.transactions
WHERE
block_id in (6690820, 6690810, 6690800)
GROUP BY 1, 3
Run a query to Download Data