alirsVelodrome Health-part-05
Updated 2022-08-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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 Date, sum(TOKEN0_AMOUNT_USD_n+TOKEN1_AMOUNT_USD_n) as liquidity_amount_USD,LP_ACTION
from base
group by DATE, LP_ACTION
Run a query to Download Data