To find the list of transactions related to each protocol, I use the fact_receipts table. I will explain how to obtain transactions for each protocol separately:

Meta Pool

The Meta Pool contract address in Near is meta-pool.near.

Stake Transactions
To find stake transactions in Meta Pool in the fact_receipts table, we filter the queries as follows:

receiver_id = 'meta-pool.near'
actions:receipt:Action:actions[0]:FunctionCall:method_name in ('deposit_and_stake')
status_value:Failure is null

Query

metapool_stake_v1 as (
    select
      receipts.block_timestamp,
      receipts.tx_hash,
      receipts.actions:predecessor_id as user_address,
      (
        receipts.actions:receipt:Action:actions[0]:FunctionCall:deposit
      ) * pow(10, -24) as amount
    from
      near.core.fact_receipts receipts
      join near.core.fact_transactions transactions using (tx_hash)
    where
      receipts.receiver_id = 'meta-pool.near'
      and receipts.actions:receipt:Action:actions[0]:FunctionCall:method_name in ('deposit_and_stake')
      and receipts.status_value:Failure is null
      and transactions.tx_status = 'Success'
  ),

Add Liquidity Transactions

To find add liquidity transactions in Meta Pool in the fact_receipts table, we filter the queries as follows:

receiver_id = 'meta-pool.near'
actions:receipt:Action:actions[0]:FunctionCall:method_name in ('nslp_add_liquidity')
status_value:Failure is null

Query

metapool_add_liquidity_v1 as (
    select
      receipts.block_timestamp,
      receipts.tx_hash,
      receipts.actions:predecessor_id as user_address,
      (
        receipts.actions:receipt:Action:actions[0]:FunctionCall:deposit
      ) * pow(10, -24) as amount
    from
      near.core.fact_receipts receipts
      join near.core.fact_transactions transactions using (tx_hash)
    where
      receipts.receiver_id = 'meta-pool.near'
      and receipts.actions:receipt:Action:actions[0]:FunctionCall:method_name in ('nslp_add_liquidity')
      and receipts.status_value:Failure is null
      and transactions.tx_status = 'Success'
  ),

UnStake Transactions

To find unstake transactions in Meta Pool in the fact_receipts table, we filter the queries as follows:

receiver_id = 'meta-pool.near'
actions:receipt:Action:actions[0]:FunctionCall:method_name in ('unstake', 'unstake_all', 'liquid_unstake)
status_value:Failure is null

Query

See Full Query

Remove Liquidity Transactions

To find remove liquidity transactions in Meta Pool in the fact_receipts table, we filter the queries as follows:

receiver_id = 'meta-pool.near'
actions:receipt:Action:actions[0]:FunctionCall:method_name in ('nslp_remove_liquidity')
status_value:Failure is null

Query

 metapool_remove_liquidity_v1 as (
    select
      receipts.block_timestamp,
      receipts.tx_hash,
      receipts.actions:predecessor_id as user_address,
      (
        replace(
          (
            split(split(array_to_string(logs, ','), ':') [3], ',') [0]
          ),
          '\"',
          ''
        )::float
      ) * pow(10, -24) as amount
    from
      near.core.fact_receipts receipts
      join near.core.fact_transactions transactions using (tx_hash)
    where
      receipts.receiver_id = 'meta-pool.near'
      and receipts.actions:receipt:Action:actions[0]:FunctionCall:method_name in ('nslp_remove_liquidity')
      and receipts.status_value:Failure is null
      and transactions.tx_status = 'Success'
  ),

LiNEAR

The LiNEAR contract address in Near is linear-protocol.near.

Stake Transactions

To find stake transactions in LiNEAR in the fact_receipts table, we filter the queries as follows:

receiver_id = 'linear-protocol.near'
actions:receipt:Action:actions[0]:FunctionCall:method_name in (deposit_and_stake)
status_value:Failure is null

Query

See Full Query

UnStake Transactions

To find unstake transactions in LiNEAR in the fact_receipts table, we filter the queries as follows:

receiver_id = 'linear-protocol.near'
actions:receipt:Action:actions[0]:FunctionCall:method_name in ('unstake', 'unstake_all', 'drain_unstake')
status_value:Failure is null

Query

See Full Query

Stader

The Stader contract address in Near is v2-nearx.stader-labs.near

Stake Transactions

To find stake transactions in Stader in the fact_receipts table, we filter the queries as follows:

receiver_id = 'v2-nearx.stader-labs.near'
actions:receipt:Action:actions[0]:FunctionCall:method_name in ('deposit_and_stake', 'direct_deposit_and_stake')
status_value:Failure is null

Query

See Full Query

UnStake Transactions

To find unstake transactions in Stader in the fact_receipts table, we filter the queries as follows:

receiver_id = 'v2-nearx.stader-labs.near'
actions:receipt:Action:actions[0]:FunctionCall:method_name in ('unstake', 'unstake_all')
status_value:Failure is null

Query

See Full Query

NOTE: In order not to make the Methodology section longer, only queries related to Meta Pool have been included, and for other protocols, I have only included the link to the query.

Liquid Staking Protocols on Near