Updated 2024-07-01
    with eth as (
    SELECT
    count(distinct USER_ADDRESS) as eth_count
    from
    ethereum.core.fact_token_balances
    where
    CONTRACT_ADDRESS = lower('0xe3c408BD53c31C085a1746AF401A4042954ff740')
    ),
    solana_swaps as (
    select
    count(distinct SWAPPER) as swapper_count
    from
    solana.defi.ez_dex_swaps
    where
    SWAP_TO_SYMBOL like '%GMT%'
    ),
    solana_transaction as (
    select
    *
    from
    solana.core.fact_transactions
    where
    account_keys [0] = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
    )
    select
    *
    from
    solana_transaction