badboyUntitled Query
    Updated 2022-10-17
    select
    count
    (distinct transactions.tx_hash) as "Transactions",

    count (distinct transactions.tx_signer) as "Stakers",

    SUM(TRY_PARSE_JSON(calls.args):amount / POW(10,18)) as "Volume"

    from
    (near.core.fact_transactions transactions)
    join
    (near.core.fact_actions_events_function_call calls)
    ON
    (transactions.tx_hash = calls.tx_hash)

    where transactions.block_timestamp::date >= CURRENT_DATE - 90

    and left
    (SPLIT_PART(transactions.tx:receipt[0]:outcome:status, '"', 2), 7) = 'Success'

    and transactions.tx_receiver = 'contract.main.burrow.near'

    and calls.method_name = 'account_stake_booster'
    Run a query to Download Data