mehrancrypto-dxoepqUntitled Query
Updated 2024-04-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with tx1 as (select address , ADDRESS_NAME
from ethereum.core.dim_labels
where label = 'tornado cash'
)
SELECT block_timestamp::date as daily ,
case
when daily <'2022-08-08' then 'Before sanction'
when daily >='2022-08-08' then 'After sanction' end as type ,
count(DISTINCT ORIGIN_FROM_ADDRESS) as wallets , count(tx_hash) as number
from tx1 A , ethereum.core.fact_event_logs B
where address = B.origin_TO_ADDRESS
and B.block_timestamp >='2022-01-01'
GROUP by 1 , 2
QueryRunArchived: QueryRun has been archived