DELEGATOR_ADDRESS,

label,

sum(

amount / pow(10, decimal)

) as volume,

COUNT(distinct TX_ID) as transection_stakings

from

osmosis.core.fact_superfluid_staking x

left join osmosis.core.fact_validators y on x.validator_address = y.address

where

CURRENCY is not NULL

and label is not null

and replace(CURRENCY, 'gamm/pool/') in (

1, 678, 704, 712, 674, 722, 9, 604, 497,

812, 584, 3, 481, 42, 463, 15

)

and TX_SUCCEEDED = 'TRUE'

AND ACTION = 'delegate'

and BLOCK_TIMESTAMP :: date >= CURRENT_DATE - 90

group by

DELEGATOR_ADDRESS ,label

order by

volume DESC

limit 10