par_rnNEAR5
    Updated 2023-02-06
    select TX_SIGNER as signer, count(distinct(tx_hash)) as tx
    from near.core.fact_transactions
    where tx_status = 'Success'
    and block_timestamp::date >= CURRENT_DATE-14
    and tx_signer != 'ca1a3e7160b8c66af39387f27bfb7770831d15ee1c21a21ba35a6665479d1c05' -- it was messing up the charts
    group by signer
    order by tx desc
    limit 10
    Run a query to Download Data