count(distinct origin_from_address) as "User Count", case

when ORIGIN_FUNCTION_SIGNATURE='0xa0712d68' then 'Supply'

when ORIGIN_FUNCTION_SIGNATURE='0x852a12e3' or ORIGIN_FUNCTION_SIGNATURE='0xdb006a75' then 'Withdraw'

when ORIGIN_FUNCTION_SIGNATURE='0xc5ebeaec' then 'Borrow'

when ORIGIN_FUNCTION_SIGNATURE='0x0e752702' then 'Repay'

end as "Action"

from optimism.core.ez_token_transfers

where

contract_address in ('0x94b008aa00579c1307b0ef2c499ad98a8ce58e58'

,'0x7f5c764cbc14f9669b88837ca1490cca17c31607'

,'0xda10009cbd5d07dd0cecc66161fc93d7c9000da1'

,'0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9'

,'0x4200000000000000000000000000000000000006'

,'0x4200000000000000000000000000000000000042'

,'0xdfa46478f9e5ea86d57387849598dbfb2e964b02'

,'0x68f180fcce6836688e9084f035309e29bf0a2095'

,'0xc40f949f8a4e094d1b49a23ea9241d289b7b2819'

,'0x1f32b1c2345538c0c6f582fcb022739c4a194ebb')

and

(origin_to_address='0x5ff29e4470799b982408130efaabdeeae7f66a10' or -- usdt pool --6

origin_to_address='0xe7de932d50efc9ea0a7a409fc015b4f71443528e' or -- mai

origin_to_address='0xec8fea79026ffed168ccf5c627c7f486d77b765f' or -- usdc pool --6

origin_to_address='0x5569b83de187375d43fbd747598bfe64fc8f6436' or -- dai pool --18

origin_to_address='0xd14451e0fa44b18f08aeb1e4a4d092b823caca68' or -- sUSD POOL --18

origin_to_address='0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e' or -- weth pool --18

origin_to_address='0x8cd6b19a07d754bf36adeee79edf4f2134a8f571' or -- op pool --18

origin_to_address='0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d' or -- wbtc pool --8

origin_to_address='0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82' or -- lusd pool -18

origin_to_address='0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5') -- wstETH pool 18

and

(ORIGIN_FUNCTION_SIGNATURE='0xa0712d68' -- Supply

or ORIGIN_FUNCTION_SIGNATURE='0x852a12e3' or ORIGIN_FUNCTION_SIGNATURE='0xdb006a75' -- withdraw

or ORIGIN_FUNCTION_SIGNATURE='0xc5ebeaec' -- borrow

or ORIGIN_FUNCTION_SIGNATURE='0x0e752702') -- repay

and block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}'