KaskoazulTop 2 contracts per protocol
Updated 2022-03-09
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH NEW_USER_ALLTIME AS(
SELECT
tx_id, tx_from as new_user,
min(block_timestamp) as creation_date
FROM
terra.transactions
WHERE TX_STATUS = 'SUCCEEDED'
GROUP BY tx_id, tx_from
),
NEW_USER_90DAYS AS(
SELECT
tx_id, new_user[0] as users
FROM
NEW_USER_ALLTIME
WHERE
creation_date >= CURRENT_DATE - 90
AND array_size (new_user) = 1
),
TX_WITH_LABEL AS (
SELECT
t.tx_id,
t.tx_to[0] as smart_contract,
l.label,
l.label_type,
l.label_subtype,
l.address_name
FROM
terra.transactions t
LEFT JOIN terra.labels l
ON t.tx_to[0] = l.address
WHERE t.tx_id IN (SELECT tx_id FROM NEW_USER_90DAYS)
AND smart_contract IS NOT NULL
),
Run a query to Download Data