date_trunc('day', block_timestamp) as day,

count(*) as transactions,

count(DISTINCT SIGNER_ID) as users,

sum(ATTACHED_GAS / power(10, 24)) as gas_fees_near

FROM near.core.fact_actions_events_function_call

WHERE receiver_id LIKE 'nearhorizon.near'

GROUP BY 1