select

date_trunc('day', block_timestamp) as td,

CASE WHEN date_part ( weekday , block_timestamp ) = 0 or date_part ( weekday , block_timestamp ) = 6 THEN 'Weekend' ELSE 'Week Day' END,

COUNT( DISTINCT posttokenbalances[0]:owner)

from solana.events

Where instruction:programId LIKE 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'

AND block_timestamp > CURRENT_DATE - 270

AND not posttokenbalances[0]:owner is null

GROUP BY 1, 2

SELECT * FROM tab1