SELECT

date_trunc('{{Time_Ineterval}}', BLOCK_TIMESTAMP) AS TIME,

CASE

when log_messages[5] ilike '%buy' then 'Buy'

when log_messages[5] ilike '%sell' then 'Sell'

end as status,

count(DISTINCT tx_id) as n_trade,

count(DISTINCT SIGNERS[0]) as n_trader

FROM solana.core.fact_transactions

WHERE log_messages[4] LIKE '%E1XRkj9fPF2NQUdoq41AHPqwMDHykYfn5PzBXAyDs7Be%'

AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '{{Past_day}} DAY'

AND status is NOT NULL

GROUP by 1,2

ORDER by 1