amirrzTop 10 Matic Stakers
Updated 2022-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT DISTINCT from_address,
sum((tx_json : receipt : logs[2] : decoded : inputs : value :: STRING)/pow(10,18)) as amount_staked
FROM
ethereum.core.fact_transactions
WHERE
(tx_json : receipt : logs[2] : decoded : inputs : value :: STRING)/pow(10,18) IS NOT NULL
AND
to_address = lower('0x9ee91F9f426fA633d227f7a9b000E28b9dfd8599')
AND
block_timestamp::DATE >= '2022-07-01' GROUP BY 1
ORDER BY 2 DESC
LIMIT 10
Run a query to Download Data