alirsopbvl-02
    Updated 2022-09-02
    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