LoriYagami-3606Sol attk 2
Updated 2022-10-17
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
›
⌄
with
label as (
select address
from solana.core.dim_labels
where address in
('mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68','5fNfvyp5czQVX77yoACa3JJVEhdRaWjPuazuWgjhTqEH','JD3bq9hGdy38PuWQ4h2YJpELmHVGPPfFSuFkpzAd9zfu')
)
select *
from (
select block_timestamp::date as date,
case when block_timestamp >= '2022-09-01' and block_timestamp <'2022-10-11' then 'Before Mango Hack'
when block_timestamp >= '2022-10-11' then 'After Mango Hack' else null end as type,
count (distinct tx_id) as tx_count,
count (distinct signers[0]) as wallet
from solana.core.fact_transactions
join label
on instructions[0]:programId =address
and block_timestamp >= '2022-09-01'
and succeeded = 'TRUE'
group by 1,2
order by 1
)
where type is not null
Run a query to Download Data