MahrooUntitled Query
    Updated 2022-09-19
    (WITH ethCte AS
    (SELECT distinct event_inputs:addr::string AS contract_auction
    FROM ethereum.core.fact_event_logs
    WHERE event_name = 'MarketCreated'
    AND origin_to_address = '0x7603a35af5cf10b113f167d424eb75bb7062c8ce')
    SELECT 'Ethereum' AS chain, count (distinct origin_from_address) as users, count (distinct tx_hash) as txs
    from ethereum.core.fact_event_logs
    where origin_to_address in (select contract_auction from ethCte)
    and origin_function_signature in ('0x29762960','0xdc97e082'))
    UNION ALL
    (with polyCte as
    (select distinct event_inputs:addr::string as contract_auction
    from polygon.core.fact_event_logs
    where event_name = 'MarketCreated'
    and origin_to_address = '0xc040f84cf7046409f92d578ef9040fe45e6ef4be')
    select'Polygon' as chain, count (distinct origin_from_address) as users, count (distinct tx_hash) as txs
    from polygon.core.fact_event_logs
    where origin_to_address in (select contract_auction from polyCte)
    and origin_function_signature in ('0x29762960','0xdc97e082'))
    UNION ALL
    (with bscCte as
    (select distinct event_inputs:addr::string as contract_auction
    from bsc.core.fact_event_logs
    where event_name = 'MarketCreated'
    and origin_to_address = '0x5629ce74ddcad7cc72b3ea30444da7172ad851d9')
    select 'BSC' as chain, count (distinct origin_from_address) as users, count (distinct tx_hash) as txs
    from bsc.core.fact_event_logs
    where origin_to_address in (select contract_auction from bscCte)
    and origin_function_signature in ('0x29762960','0xdc97e082'))
    Run a query to Download Data