0xHaM-dStar Atlas Total Tx
    Updated 2023-02-10
    with starTb as (
    select
    date_trunc('{{Time_Interval}}', block_timestamp)::date as date,
    'Star Atlas' as game,
    count(distinct tx_id) as tx_cnt,
    count(distinct signers[0]) as user_address,
    sum(tx_cnt) over (order by date) as cum_tx_cnt
    from solana.core.fact_events events
    where program_id in (
    'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW', -- SA FLEET Program
    'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg', -- SA Marketplace Program
    'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2' -- SA Governance Staking Program
    )
    and succeeded = TRUE
    GROUP by 1
    )
    , totalTb as (
    select
    date_trunc('{{Time_Interval}}', block_timestamp)::date as date,
    'Solana Ecosystem' as game,
    count(distinct signers[0]) as user_address
    from solana.core.fact_events events
    where succeeded = TRUE
    AND block_timestamp > '2022-08-10'
    GROUP by 1
    )
    select
    date,
    t1.tx_cnt as star_tx_cnt,
    t1.user_address as star_active_usr_cnt,
    t2.user_address as solana_active_usr_cnt,
    cum_tx_cnt
    from starTb t1 JOIN totalTb t2 USING(date) --on t1.block_timestamp = t2.block_timestamp
    order by 1
    Run a query to Download Data