flipside

    Near Social Txs with methods
    KaskoazulNear Social Txs with methods
    Updated 2023-01-23
    -- SELECT
    -- DATE_TRUNC('WEEK', createdat) AS fecha
    -- , state AS type
    -- , COUNT(DISTINCT id) AS contributions
    -- FROM
    -- near.beta.github_activity
    -- GROUP BY
    -- fecha, type
    -- ORDER BY
    -- fecha DESC

    WITH tx_with_method AS (
    SELECT
    ft.block_id
    , COALESCE(ft.block_timestamp, b.block_timestamp) AS block_timestamp
    , ft.tx_hash
    , SPLIT_PART(ft.action_id, '-', 2) AS action_no
    , ft.action_name
    , ft.method_name
    , ft.args
    , ft.deposit / POW(10,24) AS deposit_near
    , t.tx_signer as profile
    , t.tx_receiver
    , PARSE_JSON(args) as message
    --, args:data:profile:index
    FROM
    near.core.fact_actions_events_function_call ft
    LEFT JOIN
    near.core.fact_blocks b
    ON
    ft.block_id = b.block_id
    LEFT JOIN
    near.core.fact_transactions t
    ON
    ft.tx_hash = t.tx_hash
    WHERE
    Run a query to Download Data