with transactions as (

date(date_trunc('{{Period}}',block_timestamp)) as date_time,

count(distinct origin_from_address) as address,

count( distinct tx_hash) as transaction

from Arbitrum.core.ez_decoded_event_logs

where origin_to_address = lower('0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE')

or decoded_log:bridgeData:integrator = 'jumper.exchange'

or decoded_log:integrator = 'jumper.exchange'

And event_name in ('LiFiGenericSwapCompleted','LiFiTransferStarted','LiFiSwappedGeneric')

group by date_time

select

date_time,

address,

transaction,

sum(transaction) over() as total_transction

from transactions

order by date_time