date_trunc('day', block_timestamp) as "Date",

count(distinct tx_id) as "#Orders",

count(distinct signers) as "#Users"

from solana.core.fact_transactions

where 0=0

and log_messages[1] LIKE '%InitializeOrder%'

and succeeded

and block_timestamp >= dateadd(month, -3, current_date)

group by 1