date_trunc('day', block_timestamp) as day,

tx_id

-- instructions[0]['programId'],

-- l.label,

-- case

-- when instructions[0]['programId']='srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX' then 'Openbook'

-- else initcap(l.label)

-- end as dapp_name

from

solana.core.fact_transactions

where

SUCCEEDED

and

instructions[0]['programId']='srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX'

select

day,

count(distinct tx_id) as tx_cnt

from

events

group by 1