Moespf 7
    Updated 2022-12-21
    with pools as
    (SELECT
    column1 as pool_id , column2 as pool_name from (values

    ( '1' , 'ATOM/OSMO')
    ,( '678', 'USDC/OSMO')
    ,( '704', 'WETH/OSMO')
    ,( '712', 'WBTC/OSMO')
    ,( '674', 'DAI/OSMO')
    ,( '722', 'EVMOS/OSMO')
    ,( '9', 'CRO/OSMO')
    ,( '604', 'STARS/OSMO')
    ,( '497', 'JUNO/OSMO')
    ,( '812', 'AXL/OSMO')
    ,( '584', 'SCRT/OSMO')
    ,( '3', 'AKT/OSMO')
    ,( '481', 'EEUR/OSMO')
    ,( '42', 'REGEN/OSMO')
    ,( '463', 'NGM/OSMO')
    ,( '5', 'XPRT/OSMO')))

    ,raw as (select
    pool_id, concat('#' , pool_id , ' (',pool_name,')') as pool,
    sum( AMOUNT/1e18) as del_amount,
    count (distinct DELEGATOR_ADDRESS) as DELEGATORs,
    count (distinct VALIDATOR_ADDRESS) as VALIDATORs,
    del_amount/DELEGATORs as osmo_per_delegator,
    del_amount/VALIDATORs as osmo_per_VALIDATOR,
    del_amount/count (distinct block_timestamp::date) as osmo_per_day,
    DELEGATORs/count (distinct block_timestamp::date) as DELEGATORs_per_day,
    VALIDATORs/count (distinct block_timestamp::date) as VALIDATORs_per_day,
    row_number()over(order by del_amount) as n
    from osmosis.core.fact_superfluid_staking s , pools p
    where action = 'delegate'
    and split(CURRENCY,'/')[2] = pool_id
    Run a query to Download Data