DATE_TRUNC('DAY', TIMESTAMP) AS day

, CASE PARAMETERS[1]:value

WHEN '0x7c6f04a78f405bb2ff08cb07a1a1e0868800fa1ed41d9067d8f8f28ba73a4f9' THEN 'Router v1'

WHEN '0x72a82884102142b23bd045d6748b76e6bb6ff080d6e0d306aeb8ffcd9c6a550' THEN 'Router v2'

END AS version

, COUNT(DISTINCT(PARAMETERS[0]:value)) AS numberOfUniqueUsers

FROM external.tokenflow_starknet.decoded_events

WHERE CHAIN_ID != 'mainnet'

AND NAME = 'Transfer'

AND PARAMETERS[1]:value IN ('0x7c6f04a78f405bb2ff08cb07a1a1e0868800fa1ed41d9067d8f8f28ba73a4f9'

, '0x72a82884102142b23bd045d6748b76e6bb6ff080d6e0d306aeb8ffcd9c6a550')

AND PARAMETERS[0]:value NOT IN ( '0x613c1da4311ef672a2b86165f8bd0b9e4b50caaa82218f9839334c66f0c810c'

GROUP BY 1, 2

ORDER BY 3 DESC