WITH SWAPS_TO AS (
Select date_trunc('day', block_timestamp) As DATE,
TOKEN_IN_AMOUNT,
Right(TOKEN_IN_CONTRACT, LEN(TOKEN_IN_CONTRACT)-19) AS TOKEN
FROM flow.core.fact_swaps )
SELECT Date, TOKEN, SUM(TOKEN_IN_AMOUNT) AS Volume
FROM SWAPS_TO
GROUP BY 1,2