mehdimarjanGnosis Events (last 30 days)
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT block_timestamp::DATE AS DAY, address_name, event_name,
COUNT(DISTINCT tx_hash) AS "Number of Transactions",
COUNT (DISTINCT origin_from_address) "Number of From Addresses",
COUNT (DISTINCT origin_to_address) "Number of To Addresses"
FROM gnosis.core.fact_event_logs
INNER JOIN gnosis.core.dim_labels on address = contract_address
WHERE block_timestamp::DATE BETWEEN CURRENT_DATE - 30 AND CURRENT_DATE - 1
AND event_name IS NOT NULL
GROUP BY 1,2,3
ORDER BY 1
Run a query to Download Data