alirsopbvl-02
Updated 2022-09-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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 >= '2022-07-07' and date <= '2022-08-04' and LP_ACTION='deposit'
order by 1)
select sum(TOKEN0_AMOUNT_USD_n+TOKEN1_AMOUNT_USD_n) as liquidity_amount_USD, Token_Pairs
from base
group by Token_Pairs
order by liquidity_amount_USD DESC
limit 10
Run a query to Download Data