adambalaUntitled Query
Updated 2022-09-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
ss.tx_hash, ETH_VALUE ,
event_inputs:tokenId
FROM optimism.core.fact_event_logs as ss inner join optimism.core.fact_transactions as tt
on ss.tx_hash=tt.tx_hash
WHERE 1 = 1
--and tx_hash = '0x5cb4b187491d971bfe0a61f8b0d7fbef2e5e49b5554f6e9b7a344d72d7c40317'
--and ss.origin_function_signature = '0x42842e0e' -- sale
--and event_name = 'Transfer'
and contract_address = lower('0x5c9D55b78FEBCC2061715BA4f57EcF8EA2711F2c')
and event_inputs:from = origin_from_address
order by 2 desc
Run a query to Download Data