datavortexSTAKED tOKENS
Updated 2024-11-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH staking AS (
SELECT
tx_hash,
staker_address,
amount_usd,
program_name
FROM
crosschain.olas.ez_olas_staking
)
SELECT
program_name,
staker_address,
COUNT(DISTINCT tx_hash) AS "number of stakes",
SUM(amount_usd) AS "total volume staked"
FROM
staking
GROUP BY
program_name,
staker_address
ORDER BY
"number of stakes" DESC,
"total volume staked" DESC
LIMIT 10;
QueryRunArchived: QueryRun has been archived