split_part(attribute_value, 'gamm/pool/', 2)::int as pool_id,

count(distinct tx_id) as superfluids_count,

sum(split_part(attribute_value, 'gamm/pool/', 1)::int / pow(10, 18)) as superfluid_volume

from osmosis.core.fact_msg_attributes

where msg_type = 'superfluid_increase_delegation'

and attribute_key = 'amount'

and tx_succeeded = 1

and block_timestamp > current_date - interval '6 months'

group by 1

order by superfluid_volume desc

limit 10