Abbas_ra21Untitled Query
Updated 2022-08-28
9
1
2
3
4
5
6
7
8
›
⌄
with withdraw_TX AS (select * from arbitrum.core.fact_event_logs
where CONTRACT_ADDRESS='0x794a61358d6845594f94dc1db02a252b5b4814ad'
and TOPICS[0] = '0x2b627736bca15cd5381dcf80b0bf11fd197d01a037c52b927a881a10fb73ba61')
select DISTINCT PROJECT_NAME,ADDRESS_NAME,LABEL_SUBTYPE,LABEL_TYPE
from arbitrum.core.fact_token_transfers inner join arbitrum.core.dim_labels on ADDRESS=CONTRACT_ADDRESS
where TX_HASH in (select TX_HASH from withdraw_TX) and FROM_ADDRESS=ORIGIN_FROM_ADDRESS
limit 10
Run a query to Download Data