flipside

    near - test
    BlockTrackernear - test
    Updated 2023-04-11
    SELECT
    date_trunc('day', block_timestamp) AS date,
    sum(tx:actions[0]:FunctionCall:withdraw) AS volume_withdraw
    FROM
    near.core.fact_transactions
    WHERE
    tx_receiver = 'everstake.poolv1.near'
    AND tx:actions[0]:FunctionCall:method_name = 'withdraw'

    GROUP by 1;

    SELECT DISTINCT tx:actions[0]:FunctionCall:method_name
    FROM near.core.fact_transactions
    WHERE tx_receiver = 'linear-protocol.near'
    AND tx:actions[0]:FunctionCall:method_name != 'deposit_and_stake' and tx_signer != 'operator.linear-protocol.near'


    --tx_hash = '2qp7znMGMMHCdd36ZCyL2xK1AspPq8JphbNKWsdYVA15';
    Run a query to Download Data