date_trunc('day', block_timestamp),

ADDRESS_NAME,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers

FROM polygon.core.fact_event_logs

LEFT outer JOIN flipside_prod_db.crosschain.address_labels

ON contract_address = address

WHERE tx_hash IN (

SELECT DISTINCT tx_hash

FROM polygon.core.fact_event_logs

WHERE event_name LIKE 'Swap'

AND address_name IN (

SELECT address_name FROM(

SELECT

ADDRESS_NAME,

count(DISTINCT tx_hash) as swaps

FROM polygon.core.fact_event_logs

LEFT outer JOIN flipside_prod_db.crosschain.address_labels

ON contract_address = address

WHERE tx_hash IN (

SELECT DISTINCT tx_hash

FROM polygon.core.fact_event_logs

WHERE event_name LIKE 'Swap'

-- AND origin_function_signature LIKE '0x13dcfc59'

)

AND event_name LIKE 'Transfer'

AND not address_name is NULL

GROUP by 1

ORDER BY 2 DESC

LIMIT 10

)

AND event_name LIKE 'Transfer'