Delamir-6014uni 07 Genie
    Updated 2022-12-20
    with Genie as (
    select
    from_address as users,
    count(tx_hash) as total_TXs
    from ethereum.core.fact_transactions
    where
    block_timestamp <= '2022-04-15'
    and to_address in ('0xf97e9727d8e7db7aa8f006d1742d107cf9411412','0x31837aaf36961274a04b915697fdfca1af31a0c7'
    ,'0xcdface5643b90ca4b3160dd2b5de80c1bf1cb088','0x2af4b707e1dce8fc345f38cfeeaa2421e54976d5'
    ,'0x0a267cf51ef038fc00e71801f5a524aec06e4f07')
    and eth_value > 0
    group by 1
    having total_TXs > 1
    )

    select
    count(users) as Unique_wallets
    from Genie