elsinaUntitled Query
Updated 2022-09-08
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
iff(tx_json:receipt:logs[0]:decoded:inputs:owner is null, tx_json:receipt:logs[0]:decoded:inputs:from, tx_json:receipt:logs[0]:decoded:inputs:owner) as seller,
from_address as buyer,
to_address as marketplace,
eth_value as price,
tx_json:receipt:logs[0]:address as collection
from arbitrum.core.fact_transactions
where tx_hash = '0x7f4e18e43e6bdcad60a93ad3f03798194134b198a09a5cbad5b19761a86a7f55' and
to_address = '0x7bc8b1b5aba4df3be9f9a32dae501214dc0e4f3f' and
origin_function_signature = '0xba847759' and
tx_json:receipt:logs[0]:address != '0x82af49447d8a07e3bd95bd0d56f35241523fbab1'
Run a query to Download Data