SELECT

address

FROM

optimism.core.dim_contracts

)

SELECT

CONTRACT_ADDRESS as "game",

COUNT(DISTINCT tx_hash) AS "Total Users" ,

sum(

EVENT_INPUTS : value / pow(10, 18)

) "Total Volume"

FROM

optimism.core.fact_event_logs

WHERE

CONTRACT_ADDRESS not in (

SELECT

address

FROM

x

)

AND EVENT_INPUTS :

from

= '0x170a5714112daeff20e798b6e92e25b86ea603c1'

AND TX_STATUS = 'SUCCESS'

AND BLOCK_TIMESTAMP :: DATE >= CURRENT_DATE - 14

AND ORIGIN_TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'

GROUP BY

1

ORDER BY

2 DESC

LIMIT

10