data_staking AS

SELECT

b.name AS name

, b.symbol AS symbol

, b.address AS address

, min( a.tx_hash ) AS tx

FROM

avalanche.core.fact_event_logs a

INNER JOIN

avalanche.core.dim_contracts b

ON

a.contract_address = b.address

INNER JOIN

avalanche.core.dim_labels c

ON

a.origin_to_address = c.address

WHERE

a.event_name = 'Transfer'

AND a.contract_address != '0x39cf1bd5f15fb22ec3d9ff86b0727afc203427cc'

-- sushi masterchef or mini chef

AND

(

a.origin_to_address = '0xd6a4f121ca35509af06a0be99093d08462f53052'

OR

a.origin_to_address = '0x3a01521f8e7f012eb37eaaf1cb9490a5d9e18249'

)

GROUP BY