flipside

    Mech request's traders
    0xHaM-dMech request's traders
    Updated 2025-01-22
    -- forked from Mech request by traders copy @ https://flipsidecrypto.xyz/studio/queries/d2112306-34d5-4c55-a1b3-776ac40900d4

    -- forked from MLDZMN / Mech request by traders @ https://flipsidecrypto.xyz/MLDZMN/q/5Bclrrbzhrwa/mech-request-by-traders

    with t1 as (
    select
    BLOCK_TIMESTAMP,
    tx_hash,
    SERVICE_ID,
    NAME,
    MULTISIG_ADDRESS,
    AGENT_IDS[0] as agent_Id
    from crosschain.olas.ez_service_registrations
    where NAME ilike '%Trader%'
    )

    select
    count(DISTINCT SENDER_ADDRESS) as n_traders,
    count(*) as n_requests,
    from crosschain.olas.fact_mech_activity ac
    JOIN t1 on SENDER_ADDRESS = MULTISIG_ADDRESS
    -- group by 1,2
    -- order by 1 desc




    QueryRunArchived: QueryRun has been archived