select

from_label as dex,

block_timestamp::date as day,

count(tx_id) as number_of_swaps

from ethereum.udm_events

where day > '2022-01-31'

and day <= '2022-04-21'

and from_label_type = 'dex'

and origin_address = to_address

and to_address not LIKE lower('0x9008D19f58AAbD9eD0D60971565AA8510560ab41')

and from_address not LIKE ('0x9008D19f58AAbD9eD0D60971565AA8510560ab41')

and from_label_subtype = 'swap_contract'

and from_label not LIKE 'dex'

and from_label not LIKE '0x'

group by day, from_label

),

initial_data_two as

select

'cowswap' as dex,

block_timestamp::date as day,

count(tx_hash) AS number_of_swaps

from ethereum_core.fact_event_logs

where day > '2022-01-31'

and day <= '2022-04-21'

and event_inputs:from = lower('0x9008D19f58AAbD9eD0D60971565AA8510560ab41')

group by day

),

initial_data_final as

select * from initial_data_one

UNION

select * from initial_data_two