SELECT

block_timestamp,

tx_hash,

origin_from_address,

contract_address,

event_inputs:value as amount --row amount

from optimism.core.fact_event_logs

where origin_to_address = '0x170a5714112daeff20e798b6e92e25b86ea603c1' --overtime contract

and contract_address in (

'0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9','0x94b008aa00579c1307b0ef2c499ad98a8ce58e58','0x7f5c764cbc14f9669b88837ca1490cca17c31607','0xda10009cbd5d07dd0cecc66161fc93d7c9000da1') --usdt-usdc-susd-dai

and event_inputs:to = '0x170a5714112daeff20e798b6e92e25b86ea603c1'

and event_inputs:from !in ('0x0000000000000000000000000000000000000000','0x170a5714112daeff20e798b6e92e25b86ea603c1')

and block_timestamp::date >= current_date - 14

and event_name = 'Transfer'

and tx_status = 'SUCCESS'

),

t2 as (

SELECT

block_timestamp,

SYMBOL,

tx_hash,

origin_from_address,

contract_address,

amount,

decimals

from optimism.core.dim_contracts join t1 on address = contract_address

),

t3 as (

SELECT

block_timestamp,

tx_hash,

origin_from_address,

amount / pow(10, decimals) as amount_,-- usd amount