pool_maker_txs as (

select

t.tx_hash,

t.block_timestamp,

method_name,

try_parse_json(args) as args_json,

tx_signer as user,

try_base64_decode_string(r.status_value:SuccessValue) as id,

args_json:fee as fee_rate,

args_json:tokens[0] as token0,

args_json:tokens[1] as token1,

args_json:amp_factor as amp_factor,

case when args_json:decimals is not null then args_json:decimals[0] else null end as token0_decimals,

case when args_json:decimals is not null then args_json:decimals[1] else null end as token1_decimals

from near.core.fact_actions_events_function_call f

join near.core.fact_transactions t on f.tx_hash = t.tx_hash

join near.core.fact_receipts r on f.tx_hash = r.tx_hash and len(r.status_value:SuccessValue) > 0

where t.tx_status = 'Success'

and tx_receiver = 'v2.ref-finance.near'

and method_name in (

'add_simple_pool',

'add_stable_swap_pool',

'add_rated_swap_pool'

)

select * from pool_maker_txs