SELECT

CONCAT('Ethereum') AS chain,

DATE_TRUNC('month', block_timestamp::date) AS month,

SUM(amount_usd) AS total_usd

FROM ethereum.core.ez_eth_transfers

WHERE eth_to_address = '0x4d73adb72bc3dd368966edd0f0b2148401a178e2'

GROUP BY chain, month

),

avalanche AS (

SELECT

CONCAT('Avalanche') AS chain,

DATE_TRUNC('month', block_timestamp::date) AS month,

SUM(amount_usd) AS total_usd

FROM avalanche.core.ez_avax_transfers

WHERE avax_to_address = '0x4d73adb72bc3dd368966edd0f0b2148401a178e2'

GROUP BY chain, month

),

polygon AS (

SELECT

CONCAT('Polygon') AS chain,

DATE_TRUNC('month', block_timestamp::date) AS month,

SUM(amount_usd) AS total_usd

FROM polygon.core.ez_matic_transfers

WHERE matic_to_address = '0x4d73adb72bc3dd368966edd0f0b2148401a178e2'

GROUP BY chain, month

),

bsc AS (

SELECT

CONCAT('BSC') AS chain,

DATE_TRUNC('month', block_timestamp::date) AS month,

SUM(amount_usd) AS total_usd

FROM bsc.core.ez_bnb_transfers