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