boomer77thor_jgq2
Updated 2022-01-12
9
1
2
3
4
5
6
7
›
⌄
select date(block_timestamp) as dt, lp_action, pool_name,
count(distinct tx_id) as tx_count, case
when lp_action = 'remove_liquidity' then (tx_count* -1)
else tx_count end as transaction_count
from thorchain.liquidity_actions
where from_address = 'thor1hyarrh5hslcg3q5pgvl6mp6gmw92c4tpzdsjqg'
group by 1,2,3
Run a query to Download Data