CartanGroupPolygon Retrospective | Unique Active Users by SPECIFIC label copy
99
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
›
⌄
SELECT
DATE_TRUNC('{{period}}',block_timestamp) as date,
COUNT(DISTINCT TX_HASH) as number_transactions,
COUNT(DISTINCT from_address) as unique_active_users,
number_transactions/unique_active_users as txns_per_user,
SUM(TX_FEE) as transaction_fees,
AVG(gas_price) as avg_gas_price,
transaction_fees/unique_active_users as fees_per_user,
transaction_fees/number_transactions as fees_per_txn,
CASE
WHEN to_address = '0x2ab0e9e4ee70fff1fb9d67031e44f6410170d00e' THEN 'mXEN (XEN Crypto)'
WHEN to_address = '0x55dfa13f7e409560ea7d774f82bdcb90c2222222' THEN 'MATIC Disperser Wallet'
WHEN to_address = '0xf267a44c2d07009b3fabca7a6f4acc5c584d7f50' THEN 'XEN + Duckies Wallet'
WHEN to_address = '0xffb9f1907f827709b0ed09b37956cd3c7462abdb' THEN 'DUCKIES (Yellow Duckies)'
WHEN to_address = '0x161201cc373f2df382fb6e74ba09244eecee2b1d' THEN 'Exit wallet fund funnel'
WHEN to_address = '0xe6f1d4eef6ea4cf5ae53eb13549ef52849d5dca3' THEN 'Benji Bananas'
when to_address = '0xf231be40d73a9e73d859955344a4ff74f448df34' then 'Zapper.Fi: Quickswap Zap In'
when to_address = '0xDef1C0ded9bec7F1a1670819833240f027b25EfF' then '0x: Exchange Proxy'
when to_address = '0x8DfDea6A4818d2AA7463edB9A8841cB0c04255aF' then 'Zapper.Fi: Aave Zap In'
ELSE 'Normal Activity'
END AS label
FROM polygon.core.fact_transactions as transactions
WHERE block_timestamp::date < CURRENT_DATE -- today's date is never complete. Please stop showing it, people :)
GROUP BY date, label
ORDER BY date DESC
Run a query to Download Data