freeman_7Jumper 30-Days Interaction
Updated 2024-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
Select
Count(distinct ORIGIN_FROM_ADDRESS) Unique_user,
Count(distinct tx_hash) as total_transaction,
Date_trunc('day', block_timestamp ) as day
From
arbitrum.core.ez_decoded_event_logs
Where
event_name = 'LiFiTransferStarted'
and block_timestamp::date >= current_timestamp - interval '30 days'
and ORIGIN_TO_ADDRESS = lower('0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae')
and decoded_log:bridgeData:integrator = 'jumper.exchange'
Group by day
Order by day desc
QueryRunArchived: QueryRun has been archived