princefarzamActive wallets
    Updated 2022-07-06
    WITH txns AS (
    SELECT
    COUNT(DISTINCT TX_SIGNER) AS 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
    ),
    swaps AS (
    WITH swap_txns AS (
    SELECT
    DISTINCT TXN_HASH AS swaps
    FROM flipside_prod_db.mdao_near.actions_events
    WHERE ACTION_DATA:method_name::STRING='swap'
    AND BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90)
    SELECT
    COUNT(DISTINCT A.TXN_HASH) AS NUMBER_OF_SWAPS,
    COUNT(DISTINCT TX_SIGNER) AS ACTIVE_SWAPPERS
    FROM flipside_prod_db.mdao_near.transactions A INNER JOIN swap_txns B ON A.TXN_HASH = B.swaps
    ),
    transfers AS (
    SELECT
    COUNT(DISTINCT TXN_HASH) AS NUMBER_OF_TRANSFERS,
    COUNT(DISTINCT TX_SIGNER) AS ACTIVE_SENDERS

    FROM flipside_prod_db.mdao_near.transfers
    WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90
    AND STATUS= TRUE
    ),
    stakers AS(
    WITH Stake_transactions AS (
    SELECT
    TXN_HASH AS Stake_txns
    FROM flipside_prod_db.mdao_near.actions_events
    WHERE ACTION_DATA:method_name::string='deposit_and_stake'
    AND BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90)

    Run a query to Download Data