alirsVelodrome Health-part-06
Updated 2022-08-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with base as (select block_timestamp::date as Date,LP_ACTION,
IFF(TOKEN0_AMOUNT_USD IS NULL, TOKEN1_AMOUNT_USD,TOKEN0_AMOUNT_USD) as TOKEN0_AMOUNT_USD_n,
IFF(TOKEN1_AMOUNT_USD IS NULL, TOKEN0_AMOUNT_USD, TOKEN1_AMOUNT_USD) as TOKEN1_AMOUNT_USD_n
-- IFF(TOKEN0_SYMBOL IS NULL, TOKEN0_ADDRESS, TOKEN0_SYMBOL) as TOKEN0_SYMBOL_n,
-- IFF(TOKEN1_SYMBOL IS NULL, TOKEN1_ADDRESS, TOKEN1_SYMBOL) as TOKEN1_SYMBOL_n,
-- CONCAT(TOKEN0_SYMBOL_n, '-', TOKEN1_SYMBOL_n) as Token_Pairs
from optimism.velodrome.ez_lp_actions
where Date>CURRENT_DATE-30 )
select sum(TOKEN0_AMOUNT_USD_n+TOKEN1_AMOUNT_USD_n) as liquidity_amount_USD,'deposit' as lp_Action_type
from base
where LP_ACTION='deposit'
UNION ALL
select sum(TOKEN0_AMOUNT_USD_n+TOKEN1_AMOUNT_USD_n) as liquidity_amount_USD,'withdraw' as lp_Action_type
from base
where LP_ACTION='withdraw'
Run a query to Download Data