KARTODTHORChain - liquidity
Updated 2021-11-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH ALL_Address AS (
SELECT
--DATE_TRUNC ('day', block_timestamp) AS Days,
count(from_address) AS all_address
FROM thorchain.liquidity_actions WHERE lp_action = 'add_liquidity'
),
Remove_address AS (
SELECT
--DATE_TRUNC ('day', block_timestamp) AS Days,
count(from_address) AS remove_address
FROM thorchain.liquidity_actions WHERE lp_action = 'remove_liquidity'
)
SELECT
remove_address/all_address AS pct_address
FROM ALL_Address
LEFT JOIN Remove_address
Run a query to Download Data