MLDZMNcash.sn8
Updated 2022-08-10Copy 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
›
⌄
with tornado as (select
ADDRESS
from flipside_prod_db.crosschain.address_labels where PROJECT_NAME= 'tornado cash'
),
total as (select
a.ORIGIN_FROM_ADDRESS as interactors,
count(distinct a.tx_hash) as total_trnasactions,
sum(AMOUNT_USD) as currency_usage
from ethereum.core.fact_event_logs a join ethereum.core.ez_token_transfers b on a.tx_hash=b.tx_hash
where a.CONTRACT_ADDRESS in (select ADDRESS from tornado)
and a.BLOCK_TIMESTAMP>=CURRENT_DATE-30
group by 1
)
select
case when total_trnasactions<2 then '1 transaction'
when total_trnasactions between 2 and 5 then '2-5 transactions'
when total_trnasactions between 5 and 10 then '5-10 transactions'
when total_trnasactions between 10 and 20 then '10-20 transactions'
when total_trnasactions>=20 then 'Above 20 transactions'
end as gp,
count(distinct interactors) as wallets
from total
group by gp having gp is not null
Run a query to Download Data