Arkanstaked 1
    Updated 2022-12-29
    WITH
    table1 as(
    SELECT
    action,
    stake_amount,
    tx_hash,
    tx_signer
    FROM
    near.core.dim_staking_actions
    WHERE
    block_timestamp >= '2022-01-01'
    )
    SELECT
    action,
    COUNT(DISTINCT tx_hash) tx_count,
    COUNT(DISTINCT tx_signer) user_count,
    SUM(stake_amount/1e24) AS amount
    FROM
    table1
    GROUP BY 1
    Run a query to Download Data