spacebar2024-03-05 09:56 PM
Updated 2024-12-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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