with tx_log as

(select

date(block_timestamp) as date,

block_timestamp,

tx_hash,

contract_address,

contract_name,

event_name,

decoded_log

-- decoded_log['user'] as user,

-- decoded_log['amount'] as amount,

-- decoded_log['token'] as token_address

from base.core.ez_decoded_event_logs

-- limit 100

-- where event_name = 'BridgedDeposit'

-- qualify date(block_timestamp) = max(date(block_timestamp)) over()

),

contract_tx_count as

(SELECT

contract_address,

contract_name,

event_name,

count(*) over(partition by contract_address) as no_contract_tx,

count(*) over(partition by contract_address, contract_name, event_name) as no_evt_tx

from tx_log)

distinct concat(contract_address, contract_name, event_name, no_contract_tx, no_evt_tx) as uid,

*

from

(select