SELECT

date_trunc('month', block_timestamp) as month4,

sum(amount_usd) as ethv4

FROM ethereum.dex_swaps

WHERE to_address = lower('0x1bD435F3C054b6e901B7b108a0ab7617C808677b')

group by 1 order by 1),

ethv5 as (

SELECT

date_trunc('month', block_timestamp) as month5,

sum(amount_usd) as ethv5

FROM ethereum.dex_swaps

WHERE to_address = lower('0xdef171fe48cf0115b1d80b88dc8eab59176fee57')

group by 1 order by 1),

polyv4 as (

SELECT

date_trunc('month', block_timestamp) as monthp4,

sum(amount_usd) as polv4

FROM polygon.udm_events

WHERE to_address = lower('0x90249ed4d69d70e709ffcd8bee2c5a566f65dade')

AND tx_id NOT IN ('0x3059c39ba73fe6a4c19529225f34d3a5bee7764c128cf287f6640296bd70c600',

'0xaef4062580db877bae497140f2aa891855ec2d875c23d804b648f33eb51514ca',

'0xb17bdea4c498e360511d6d328e589ef9f2c07e04c0d1d7db9f939e74870020a8',

'0x55f6f2f79fd2ae013ca52230b5d218509de5e4c3e901cf7cfe5dd536608d0b7e')

group by 1 order by 1),

polyv5 as (

SELECT

date_trunc('month', block_timestamp) as monthp5,

sum(amount_usd) as polv5

FROM polygon.udm_events

WHERE to_address = lower('0xdef171fe48cf0115b1d80b88dc8eab59176fee57')

group by 1 order by 1)

SELECT month4, nvl(ethv4,0) + nvl(ethv5,0) as eth_volume ,nvl(polv4,0) + nvl(polv5,0) as polygon_volume, nvl(eth_volume,0) + nvl(polygon_volume,0) as total_volume

FROM ethv4 v4