block_timestamp::date as day,

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 day >= current_date - interval '6 months'

group by 1

avg(superfluids_count) as average_superfluids_count,

avg(superfluid_volume) as average_superfluid_volume

from t