tomilayoodd-silver
Updated 2024-10-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
⌄
SELECT
DISTINCT(FROM_ADDRESS) AS active_user_address,
COUNT(TX_HASH) AS transaction_count
FROM
blast.core.fact_transactions;
WHERE
BLOCK_TIMESTAMP BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
FROM_ADDRESS
HAVING
transaction_count > 0
ORDER BY
transaction_count DESC;
QueryRunArchived: QueryRun has been archived