KaskoazulUntitled Query
    Updated 2023-01-20
    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
    Run a query to Download Data