Multipartite2022-05-13 TERRA.LUNA Asymmetrical LPers percentage
    Updated 2022-05-13
    WITH
    cointype AS
    (SELECT 'TERRA.LUNA' AS coin),

    coinspecific AS
    (
    SELECT DISTINCT asset_address, rune_address
    FROM thorchain.stake_events, cointype
    WHERE pool_name = coin
    ),

    syms AS
    (
    SELECT DISTINCT asset_address, rune_address
    FROM coinspecific
    WHERE (asset_address IS NOT NULL) AND (rune_address IS NOT NULL)
    ),

    assetasyms AS
    (
    SELECT DISTINCT asset_address
    FROM coinspecific
    WHERE (rune_address IS NULL)
    AND (asset_address NOT IN (SELECT asset_address FROM syms))
    ),

    runeasyms AS
    (
    SELECT DISTINCT rune_address
    FROM coinspecific
    WHERE (asset_address IS NULL)
    AND (rune_address NOT IN (SELECT rune_address FROM syms))
    ),

    counts AS
    (
    Run a query to Download Data