flipside

    number of users who swap from Flow in May
    msafadoostnumber of users who swap from Flow in May
    Updated 2022-06-27
    SELECT date(BLOCK_TIMESTAMP),
    COUNT(DISTINCT(TRADER))
    FROM flow.core.fact_swaps
    WHERE BLOCK_TIMESTAMP >= '2022-05-01'
    AND BLOCK_TIMESTAMP < '2022-06-01'
    AND TOKEN_IN_CONTRACT LIKE 'A.1654653399040a61.FlowToken'
    GROUP by 1
    ORDER by 2 DESC
    Run a query to Download Data