select tx_hash, from_address as user_address, raw_amount/pow(10,18) as amount_usd from optimism.core.fact_token_transfers

where origin_to_address='0x170a5714112daeff20e798b6e92e25b86ea603c1' and to_address='0x170a5714112daeff20e798b6e92e25b86ea603c1'

and (from_address!='0x0000000000000000000000000000000000000000' and from_address!='0x170a5714112daeff20e798b6e92e25b86ea603c1')

),

user_games as (

select

ftt.tx_hash, to_address as game_address, uv.amount_usd, uv.user_address

from optimism.core.fact_token_transfers ftt join usd_values uv on ftt.tx_hash=uv.tx_hash

where

origin_to_address='0x170a5714112daeff20e798b6e92e25b86ea603c1' and

from_address='0x170a5714112daeff20e798b6e92e25b86ea603c1' and

contract_address in ('0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9', '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1', '0x7f5c764cbc14f9669b88837ca1490cca17c31607', '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58')

and to_address!='0x9841484a4a6c0b61c4eea71376d76453fd05ec9c'

select * from user_games