kasadeghUntitled Query
    Updated 2022-08-10
    with Tornado_Cash_address AS
    (
    select ADDRESS
    from flipside_prod_db.crosschain.address_labels
    where lower(PROJECT_NAME) like '%tornado cash%' and BLOCKCHAIN='ethereum'
    )
    select BLOCK_TIMESTAMP::date as day,
    count(FROM_ADDRESS) AS daily_address_count,
    avg(daily_address_count) over (order by day rows BETWEEN 7 PRECEDING AND CURRENT ROW) as "7_day_SMA",
    avg(daily_address_count) over (order by day rows BETWEEN 30 PRECEDING AND CURRENT ROW) as "30_day_SMA",
    avg(daily_address_count) over (order by day rows BETWEEN 90 PRECEDING AND CURRENT ROW) as "90_day_SMA"
    from ethereum.core.fact_transactions
    where TO_ADDRESS in (select ADDRESS from Tornado_Cash_address)
    AND FROM_ADDRESS NOT IN (select ADDRESS from Tornado_Cash_address)
    and STATUS='SUCCESS'
    and day >= '2022-01-01'
    group by day
    order by day


    Run a query to Download Data