barbodPylon’s top 2 interacted protocols
Updated 2022-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH new_users AS (
SELECT
tx_from[0] AS wallet,
MIN(block_timestamp)::date AS min_date
FROM terra.transactions
GROUP BY wallet
HAVING min_date >= CURRENT_DATE - 90)
SELECT
address_name,
address as smart_contract_address,
COUNT(tx_id) AS transactions
FROM terra.transactions
JOIN terra.labels ON tx_to[0] = terra.labels.address
WHERE
tx_from[0] IN (SELECT wallet FROM new_users)
AND label = 'pylon'
GROUP BY address_name, smart_contract_address
ORDER BY transactions DESC
LIMIT 2
Run a query to Download Data