SELECT

tx_hash AS "Transaction Hash"

FROM avalanche.core.ez_decoded_event_logs

WHERE event_name = 'Transfer'

AND (decoded_log:to = '0x1fd108cf42a59c635bd4703b8dbc8a741ff834be'

OR decoded_log:from = '0x1fd108cf42a59c635bd4703b8dbc8a741ff834be')

SELECT DISTINCT

"Transaction Hash"

FROM txs;