select 'Ethereum' as blockchain, 'https://etherscan.io/' as link_prefix union all

select 'BSC', 'https://bscscan.com/' union all

select 'Polygon', 'https://polygonscan.com/' union all

select 'Gnosis', 'https://gnosisscan.io/' union all

select 'Arbitrum', 'https://arbiscan.io/' union all

select 'Avalanche', 'https://avascan.info/blockchain/c/' union all

select 'Optimism', 'https://optimistic.etherscan.io/' union all

select 'Fantom', 'https://ftmscan.com/'

),

oneinch_contracts as (

select *

from (values

('0xe4c577bdec9ce0f6c54f2f82aed5b1913b71ae2f'), -- 1inch - exchange v1

('0x0000000006adbd7c01bc0738cdbfc3932600ad63'), -- 1inch - exchange v2

('0x0000000053d411becdb4a82d8603edc6d8b8b3bc'), -- 1inch - exchange v3

('0x000005edbbc1f258302add96b5e20d3442e5dd89'), -- 1inch - exchange v4

('0x0000000f8ef4be2b7aed6724e893c1b674b9682d'), -- 1inch - exchange v5

('0x111112549cfedf7822eb11fbd8fd485d8a10f93f'), -- 1inch - exchange v6

('0x111111254b08ceeee8ad6ca827de9952d2a46781'), -- 1inch - exchange v7

('0x11111254369792b2ca5d084ab5eea397ca8fa48b'), -- 1inch V1 - Aggregation Router V1

('0x111111125434b319222cdbf8c261674adb56f3ae'), -- 1inch V2 - Aggregation Router V2

('0x11111112542d85b3ef69ae05771c2dccff4faa26'), -- 1inch V3 - Aggregation Router V3

('0x1111111254fb6c44bac0bed2854e76f90643097d'), -- 1inch V4 - Aggregation Router V4

('0x1111111254eeb25477b68fb85ed929f73a960582') -- 1inch V4 - Aggregation Router V5

) as t(address)

),

oneinch as (

select blockchain as blockchain_1inch

, pool_address as pool_1inch

, count(*) as exchanges_1inch

from crosschain.defi.ez_swaps

where tx_to in (select * from oneinch_contracts)

and block_timestamp > dateadd('day', -{{period}}, current_timestamp())