SELECT DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS MONTHLY, 'OPTIMISM TO EHTHEREUM' AS BRIDGE, 'USDC' AS TOKEN, SUM(AMOUNT) as AMOUNT, SUM(AMOUNT_USD) as AMOUNT_USD

FROM ethereum.core.ez_token_transfers

WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-1'

AND ORIGIN_TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- OPTIMISM TO EHTHEREUM

AND SYMBOL = 'USDC'

GROUP BY MONTHLY

UNION

SELECT DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS MONTHLY, 'OPTIMISM TO EHTHEREUM' AS BRIDGE, 'USDT' AS TOKEN, SUM(AMOUNT) as AMOUNT, SUM(AMOUNT_USD) as AMOUNT_USD

FROM ethereum.core.ez_token_transfers

WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-1'

AND ORIGIN_TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- OPTIMISM TO EHTHEREUM

AND SYMBOL = 'USDT'

GROUP BY MONTHLY

UNION

SELECT DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS MONTHLY, 'OPTIMISM TO EHTHEREUM' AS BRIDGE, 'DAI' AS TOKEN, SUM(AMOUNT) as AMOUNT, SUM(AMOUNT_USD) as AMOUNT_USD

FROM ethereum.core.ez_token_transfers

WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-1'

AND ORIGIN_TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- OPTIMISM TO EHTHEREUM

AND SYMBOL = 'DAI'

GROUP BY MONTHLY

UNION

SELECT DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS MONTHLY, 'EHTHEREUM TO OPTIMISM' AS BRIDGE, 'USDC' AS TOKEN, SUM(AMOUNT) as AMOUNT, SUM(AMOUNT_USD) as AMOUNT_USD

FROM ethereum.core.ez_token_transfers

WHERE BLOCK_TIMESTAMP::DATE >= '2022-01-1'

AND ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1' -- EHTHEREUM TO OPTIMISM

AND SYMBOL = 'USDC'

GROUP BY MONTHLY