RayyykVultisig LiFi (Users)
Updated 5 hours ago
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with table_1 as (select origin_from_address, decoded_log, block_timestamp, 'Ethereum' as chain
from ethereum.core.ez_decoded_event_logs
where event_name in ('LiFiTransferStarted', 'LiFiGenericSwapCompleted')
and (decoded_log:bridgeData:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0')
or decoded_log:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0'))
and block_timestamp >= '2024-12-01'
union ALL
select origin_from_address, decoded_log, block_timestamp, 'Polygon' as chain
from polygon.core.ez_decoded_event_logs
where event_name in ('LiFiTransferStarted', 'LiFiGenericSwapCompleted')
and (decoded_log:bridgeData:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0')
or decoded_log:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0'))
and block_timestamp >= '2025-01-01'
union ALL
select origin_from_address, decoded_log, block_timestamp, 'BSC' as chain
from bsc.core.ez_decoded_event_logs
where event_name in ('LiFiTransferStarted', 'LiFiGenericSwapCompleted')
and (decoded_log:bridgeData:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0')
or decoded_log:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0'))
and block_timestamp >= '2024-11-01'
union ALL
select origin_from_address, decoded_log, block_timestamp, 'Base' as chain
from base.core.ez_decoded_event_logs
where event_name in ('LiFiTransferStarted', 'LiFiGenericSwapCompleted')
and (decoded_log:bridgeData:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0')
or decoded_log:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0'))
and block_timestamp >= '2024-12-01'
union ALL
select origin_from_address, decoded_log, block_timestamp, 'Arbitrum' as chain
from arbitrum.core.ez_decoded_event_logs
where event_name in ('LiFiTransferStarted', 'LiFiGenericSwapCompleted')
and (decoded_log:bridgeData:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0')
or decoded_log:integrator in ('vultisig-android', 'vultisig-ios', 'vultisig-0'))
and block_timestamp >= '2024-11-01'
union ALL
select origin_from_address, decoded_log, block_timestamp, 'Optimism' as chain