kiacryptoNumber of wallets that used the chain everyday since May 9th
    Updated 2022-05-31
    with flow as (
    select authorizers, count(distinct block_timestamp::date) as number_of_day
    from flow.core.fact_transactions
    where block_timestamp::date between '2022-05-09' and '2022-05-30'
    group by 1 having number_of_day = 22
    ),
    sol as (
    select signers, count(distinct block_timestamp::date) as number_of_day
    from flipside_prod_db.solana.fact_transactions
    where block_timestamp::date between '2022-05-09' and '2022-05-30'
    group by 1 having number_of_day = 22
    ),
    eth as (
    select from_address, count(distinct block_timestamp::date) as number_of_day
    from flipside_prod_db.ethereum_core.fact_transactions
    where block_timestamp::date between '2022-05-09' and '2022-05-30'
    group by 1 having number_of_day = 22
    ),
    algo as (
    select sender, count(distinct block_timestamp::date) as number_of_day
    from flipside_prod_db.algorand.transactions
    where block_timestamp::date between '2022-05-09' and '2022-05-30'
    group by 1 having number_of_day = 22
    )

    select count(*) as number_of_wallet, 'flow' as blockchain
    from flow

    union all
    select count(*) as number_of_wallet, 'solana' as blockchain
    from sol
    union all

    select count(*) as number_of_wallet, 'ethereum' as blockchain
    Run a query to Download Data