NatNumber of unique wallets: Polygon + comparison
    Updated 2022-07-12
    with
    polygon_wallets as (select DATE_TRUNC('day',block_timestamp) as date, 'Polygon' as network, count(distinct from_address) as unique_polygon_wallets
    from polygon.core.fact_transactions
    where block_timestamp::date >= '2022-07-01' AND block_timestamp::date < CURRENT_DATE
    group by date),

    algorand_wallets as (select DATE_TRUNC('day',block_timestamp) as date, 'Algorand' as network, count(distinct sender) as unique_algo_wallets
    from algorand.transactions
    where block_timestamp::date >= '2022-07-01' AND block_timestamp::date < CURRENT_DATE
    group by date),

    -- solana_wallets as (select DATE_TRUNC('day',block_timestamp) as date, 'Solana' as network, count(distinct tx_from) as unique_solana_wallets
    -- from solana.core.fact_transfers
    -- where block_timestamp::date >= '2022-07-01' AND block_timestamp::date < CURRENT_DATE and tx_from is not null
    -- group by date),

    ethereum_wallets as (select DATE_TRUNC('day',block_timestamp) as date, 'Ethereum' as network, count(distinct from_address) as unique_eth_wallets
    from ethereum.core.fact_transactions
    where block_timestamp::date >= '2022-07-01' AND block_timestamp::date < CURRENT_DATE
    group by date),

    optimism_wallets as (select DATE_TRUNC('day',block_timestamp) as date, 'Optimism' as network, count(distinct from_address) as unique_optimism_wallets
    from optimism.core.fact_transactions
    where block_timestamp::date >= '2022-07-01' AND block_timestamp::date < CURRENT_DATE
    group by date),

    binance_wallets as (select DATE_TRUNC('day',block_timestamp) as date, 'Binance' as network, count(distinct from_address) as unique_binance_wallets
    from bsc.core.fact_transactions
    where block_timestamp::date >= '2022-07-01' AND block_timestamp::date < CURRENT_DATE
    group by date),

    avalanche_wallets as (select DATE_TRUNC('day',block_timestamp) as date, 'Avalanche' as network, count(distinct from_address) as unique_avalanche_wallets
    from avalanche.core.fact_transactions
    where block_timestamp::date >= '2022-07-01' AND block_timestamp::date < CURRENT_DATE
    group by date)

    Run a query to Download Data