week(f.BLOCK_TIMESTAMP) AS date,

SUM(f.AMOUNT / power(10, DECIMALS)) AS total_amount,

count(DISTINCT tx_ID) AS transfers,

count(DISTINCT TX_FROM) AS transferers,

t.SYMBOL

FROM solana.core.fact_transfers f

JOIN solana.core.dim_tokens t

ON f.MINT = t.TOKEN_ADDRESS

WHERE YEAR(f.BLOCK_TIMESTAMP) = 2022

AND token_address in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX')

GROUP BY week(f.BLOCK_TIMESTAMP), t.SYMBOL