-- forked from solana programs_270 copy @ https://flipsidecrypto.xyz/edit/queries/a3f78632-3821-4ba6-ab2f-96185fcfabfc

-- forked from solana programs_270 @ https://flipsidecrypto.xyz/edit/queries/7a283aa1-c525-42e0-856c-7e1ecf053bea

-- forked from solana programs_180 copy @ https://flipsidecrypto.xyz/edit/queries/b6b2e6c3-bde2-40bc-9b4c-d8980633d1e1

-- forked from solana programs_90 @ https://flipsidecrypto.xyz/edit/queries/a3a79e07-3f49-4de3-af61-d927c272759a

-- forked from solana programs_90 copy @ https://flipsidecrypto.xyz/edit/queries/4bf4a65e-f333-467a-8634-5647da8bda53

-- forked from solana programs_60 @ https://flipsidecrypto.xyz/edit/queries/93a639e9-049c-4086-8709-dfaf1cf8d900

-- forked from solana programs @ https://flipsidecrypto.xyz/edit/queries/d56a08b8-144b-47b1-a2a8-6d62eb1c2de5

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 '185 days'

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