kasadeghUntitled Query
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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