amelia-leeFIRSSSSSSSSSSSSSSSST
    Updated 2022-12-01
    WITH
    CLAIM AS (SELECT * FROM ethereum.core.ez_token_transfers WHERE CONTRACT_ADDRESS = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f' AND FROM_ADDRESS = '0xe50b2ceac4f60e840ae513924033e753e2366487')

    SELECT EVENT_NAME, COUNT (DISTINCT L.TX_HASH) AS TXN, COUNT (DISTINCT L.ORIGIN_FROM_ADDRESS) AS USERS
    FROM ethereum.core.fact_event_logs L
    LEFT JOIN CLAIM C ON C.TO_ADDRESS = L.ORIGIN_FROM_ADDRESS
    WHERE L.TX_HASH NOT IN (SELECT TX_HASH FROM CLAIM) AND L.CONTRACT_ADDRESS = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f'
    AND L.BLOCK_TIMESTAMP < CURRENT_DATE -1 AND EVENT_NAME IS NOT NULL
    AND L.BLOCK_TIMESTAMP > C.BLOCK_TIMESTAMP
    GROUP BY 1

    /*
    SELECT COUNT (DISTINCT TX_HASH) AS TXN, COUNT (DISTINCT TO_ADDRESS) AS USERS
    FROM ethereum.core.ez_token_transfers WHERE CONTRACT_ADDRESS = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f' AND FROM_ADDRESS = '0xe50b2ceac4f60e840ae513924033e753e2366487'
    */
    Run a query to Download Data