select

origin_from_address, contract_address,

case

when contract_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then sum(event_inputs:value)/pow(10,18)

when contract_address = '0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9' then sum(event_inputs:value)/pow(10,18)

when contract_address = '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' then sum(event_inputs:value)/pow(10,6)

when contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607' then sum(event_inputs:value)/pow(10,6)

end as volume

from optimism.core.fact_event_logs

where origin_to_address = '0x170a5714112daeff20e798b6e92e25b86ea603c1'

and event_name = 'Transfer'

and event_inputs:to = '0x170a5714112daeff20e798b6e92e25b86ea603c1'

and event_inputs:from != '0x0000000000000000000000000000000000000000'

and block_timestamp >= current_date - 14

group by origin_from_address, contract_address)

select origin_from_address, sum(volume)

from a

group by origin_from_address