DISTINCT event_inputs:addr as market_address

FROM polygon.core.fact_event_logs

WHERE origin_to_address = '0xc040f84cf7046409f92d578ef9040fe45e6ef4be'

AND event_name = 'MarketCreated'), MIN2 AS (

SELECT

W.block_timestamp,

W.from_address as user,

W.tx_hash,

Q.* FROM MIN as Q JOIN polygon.core.fact_transactions as W on Q.market_address = W.to_address)

SELECT count(DISTINCT tx_hash) as "Transaction ",

count(DISTINCT user) as "User "

FROM MIN2 WHERE block_timestamp > CURRENT_DATE - 270