WITH minting_wallets AS (
SELECT
DISTINCT(ORIGIN_FROM_ADDRESS) AS wallets
FROM
base.core.fact_event_logs
WHERE
ORIGIN_TO_ADDRESS = lower('0x07f4ae64f236eacf81b4d798f0c6daf9d29e9cf3')
)
SELECT
SUM(ETH_VALUE) AS bridged_eth
FROM
ethereum.core.fact_transactions
WHERE
TO_ADDRESS = lower('0x49048044D57e1C92A77f79988d21Fa8fAF74E97e')
AND
FROM_ADDRESS IN (SELECT wallets FROM minting_wallets)
AND
BLOCK_TIMESTAMP >= '2023-08-01 20:00:00' -- mint starting date/time in UTC