SELECT
block_timestamp::date as fecha
, COUNT (DISTINCT tx_hash) as txs
, COUNT (DISTINCT tx_signer) as users
, SUM (transaction_fee / POW(10,24)) fees_near
FROM
near.core.fact_transactions
WHERE
tx_receiver = 'social.near'
GROUP BY
1
ORDER BY
1 DESC