SELECT LOWER(address) AS address

FROM (

SELECT '0x7712c34205737192402172409a8f7ccef8aa2aec' AS address

UNION ALL

SELECT '0x6a9DA2D710BB9B700acde7Cb81F10F1fF8C89041'

UNION ALL

SELECT '0xA6525Ae43eDCd03dC08E775774dCAbd3bb925872'

UNION ALL

SELECT '0xa1CDAb15bBA75a80dF4089CaFbA013e376957cF5'

UNION ALL

SELECT '0x2893Ef551B6dD69F661Ac00F11D93E5Dc5Dc0e99'

UNION ALL

SELECT '0x53FC82f14F009009b440a706e31c9021E1196A2F'

)

),

mints_burns_aggregated AS (

SELECT chain, DATE_TRUNC('week', block_timestamp) AS week_date,

SUM(

CASE

WHEN from_address = '0x0000000000000000000000000000000000000000' THEN amount

WHEN to_address = '0x0000000000000000000000000000000000000000' THEN -amount

ELSE 0

END

) AS net_balance

FROM (

SELECT 'Ethereum' AS chain, block_timestamp, from_address, to_address, amount, contract_address FROM ethereum.core.ez_token_transfers

UNION ALL

SELECT 'Optimism', block_timestamp, from_address, to_address, amount, contract_address FROM optimism.core.ez_token_transfers

UNION ALL

SELECT 'Arbitrum', block_timestamp, from_address, to_address, amount, contract_address FROM arbitrum.core.ez_token_transfers

UNION ALL

SELECT 'Polygon', block_timestamp, from_address, to_address, amount, contract_address FROM polygon.core.ez_token_transfers

UNION ALL

SELECT 'Avalanche', block_timestamp, from_address, to_address, amount, contract_address FROM avalanche.core.ez_token_transfers