msafadoost frequency of use
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
SELECT COUNT(DISTINCT(TX_HASH)) as unic_users,
'Hop' AS chain
FROM ethereum.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS IN (
lower('0xb8901acB165ed027E32754E0FFe830802919727f'),
lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a'),
lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6'),
lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1'),
lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2'),
lower('0xb98454270065A31D71Bf635F6F7Ee6A518dFb849')
)
UNION
SELECT COUNT(DISTINCT(TX_HASH)) as unic_users,
'Arbitrum' AS chain
FROM ethereum.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS = lower('0x72Ce9c846789fdB6fC1f34aC4AD25Dd9ef7031ef')
UNION
SELECT COUNT(DISTINCT(TX_HASH)) as unic_users,
'Optimism' AS chain
FROM ethereum.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS = lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1')
UNION
SELECT COUNT(DISTINCT(TX_HASH)) as unic_users,
'Polygon' AS chain
FROM ethereum.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS = lower('0xA0c68C638235ee32657e8f720a23ceC1bFc77C77')
Run a query to Download Data