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 '1 months'

group by 1

having superfluid_volume < 0