SELECT

origin_from_address as creator,

event_inputs:addr as market_address,

event_inputs:marketTemplate as market_template,

CASE

WHEN market_template = '0x1c5771e96c9d5524fb6e606f5b356d08c40eb194' THEN 'Dutch Auction'

WHEN market_template = '0xf60e5f4a44a510742457d8064ffd360b12d8d9af' THEN 'Crowdsale'

WHEN market_template = '0x258f7e97149afd7d7f84fa63b10e4a3f0c38b788' THEN 'Batch Auction'

END as market_type

FROM ethereum.core.fact_event_logs

WHERE origin_to_address = '0x7603a35af5cf10b113f167d424eb75bb7062c8ce'

AND event_name = 'MarketCreated'

), txs AS (

SELECT

b.block_timestamp,

b.from_address as user,

b.tx_hash,

a.*

FROM markets as a JOIN ethereum.core.fact_transactions as b on a.market_address = b.to_address

SELECT

market_type,

count(DISTINCT user) as "User Count"

FROM txs

WHERE block_timestamp > CURRENT_DATE - 90

GROUP BY market_type