ramishoowOvertime Markets - Profitable Traders
    Updated 2022-08-25
    --(Total Games Overtime)
    WITH Contract_address AS( SELECT address FROM optimism.core.dim_contracts ) SELECT COUNT(DISTINCT CONTRACT_ADDRESS) AS ToOOtal_Games FROM
    optimism.core.fact_event_logs WHERE CONTRACT_ADDRESS not in (SELECT address FROM Contract_address) AND EVENT_INPUTS:
    from = '0x170a5714112daeff20e798b6e92e25b86ea603c1' AND TX_STATUS='SUCCESS' AND ORIGIN_TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'
    --0x170a5714112daeff20e798b6e92e25b86ea603c1' AND TX_STATUS='SUCCESS' AND ORIGIN_TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'

    Run a query to Download Data