0xasmrUntitled Query
    Updated 2022-08-14
    SELECT
    CASE WHEN origin_function_signature = '0x53a8aa03' THEN 'GPL_minted' ELSE 'GPL_redeemed' END AS actions,
    COUNT(DISTINCT(origin_from_address)) AS no_of_users
    FROM avalanche.core.fact_token_transfers
    WHERE origin_function_signature IN ('0x53a8aa03' , '0x0f3aa554')
    AND block_timestamp > CURRENT_DATE() - interval '3 months'
    GROUP BY 1
    Run a query to Download Data