SELECT

date(block_timestamp) as day,

'in' as tx_type,

contract_address,

sum(raw_amount) as raw_amt

FROM base.core.fact_token_transfers

WHERE from_address in (

lower('0xbb7e170df05231f2ceab51c80f35fe68e47d3af4'), --

lower('0xbBf71AAD6E1F8D180D3B1D898528654c1d18b2fF'), -- fBOMB/AERO

lower('0x7f670f78B17dEC44d5Ef68a48740b6f8849cc2e6'), -- WETH/AERO

lower('0x2223F9FE624F69Da4D8256A7bCc9104FBA7F8f75'), -- AERO/USDbC

lower('0x6EAB8c1B93f5799daDf2C687a30230a540DbD636'), -- DAI/USDbC

lower('0x9e4CB8b916289864321661CE02cf66aa5BA63C94'), -- WETH/DEUS

lower('0x4a3636608d7Bc5776CB19Eb72cAa36EbB9Ea683B'), -- USD+/USDbC

lower('0x1b05e4e814b3431a48b8164c41eaC834d9cE2Da6'), -- DAI+/USD+

lower('0x2d25E0514f23c6367687dE89Bd5167dc754D4934'), -- WETH/TAROT

lower('0xb680190fB16f417647e69D6A84719aE9c7E5E20a'), -- USDbC/STG

lower('0x8b432C54d6e8E1B8D1802753514AB53044Af1861'), -- DOLA/MAI

lower('0x218F511431194B2C756D67a137DE536beA74E498'), -- ERN/stERN

lower('0x6e23f90E25f432c9dF9eF9276472DDa3951e4465'),

lower('0xA819Af1CC8AbE618eA8abaDeb464960F7451CEAB'), -- WETH/UNIDX

lower('0x0B25c51637c43decd6CC1C1e3da4518D54ddb528'), -- DOLA/USBbC

lower('0x2B7704f1cb9324cD8586B33C6c540CbD64E58237'), -- EXTRA/USDbC

lower('0xAf58FDeE432a104a932a899968d60F92838886cd'), -- T/WETH

lower('0x2722C8f9B5E2aC72D1f225f8e8c990E449ba0078'), -- tBTC/WETH

lower('0x723AEf6543aecE026a15662Be4D3fb3424D502A9'), -- tBTC/USDbC

lower('0x9483ab65847A447e36d21af1CaB8C87e9712ff93'), -- wUSDR/USDbC

lower('0xB4885Bc63399BF5518b994c1d0C153334Ee579D0'), -- WETH/USDbC

lower('0x44Ecc644449fC3a9858d2007CaA8CFAa4C561f91') -- cbETH/WETH

GROUP BY 1,2,3