mehrancrypto-dxoepqUntitled Query
Updated 2024-04-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
with tx1 as (select address , ADDRESS_NAME
from ethereum.core.dim_labels
where label = 'tornado cash'
)
, tx2 as (
SELECT
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-08-08'
GROUP by 1
order by 2 DESC
limit 10
)
, tx3 as(
SELECT
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
GROUP by 1
order by 2 DESC
limit 10
)
SELECT wallets , number , 'After sanction' as type
from tx2 A
UNION
sELECT wallets , number , 'Before sanction' as type
from tx3 A
QueryRunArchived: QueryRun has been archived