faraz-Lvyyy8analysis of top 3 token that swap to CRV by each other since first of the year
    Updated 2022-10-09
    with WETH as (
    select
    --SYMBOL_OUT as "token that swap to CRV",
    count(TX_HASH),
    date_trunc('day', block_timestamp) as date
    from ethereum.core.ez_dex_swaps
    where SYMBOL_IN = 'CRV'
    and SYMBOL_OUT = 'WETH'
    and BLOCK_TIMESTAMP >= '2022-01-01'
    GROUP by 2
    order by 2 desc
    )
    ,
    cvxCRV as (
    select
    --SYMBOL_OUT as "token that swap to CRV",
    count(TX_HASH),
    date_trunc('day', block_timestamp) as date
    from ethereum.core.ez_dex_swaps
    where SYMBOL_IN = 'CRV'
    and SYMBOL_OUT = 'cvxCRV'
    and BLOCK_TIMESTAMP >= '2022-01-01'
    GROUP by 2
    order by 2 desc
    ),
    USDC as (
    select
    --SYMBOL_OUT as "token that swap to CRV",
    count(TX_HASH),
    date_trunc('day', block_timestamp) as date
    from ethereum.core.ez_dex_swaps
    where SYMBOL_IN = 'CRV'
    and SYMBOL_OUT = 'USDC'
    and BLOCK_TIMESTAMP >= '2022-01-01'
    GROUP by 2
    order by 2 desc
    Run a query to Download Data