neth_account_creation AS (

SELECT tx.tx_signer AS near_address

, fc.args['eth_address']::string AS eth_address

, fc.block_timestamp AS created_at

, fc.tx_hash AS create_tx

FROM near.core.fact_actions_events_function_call AS fc

LEFT JOIN near.core.fact_transactions AS tx

ON tx.tx_hash = fc.tx_hash

AND tx.block_timestamp >= '2022-06-01'

WHERE fc.tx_hash IN (

SELECT r.tx_hash

FROM near.core.fact_receipts AS r

WHERE r.receiver_id = 'nethmap.near'

)

AND fc.method_name = 'set'

),

neth_account_deletion AS (

SELECT tx.tx_signer AS near_address

, fc.args['eth_address']::string AS eth_address

, fc.block_timestamp AS deleted_at

, fc.tx_hash AS delete_tx

FROM near.core.fact_actions_events_function_call AS fc

LEFT JOIN near.core.fact_transactions AS tx

ON tx.tx_hash = fc.tx_hash

AND tx.block_timestamp >= '2022-06-01'

WHERE fc.tx_hash IN (

SELECT r.tx_hash

FROM near.core.fact_receipts AS r