feyikemiVertex_Total Users
Updated 2024-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
With Vertex_Users AS(
SELECT
l.address,
l.address_name,
l.Project_name,
t.block_timestamp,
t.origin_from_address
FROM
arbitrum.core.dim_labels l
JOIN
arbitrum.core.ez_token_transfers t
ON l.address = t.origin_from_address
WHERE
contract_address = lower('0x95146881b86B3ee99e63705eC87AfE29Fcc044D9')
)
SELECT COUNT(DISTINCT origin_from_address) AS USERS
from vertex_users
QueryRunArchived: QueryRun has been archived