barbodnet 3
    Updated 2022-07-12
    select
    block_timestamp::date as day,
    l.LABEL,
    count(distinct t.signers[0]) as user_sol
    from solana.fact_transactions t join solana.dim_labels l on t.instructions[0]:programId = l.address
    where t.block_timestamp>=CURRENT_DATE-60
    and l.label_subtype != 'token_contract'
    and l.LABEL_TYPE in ('dex')
    and l.label != 'solana'
    and t.succeeded = TRUE
    group by 1,2
    Run a query to Download Data