banterlyticsHumba poap
Updated 2023-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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