banterlyticsHumba poap
    Updated 2023-06-06
    select
    EVENT_INPUTS:tokenId as tokenId,
    regexp_substr_all(SUBSTR(INPUT_DATA, 11, len(INPUT_DATA)), '.{64}') AS segmented_data,
    ethereum.public.udf_hex_to_int(segmented_data[0])::integer as eventid,
    CONCAT('0x', SUBSTR((segmented_data[1]), 25, len((segmented_data[1])))) AS wallet
    from gnosis.core.fact_transactions ft
    LEFT OUTER JOIN gnosis.core.fact_event_logs fel ON
    ft.tx_hash=fel.tx_hash
    where ft.block_timestamp::date > '2023-04-11'
    and ft.TO_ADDRESS = lower('0x22c1f6050e56d2876009903609a2cc3fef83b415')
    and ft.ORIGIN_FUNCTION_SIGNATURE = lower('0xa140ae23')
    and eventid = 117425
    and EVENT_INPUTS:tokenId is not null
    order by tokenId ASC

    Run a query to Download Data