mmdrezaWeekly Swaps
Updated 2023-05-27Copy Reference Fork
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
›
⌄
with wallet_type as (
select
payer,
proposer,
case
when payer ='0x55ad22f01ef568a1' then 'Blocto wallet'
when payer ='0x18eb4ee6b3c026d2' then 'Dapper wallet'
when payer ='0xecfad18ba9582d4f' then 'JoyRide wallet'
when payer = '0x39e42c67cc851cfb' then 'lilico wallet'
when payer = '0x8234007b36f8113c' then 'Monsoon wallet'
when payer = '0x4bbff461fa8f6192' then 'Fantastec wallet'
when payer= '0x1b65c33d7a352c61' then 'Cricket Moments wallet'
end as wallet
from flow.core.fact_transactions t
join flow.core.fact_events e on t.tx_id = e.tx_id
where event_type = 'TokensWithdrawn'
and t.block_timestamp >= '2023-01-01'
and t.TX_SUCCEEDED ilike 'true'
and wallet is not null)
select
date_trunc('week',block_timestamp) as date,
wallet,
count (distinct tx_id) as tx_count,
count (distinct Trader) as swappers_count
from flow.core.ez_swaps t
join wallet_type w on t.trader = w.proposer
where t.block_timestamp >= '2023-01-01'
group by 1,2
order by 2 desc
Run a query to Download Data