MOHAMAD23last month
    Updated 2022-08-10
    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