elsinaUntitled Query
    Updated 2022-09-08
    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