connorhUtility Events Example
Updated 2021-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH utility_driver_stack AS (
SELECT tx_id,from_address AS driver_address, from_address_name AS driver_address_name
FROM gold.ethereum_transactions
WHERE block_timestamp >= '2020-10-15' AND function_signature NOT IN ('0xa9059cbb','0xa9059cb')
AND to_address IN ( '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984',
'0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f',
'0xf164fc0ec4e93095b804a4795bbe1e041497b92a')
)
SELECT driver_address,driver_address_name, COUNT(tx_id) AS utility_events
FROM utility_driver_stack
GROUP BY 1,2
ORDER BY 3 DESC
LIMIT 100
;
Run a query to Download Data