freeman_7ARBITRUM
Updated 2024-09-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
-- For Arbitrum
with transactions as (
select
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
QueryRunArchived: QueryRun has been archived