PUFFER_STAKERS | RENZO_STAKERS | PUFFER_RENZO_STAKERS | PUFFER_RENZO_PERCENT | |
|---|---|---|---|---|
1 | 45649 | 17977 | 3806 | 8.3375 |
freemartianpuffer & Renzo stakers
Updated 2024-02-17
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
28
29
30
31
32
33
34
35
36
›
⌄
with renzo_stakers as (
SELECT
origin_from_address AS wallet,
sum (raw_amount/pow(10,18)) AS eth_value,
count (DISTINCT tx_hash) AS transactions
FROM ethereum.core.fact_token_transfers
where contract_address = '0xbf5495efe5db9ce00f80364c8b423567e58d2110'
AND origin_to_address = '0x74a09653a083691711cf8215a6ab074bb4e99ef5'
GROUP BY 1
),
puffer AS (
SELECT
block_timestamp,
tx_hash,
origin_function_signature,
from_address,
to_address,
amount,
amount_usd,
symbol
FROM ethereum.core.ez_token_transfers
WHERE to_address = '0x4aa799c5dfc01ee7d790e3bf1a7c2257ce1dceff'
AND origin_from_address = from_address
AND block_timestamp::date >= '2024-02-01'
),
puffer_stakers AS (
SELECT
from_address AS wallet,
count(tx_hash) AS transactions,
SUM(amount) AS eth_value,
SUM(amount_usd) AS usd_value,
rank() over(ORDER BY SUM(amount) DESC) AS rank
FROM puffer
GROUP BY 1
Last run: over 1 year ago
1
27B
20s