0xHaM-dHot PROJECT
Updated 2024-08-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from Sectors @ https://flipsidecrypto.xyz/edit/queries/aeeca7b7-3299-486f-8ac1-76747bec6226
-- forked from Blockchains @ https://flipsidecrypto.xyz/edit/queries/de69504c-9066-4b63-b13a-0b9ae057c29a
SELECT
-- DATE_TRUNC('{{Time_Interval}}',BLOCK_TIMESTAMP) AS DATE
PROJECT_NAME
,COUNT(*) AS "# Txs"
,COUNT(DISTINCT FROM_ADDRESS) AS "Active users"
FROM sei.core_evm.fact_transactions
JOIN crosschain.core.dim_labels
on from_address = address or to_address = address
WHERE LABEL_TYPE NOT in ('chadmin', 'token')
GROUP by 1
ORDER by 2 DESC
LIMIT 100
QueryRunArchived: QueryRun has been archived