with programs as (

select

tx_id,

program_id,

ifnull(label, program_id) as label,

ifnull(type,'unknown') as type,

signers[0] as fee_payer,

f.value as signer,

block_timestamp::date as date_time

from solana.core.fact_events events

inner join lateral flatten (input => signers) f

left join (SELECT CASE WHEN label = 'tensorswap' THEN 'nft' WHEN label = 'shark finance' then null else label_type end as type, label, address FROM solana.core.dim_labels labels)

labels on events.program_id = labels.address

where succeeded = {{tx_succeeded}}

and (not labels.label = 'solana' or labels.label is null)

and block_timestamp ::date < current_date() - interval '240 days'

and block_timestamp ::date > current_date() - interval '270 days'

date_time,

type,

count(distinct tx_id) as txs,

count(distinct signer) as signers

from programs

group by 1, 2