msafadoost frequency of use
    Updated 2022-06-19

    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