SajjadiiiUntitled Query
    Updated 2022-09-19
    with eth_markets as (
    select
    distinct contract_address
    from ethereum.core.fact_event_logs
    where 1=1
    and origin_function_signature = '0xfa18022c' -- prepareMiso
    and event_name = 'AuctionWalletUpdated'
    -- and tx_hash = '0x79a6e43a80bff6db671bfff8cbee46ac46d612c8ef282b1cb9ba1bc134890d38'
    order by contract_address
    ),
    eth_commit_txns as (
    select *
    from ethereum.core.fact_event_logs
    where 1=1
    and ((origin_function_signature = '0xdc97e082' and event_name = 'Transfer')
    or (origin_function_signature = '0x29762960' and event_name = 'AddedCommitment'))
    -- and tx_hash = '0x6e5b522ebca252f40384bc23d9301723f10c4c3b3c58ab1bbe3439dc4df00bf4'
    and origin_to_address in (select contract_address from eth_markets)
    ),
    bsc_markets as (
    select
    distinct contract_address
    from bsc.core.fact_event_logs
    where 1=1
    and origin_function_signature = '0xfa18022c' -- prepareMiso
    and event_name = 'AuctionWalletUpdated'
    -- and tx_hash = '0x79a6e43a80bff6db671bfff8cbee46ac46d612c8ef282b1cb9ba1bc134890d38'
    order by contract_address
    ),
    bsc_commit_txns as (
    select *
    from bsc.core.fact_event_logs
    where 1=1
    and ((origin_function_signature = '0xdc97e082' and event_name = 'Transfer')
    Run a query to Download Data