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