round(sum(raw_amount/pow(10,b.decimals)),2) AS usd_deposit

from optimism.core.fact_token_transfers a join optimism.core.dim_contracts b on a.contract_address = b.address

where block_timestamp >= current_date - 14

and raw_amount >0

and origin_to_address = '0x170a5714112daeff20e798b6e92e25b86ea603c1' --overtime markets

and origin_from_address != '0x0000000000000000000000000000000000000000'

and contract_address in (

'0xb4a6939cc5683c00e83bca6017e1cd0a99c0d0a1',

'0x9509596197a55e514ef79c2dae6960324a980324',

'0xdaf532113547ff62018f31b7fb7e4bc255515fb9',

'0x0c3fbbdda44e02879ffa9c9868c96338b98c3727',

'0xa7eecb95bcefaf1ab7fc2e5777ceaa6e4aec1642',

'0x4dc33ef46bc2d77705e196cb56e01c7c1c47f9ee',

'0xd76b9176a7594c06f063ba3e9e636c0c8542f0c2',

'0x144a0f95f6062f07e6f0ef20b54c8e70208d0f60',

'0x61cff6663638e89b29a688210d1e81477ae0e645',

'0x74cd7079a73ab1cc2f46b3c5212bbbe7fd1fd171',

'0x059e8303b88ff85561125b8230425cf409bfe3ad',

'0xf1ed8e281e72cd118da28e4b03f41d8d593b4756',

'0x8054dc245bf85d8824c9374ae82efa0f6fc3dd18',

'0x707c42601cf9ea937fcc4c6cf711d3e5b79df2b3',

'0x138e39f539b2b683a8ac6fbdd3470431cf28c33e',

'0x17a454be0e03c6fb1670e6bc2b331f89557bdef2',

'0xc0788cd9ced5de116f5236498f030735e4f9675f',

'0x4898a35628ae19f50c32bf4ee070d547e001973f',

'0xcab3809aa564412f80aad94211fbfe0ac0fd6a3b',

'0xd72f7c78f5a8468dcb34dca68bdc97bea263f7d7' )

group by 1