Affiliates | WALLET_COUNT | TOTAL_WALLET | START_DATE | END_DATE | |
|---|---|---|---|---|---|
1 | Vultisig (iOS) | 143 | 231 | 08/01/2024 | 2025-03-20 00:00:00.000 |
2 | Vultisig (Web) | 3 | 231 | 08/01/2024 | 2025-03-20 00:00:00.000 |
3 | Vultisig (Android) | 88 | 231 | 08/01/2024 | 2025-03-20 00:00:00.000 |
RayyykVultisig Maya (Users)
Updated 11 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
›
⌄
with table_1 as (select min(block_timestamp) as first_tx,
affiliate_address,
from_address
from maya.defi.fact_swaps
where affiliate_address in ('vi', 'va', 'v0')
group by 2,3)
select case
when affiliate_address in ('vi') then 'Vultisig (iOS)'
when affiliate_address in ('va') then 'Vultisig (Android)'
when affiliate_address in ('v0') then 'Vultisig (Web)'
end as "Affiliates",
count(distinct(from_address)) as wallet_count,
(select count(distinct(from_address)) from table_1) as total_wallet,
case when '{{start_date}}' = '' then '08/01/2024'
else '{{start_date}}'
end as start_date,
case when '{{end_date}}' = '' then current_date
else '{{end_date}}'
end as end_date
from table_1
where first_tx >= start_date and first_tx <= end_date
group by 1
order by 1 desc
Last run: about 11 hours ago
3
200B
2s