SELECT

SYMBOL_OUT as pair_asset,

MONTH(BLOCK_TIMESTAMP) as month,

SUM(AMOUNT_IN) as volume_in

FROM ethereum.core.ez_dex_swaps

WHERE SYMBOL_IN = 'CRV'

AND not SYMBOL_OUT = 'WETH'

AND BLOCK_TIMESTAMP > '{{start_date}}'

AND month = {{month}}

GROUP BY SYMBOL_OUT, MONTH(BLOCK_TIMESTAMP)

ORDER BY volume_in desc

LIMIT 5

),

swaps_out as (

SELECT

SYMBOL_IN as pair_asset,

MONTH(BLOCK_TIMESTAMP) as month,

SUM(AMOUNT_OUT) as volume_out

FROM ethereum.core.ez_dex_swaps

WHERE SYMBOL_OUT = 'CRV'

AND not SYMBOL_IN = 'WETH'

AND BLOCK_TIMESTAMP > '{{start_date}}'

AND month = {{month}}

GROUP BY SYMBOL_IN, MONTH(BLOCK_TIMESTAMP)

ORDER BY volume_out desc

LIMIT 5

SELECT

swaps_in.month,

swaps_in.pair_asset,

sum(volume_in),

sum(volume_out),

sum(volume_in + volume_out) as total_volume