jackguyf23n9ej32pif
Updated 2022-07-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH tab1 as (
SELECT
DISTINCT DELEGATOR_ADDRESS
FROM osmosis.core.fact_staking
)
SELECT
avg(ibc_t) as "Average Delegator IBC Transfers"
FROM(
SELECT
sender,
count(*) as ibc_t
FROM osmosis.core.fact_transfers
WHERE sender in (SELECT * FROM tab1)
AND transfer_type LIKE '%IBC_TRANSFER%'
GROUP BY 1
)
Run a query to Download Data