-- minted tokens (inflow) for Ethereum

SELECT

DATE_TRUNC('day', ef.block_timestamp) AS day,

tx_hash,

origin_from_address,

'Ethereum' AS Type,

amount_precise AS minted_amount,

0 AS burned_amount

FROM ethereum.core.ez_token_transfers ef

WHERE contract_address = '0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf'

AND from_address = '0x0000000000000000000000000000000000000000'

UNION ALL

-- burned tokens (outflow) for Ethereum

SELECT

DATE_TRUNC('day', ef.block_timestamp) AS day,

tx_hash,

origin_from_address,

'Ethereum' AS Type,

0 AS minted_amount,

amount_precise AS burned_amount

FROM ethereum.core.ez_token_transfers ef

WHERE contract_address = '0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf'

AND to_address = '0x0000000000000000000000000000000000000000'

UNION ALL

-- minted tokens (inflow) for Base

SELECT

DATE_TRUNC('day', ef.block_timestamp) AS day,

tx_hash,

origin_from_address,

'Base' AS Type,

amount_precise AS minted_amount,