Afonso_DiazUntitled Query
Updated 2023-01-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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