date_trunc('day', block_timestamp) as date,

count(distinct(tx_hash)) as n_swaps,

sum(amount_in_usd) as volume,

'Ethereum' as label

from flipside_prod_db.crosschain.ez_swaps

where date >= '2022-05-04' and date <= '2022-05-13'

and (symbol_in = 'SUSHI' or symbol_out = 'SUSHI')

and blockchain = 'Ethereum'

group by date),

harmony as (select

date_trunc('day', block_timestamp) as date,

count(distinct(tx_hash)) as n_swaps,

sum(amount_in_usd) as volume,

'Harmony' as label

from flipside_prod_db.crosschain.ez_swaps

where date >= '2022-05-04' and date <= '2022-05-13'

and (symbol_in = '1SUSHI' or symbol_out = '1SUSHI')

and blockchain = 'Harmony'

group by date),

polygon as (select

date_trunc('day', block_timestamp) as date,

count(distinct(tx_id)) as n_swaps,

sum(amount_usd) as volume,

'Polygon' as label

from flipside_prod_db.polygon.udm_events

where date >= '2022-05-04' and date <= '2022-05-13'

and contains(to_address_name, 'SUSHI')

group by date)

select * from eth

union

select * from harmony

union