StangFAST5. staking
    Updated 2023-04-09
    with

    stake AS
    (

    SELECT
    a.tx_hash
    , a.actions:receipt:Action:signer_id AS user
    , ( a.actions:receipt:Action:actions[0]:FunctionCall:deposit::float ) AS volume

    FROM
    near.core.fact_receipts a

    WHERE
    a.receiver_id = 'xtoken.ref-finance.near'
    AND a.actions:receipt:Action:actions[0]:FunctionCall:deposit::float!=0
    AND a.actions:receipt:Action:actions[0]:FunctionCall:method_name ilike '%transfer%'
    AND regexp_substr( a.status_value , 'Success' ) IS NOT NULL

    )

    ,

    unstake AS
    (

    SELECT
    a.tx_hash
    , a.actions:receipt:Action:signer_id AS user
    , ( a.actions:receipt:Action:actions[0]:FunctionCall:deposit::float ) AS volume

    FROM
    near.core.fact_receipts a

    WHERE
    a.receiver_id = 'xtoken.ref-finance.near'
    Run a query to Download Data