count(DISTINCT a.tx_hash) as n_txns,

sum(a.args:amount)/pow(10,18) as vol,

avg(a.args:amount)/pow(10,18) as avg_opt_in,

count(DISTINCT b.tx_signer)

FROM near.core.fact_actions_events_function_call a

LEFT JOIN near.core.fact_transactions b

ON a.tx_hash = b.tx_hash

WHERE a.method_name = 'ft_transfer'

AND a.args:receiver_id = 'reward-optin.sweat'

AND b.tx_receiver = 'token.sweat'

AND date <= CURRENT_DATE-1

GROUP BY date