drone-mostafaUntitled Query
Updated 2022-08-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT pool_name,
count(DISTINCT tx_hash) as TXNs,
count(DISTINCT origin_from_address) as Unique_Users,
sum(CASE
WHEN lp_action LIKE 'deposit' THEN LP_TOKEN_AMOUNT_USD
WHEN lp_action LIKE 'withdraw' THEN -1 * LP_TOKEN_AMOUNT_USD END )
as volume
FROM optimism.velodrome.ez_lp_actions
GROUP BY pool_name
Run a query to Download Data