ramishoowUntitled Query
    Updated 2022-09-18
    WITH ramishoow AS ( SELECT concat('0x', replace(regexp_substr(INPUT_DATA, '0xde2ea948000000000000000000000000(........................................)'), '0xde2ea948000000000000000000000000')) AS wallet_address
    FROM avalanche.core.fact_transactions WHERE ORIGIN_FUNCTION_SIGNATURE = '0xde2ea948' AND BLOCK_TIMESTAMP >= CURRENT_DATE - 6 ) SELECT COUNT(DISTINCT wallet_address) AS USERS FROM ramishoow



    Run a query to Download Data