SELECT

tx_signer AS user_name

, MIN(block_timestamp) AS first_social_tx

FROM

near.core.fact_transactions

WHERE

tx_receiver = 'social.near'

AND tx_status = 'Success'

GROUP BY

user_name

, 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 parsed_args

, parsed_args:data[0] as data_t

--, 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