princefarzamThe top ten wallets that have the most transactions
    Updated 2022-07-05
    SELECT
    TX_SIGNER AS Top_active_wallets,
    COUNT(DISTINCT TXN_HASH) AS Number_of_txns
    FROM flipside_prod_db.mdao_near.transactions
    WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90 --IN THE LAST 90 DAYS
    GROUP BY Top_active_wallets
    ORDER BY Number_of_txns DESC
    LIMIT 10
    Run a query to Download Data