Afonso_DiazUntitled Query
    Updated 2023-01-28
    with t as (
    select
    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
    )

    select
    avg(superfluids_count) as average_superfluids_count,
    avg(superfluid_volume) as average_superfluid_volume
    from t
    Run a query to Download Data