Delamir-6014Untitled Query
    Updated 2022-11-17
    with sol as (select
    date_trunc('week', block_timestamp) as week,
    count(distinct(signers[0])) as sol_wallets_count
    from solana.fact_transactions
    where week >= '2022-01-01'
    and succeeded = 'TRUE'
    group by 1),

    eth as (select date_trunc('week', block_timestamp) as week,
    count(distinct(origin_address)) as eth_wallets_count
    from ethereum.udm_events
    where block_timestamp >= '2022-01-01'
    group by 1),
    luna as (select date_trunc('week', block_timestamp) as week,
    count(distinct(f.value)) as terra_wallets_count
    from terra.transactions p,
    table(flatten(p.tx_from)) f
    where block_timestamp >= '2022-01-01'
    group by 1),

    algorand as (select date_trunc('week', block_timestamp) as week,
    count(distinct(sender)) as algo_wallets_count
    from algorand.transactions
    where block_timestamp >= '2022-01-01'
    group by 1)
    select a.week,
    sol_wallets_count,
    eth_wallets_count,
    terra_wallets_count,
    algo_wallets_count
    from sol a
    join eth b
    on a.week = b.week
    join luna c
    Run a query to Download Data