DATE_TRUNC('quarter', LAST_ACTIVITY_BLOCK_TIMESTAMP) AS quarter,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f') THEN CURRENT_BAL ELSE 0 END) AS GHO_ETH,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0x6c3ea9036406852006290770bedfcaba0e23a0e8') THEN CURRENT_BAL ELSE 0 END) AS PYUSD_ETH,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0xdAC17F958D2ee523a2206206994597C13D831ec7') THEN CURRENT_BAL ELSE 0 END) AS USDT_ETH,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48') THEN CURRENT_BAL ELSE 0 END) AS USDC_ETH,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0x6b175474e89094c44da98b954eedeac495271d0f') THEN CURRENT_BAL ELSE 0 END) AS DAI_ETH,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0xc5f0f7b66764f6ec8c8dff7ba683102295e16409') THEN CURRENT_BAL ELSE 0 END) AS FDUSD_ETH,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0x4c9edd5852cd905f086c759e8383e09bff1e68b3') THEN CURRENT_BAL ELSE 0 END) AS USDE_ETH,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0x0c10bf8fcb7bf5412187a595ab97a3609160b5c6') THEN CURRENT_BAL ELSE 0 END) AS USDD_ETH,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0x853d955acef822db058eb8505911ed77f175b99e') THEN CURRENT_BAL ELSE 0 END) AS FRAX_ETH,

SUM(CASE WHEN CONTRACT_ADDRESS = LOWER('0x0000000000085d4780b73119b644ae5ecd22b376') THEN CURRENT_BAL ELSE 0 END) AS TUSD_ETH,

FROM ethereum.core.ez_current_balances

WHERE CONTRACT_ADDRESS IN (

LOWER('0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f'),

LOWER('0x6c3ea9036406852006290770bedfcaba0e23a0e8'),

LOWER('0xdAC17F958D2ee523a2206206994597C13D831ec7'),

LOWER('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'),

LOWER('0x6b175474e89094c44da98b954eedeac495271d0f'),

LOWER('0xc5f0f7b66764f6ec8c8dff7ba683102295e16409'),

LOWER('0x4c9edd5852cd905f086c759e8383e09bff1e68b3'),

LOWER('0x0c10bf8fcb7bf5412187a595ab97a3609160b5c6'),

LOWER('0x853d955acef822db058eb8505911ed77f175b99e'),

LOWER('0x0000000000085d4780b73119b644ae5ecd22b376')

GROUP BY DATE_TRUNC('quarter', LAST_ACTIVITY_BLOCK_TIMESTAMP)

ORDER BY quarter;