spacebar2024-03-05 09:56 PM
    Updated 2024-12-04
    SELECT COUNT(DISTINCT address) FROM (
    SELECT block_timestamp,topics[2] as address FROM blast.core.fact_event_logs
    where LOWER(contract_address) = LOWER('0xe91a42e3078c6ad358417299e4300683de87f971')
    UNION ALL
    SELECT block_timestamp,topics[1] as address FROM blast.core.fact_event_logs
    where LOWER(contract_address) = LOWER('0x5ff315aa82a8b2b435f866d20ecd46959999bdcd')
    and LOWER(topics[0]) = LOWER('0x621d62c6c0c4a0c35e883c6b27ad50ecc3093f08bfaf8aa5f58127d351feeb21')
    UNION ALL
    SELECT block_timestamp,topics[2] as address FROM blast.core.fact_event_logs
    where LOWER(contract_address) = LOWER('0xe1784da2b8f42c31fb729e870a4a8064703555c2')
    and (LOWER(topics[0]) = LOWER('0x99039fcf0a98f484616c5196ee8b2ecfa971babf0b519848289ea4db381f85f7')
    OR LOWER(topics[0]) = LOWER('0x2cbcd809a4c90d11f8d12c4b6d09986b255ae1e68f54f076c145fbb2185904e1'))
    ) x
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived