MOHAMAD23last month
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with addresses as (
select ADDRESS , ADDRESS_NAME
from ethereum.core.dim_labels
where label like '%tornado cash%'
)
select count (distinct TX_HASH) , ADDRESS_NAME
from ethereum.core.fact_transactions
join addresses on ethereum.core.fact_transactions.TO_ADDRESS=addresses.ADDRESS
where BLOCK_TIMESTAMP >= DATEADD(month, - 1, GETDATE())
AND BLOCK_TIMESTAMP <= getdate()
group by 2
order by 1 desc
limit 10
Run a query to Download Data