DISTINCT tx_hash as hash0

from external.tokenflow_starknet.decoded_traces

where --tx_hash = '0x04db5ff5c6359e48371802762193da065b5edac7742ca9cc5e309af9916490d0' and

caller = '0x04c0a5193d58f74fbace4b74dcf65481e734ed1714121bdc571da345540efa05' --zklend:market

and CHAIN_ID = 'mainnet'

and FUNCTION = '__default__'),

zk_all2 as (SELECT timestamp::date as date, count(DISTINCT contract) as users, 'zklend' as protocol

from external.tokenflow_starknet.decoded_transactions join zk_all on tx_hash =hash0

where chain_id = 'mainnet'

GROUP by all)

SELECT * from zk_all2