FROM (SELECT date_trunc('day', block_timestamp) as date,

event_name,

COUNT(DISTINCT tx_hash) as trxs,

COUNT(DISTINCT origin_from_address) as users

FROM optimism.core.fact_event_logs

WHERE TX_STATUS = 'SUCCESS'

AND origin_to_address in (lower('0x25CbdDb98b35ab1FF77413456B31EC81A6B6B746'),

lower('0xC5be2c918EB04B091962fDF095A217A55CFA42C5'),

lower('0xA84EA94Aa705F7d009CDDF2a60f65c0d446b748E'),

lower('0x64DD805aa894dc001f8505e000c7535179D96C9E'),

lower('0x00D59BC35174C3b250Dd92a363495d38C8777a49'),

lower('0x9809fB94eED086F9529df00d6f125Bf25Ee84A93'),

lower('0xa132DAB612dB5cB9fC9Ac426A0Cc215A3423F9c9'),

lower('0xe3C5e29eA198e617ebc707718707Beff9393Fa51'),

lower('0x5F2f6721Ca0C5AC522BC875fA3F09bF693dcFa1D'),

lower('0x9c7305eb78a432ced5C4D14Cac27E8Ed569A2e26'),

lower('0x5d5Bea9f0Fc13d967511668a60a3369fD53F784F'),

lower('0x09236cfF45047DBee6B921e00704bed6D6B8Cf7e'),

lower('0x3460Dc71A8863710D1C907B8d9D5DBC053a4102d'),

lower('0x846e822e9a00669dcC647079d7d625d2cd25A951'),

lower('0x3c8B650257cFb5f272f799F5e2b4e65093a11a05')

)

GROUP BY 1,2

ORDER BY 1

)