SELECT

DISTINCT CONTRACT_ADDRESS AS CONTRACT_ADDRESS,

c.address_name,

c.label_type,

c.label_subtype,

c.project_name,

trc.value AS VALUE

FROM

arbitrum.core.fact_event_logs logs

LEFT JOIN arbitrum.core.dim_labels c ON logs.CONTRACT_ADDRESS = c.ADDRESS

LEFT JOIN arbitrum.core.fact_transactions txs ON logs.contract_address = txs.to_address

LEFT JOIN arbitrum.core.fact_traces trc ON logs.contract_address = trc.to_address

WHERE

logs.ORIGIN_FUNCTION_SIGNATURE = '0xa9059cbb' -- function signature

-- AND logs.contract_address = '0xb88690461ddbab6f04dfad7df66b7725942feb9c'

AND logs.block_timestamp > '2024-09-01' :: DATE

AND c.label_type NOT IN ('cex', 'token')

AND c.label_subtype NOT IN ('token_contract')

CONTRACT_ADDRESS,

-- ADDRESS_NAME,

-- LABEL_TYPE,

-- LABEL_SUBTYPE,

-- PROJECT_NAME,

SUM(VALUE)

data

VALUE > 1

GROUP BY

CONTRACT_ADDRESS