binhachon3. [Easy] Number of Users of THORChain Bridges by Asset
    Updated 2021-10-24
    --select count (distinct from_address) as number_of_addresses,
    -- select date_trunc('Week', block_timestamp) as blocktime, blockchain, pool_name, sum(to_amount_min_usd) as usd_amount from thorchain.swaps
    -- group by blocktime, blockchain, pool_name

    select blockchain, count(distinct from_address) as number_of_users from (
    --------------------Get unique users from swap --------------------------------
    select distinct from_address, blockchain from thorchain.swaps
    where substr(blockchain,1,3) != substr(pool_name,1,3)
    union all
    select distinct from_address, case when substr(pool_name,1,3) = 'THO' then 'THOR' else substr(pool_name,1,3) end as blockchain from thorchain.swaps
    where substr(blockchain,1,3) != substr(pool_name,1,3)
    union all
    --------------------Get unique users from upgrades--------------------------------
    select distinct from_address, substr(burn_asset,1,3) as blockchain from thorchain.upgrades
    union all
    select distinct to_address as from_address, 'THOR' as blockchain from thorchain.upgrades
    )
    group by blockchain

    Run a query to Download Data