larrypenguinContracts Eth Top
Updated 2023-04-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
*
FROM (
SELECT
trunc(BLOCK_TIMESTAMP, 'month') AS time,
COUNT(DISTINCT TX_HASH) AS transactions,
row_number() OVER (PARTITION BY time ORDER BY transactions DESC) as contract_rank,
CONTRACT_ADDRESS
FROM
ethereum.core.fact_decoded_event_logs
GROUP BY
CONTRACT_ADDRESS,
time
ORDER BY
time DESC)
WHERE
contract_rank <= 10
Run a query to Download Data