hessHourly Number of Transactions by Suspicious Wallets ( Oct4-Oct8)
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with top_user as ( select from_address , count(DISTINCT(tx_hash)) as total
from gnosis.core.fact_transactions
where block_timestamp::date between '2022-10-04' and '2022-10-08'
group by 1
order by 2 desc
limit 5)
,
top_platform as ( select to_address,case when to_address = '0xc38d4991c951fe8bce1a12beef2046ef36b0fa4a' then 'Rinkeby'
when to_address = '0x37efe9b31830653039edc3b212a6e1b882cd46b4' then 'Unknow'
when to_address = '0x22c1f6050e56d2876009903609a2cc3fef83b415' then 'PAOP'
when to_address = '0x5870b0527dedb1cfbd9534343feda1a41ce47766' then 'Kleros Courts'
when to_address = '0x36b9cb8647498b91db009c978fbc099818a8bb26' then 'Mithraeum' else 'Other' end as platform, count(DISTINCT(tx_hash)) as total
from gnosis.core.fact_transactions
where block_timestamp::date between '2022-10-04' and '2022-10-08'
group by 1
order by 2 desc
limit 5)
select trunc(block_timestamp,'hour') as hour , from_address, count(DISTINCT(tx_hash)) as total_tx
from gnosis.core.fact_transactions
where from_address in (select from_address from top_user)
and block_timestamp::date between '2022-10-04' and '2022-10-08'
group by 1,2
Run a query to Download Data