OneDataAnalystTokens Swapped for ON FLOW
    Updated 2022-06-20
    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
    Run a query to Download Data