with arbitrum as (select date_trunc('month',block_timestamp) as "Date", sum(amount_in_usd) as swap_volume_usd, count(distinct token_in) as token_sold_count,

count(distinct token_out) as token_bought_count, count(distinct origin_from_address) as swapper_count, count(distinct tx_hash) as swap_count,

sum(amount_in_usd)-sum(amount_out_usd) as difference_between_sales_purchases, 'Arbitrum' as "Chain"

from arbitrum.sushi.ez_swaps

group by 1

order by 1),

avalanche as (select date_trunc('month',block_timestamp) as "Date", sum(amount_in_usd) as swap_volume_usd, count(distinct token_in) as token_sold_count,

count(distinct token_out) as token_bought_count, count(distinct origin_from_address) as swapper_count, count(distinct tx_hash) as swap_count,

sum(amount_in_usd)-sum(amount_out_usd) as difference_between_sales_purchases, 'Avalanche' as "Chain"

from avalanche.sushi.ez_swaps

group by 1

order by 1),

ethereum as (select date_trunc('month',block_timestamp) as "Date", sum(amount_in_usd) as swap_volume_usd, count(distinct token_in) as token_sold_count,

count(distinct token_out) as token_bought_count, count(distinct origin_from_address) as swapper_count, count(distinct tx_hash) as swap_count,

sum(amount_in_usd)-sum(amount_out_usd) as difference_between_sales_purchases, 'Ethereum' as "Chain"

from ethereum.sushi.ez_swaps

group by 1

order by 1),

gnosis as (select date_trunc('month',block_timestamp) as "Date", sum(amount_in_usd) as swap_volume_usd, count(distinct token_in) as token_sold_count,

count(distinct token_out) as token_bought_count, count(distinct origin_from_address) as swapper_count, count(distinct tx_hash) as swap_count,

sum(amount_in_usd)-sum(amount_out_usd) as difference_between_sales_purchases, 'Gnosis' as "Chain"

from gnosis.sushi.ez_swaps

group by 1

order by 1),

optimism as (select date_trunc('month',block_timestamp) as "Date", sum(amount_in_usd) as swap_volume_usd, count(distinct token_in) as token_sold_count,

count(distinct token_out) as token_bought_count, count(distinct origin_from_address) as swapper_count, count(distinct tx_hash) as swap_count,

sum(amount_in_usd)-sum(amount_out_usd) as difference_between_sales_purchases, 'Optimism' as "Chain"

from optimism.sushi.ez_swaps

group by 1

order by 1),

polygon as (select date_trunc('month',block_timestamp) as "Date", sum(amount_in_usd) as swap_volume_usd, count(distinct token_in) as token_sold_count,

count(distinct token_out) as token_bought_count, count(distinct origin_from_address) as swapper_count, count(distinct tx_hash) as swap_count,

sum(amount_in_usd)-sum(amount_out_usd) as difference_between_sales_purchases, 'Polygon' as "Chain"

from polygon.sushi.ez_swaps