SELECT date_trunc('day', call.block_timestamp) as date,

COUNT(DISTINCT case when split(split(rc.status_value,':')[0],'{')[1] NOT ilike '%Failure%' then tr.TX_RECEIVER END) as successful_executed_contracts

FROM near.core.fact_actions_events_function_call call

INNER JOIN near.core.fact_transactions tr

ON call.TX_HASH = tr.TX_HASH

INNER JOIN near.core.fact_receipts as rc

ON tr.TX_HASH=rc.TX_HASH

WHERE ACTION_NAME = 'FunctionCall'

AND METHOD_NAME <> 'new'

AND date <=CURRENT_DATE-1

group by DATE

ORDER BY date DESC