UNIUEWALLETS | |
|---|---|
1 | 2004136 |
SpecterDistinct wallet
Updated 2025-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
--Unique wallet addreesses on Blast
WITH WhAllAddreesses AS(
SELECT FROM_ADDRESS AS Addresses -- Joining two address together with union
FROM blast.core.fact_transactions
UNION
SELECT TO_ADDRESS AS Addresses
FROM blast.core.fact_transactions
WHERE
STATUS = 'SUCCESS')
SELECT
COUNT(Addresses) AS UniueWallets
From
WhAllAddreesses
Last run: about 2 months ago
1
11B
11s