flipside

    Glyph Top Liquidity Providers
    Zanyar_98Glyph Top Liquidity Providers
    Updated 2025-04-09
    WITH GLYPH_ALL_POOLS AS (
    SELECT
    *
    FROM
    $query('4f7ebdff-67ee-4b42-912e-c5b0f66ed520')
    ),

    GLYPH_ASSETS_PRICE_USD AS (
    SELECT
    *
    FROM
    $query('77887ba1-8488-46dc-8f8d-cbc64b91ed4c')
    ),

    BTC_PRICE AS (
    (
    SELECT
    HOUR::DATE AS DATE,
    AVG(PRICE) AS PRICE_USD
    FROM
    BITCOIN.PRICE.EZ_PRICES_HOURLY
    WHERE
    DATE < CURRENT_DATE AND SYMBOL = 'BTC' AND DATE >= '2024-03-01'
    AND
    IS_NATIVE = TRUE
    GROUP BY 1
    )
    UNION
    (
    SELECT
    CURRENT_DATE AS DATE,
    VALUE[1]::FLOAT AS PRICE_USD
    FROM
    (SELECT LIVEQUERY.LIVE.UDF_API('GET', 'https://api.coingecko.com/api/v3/coins/bitcoin/market_chart?vs_currency=usd&days=1&interval=daily&precision=10', {'accept': 'application/json', 'x-cg-demo-api-key': 'CG-9moWcKkAVDcd6W1DzJrc3Ux6'}, {}) AS RESP), LATERAL FLATTEN (INPUT => RESP:data:prices)
    ORDER BY DATE_TRUNC('HOUR',TO_TIMESTAMP(VALUE[0]::STRING)) DESC
    LIMIT 1
    Last run: 17 days agoAuto-refreshes every 24 hours
    Address
    Total Supplied ($)
    Supplied Assets
    1
    		0x566632eecd46c7a7c49f6db558dfe79a9e88ac5d$1.41M$24.851 aBTC | $12.607K stCORE
    2
    		0xa1000efc513b510f9aa6fc90baf2f81692dbdef2$1.34M$20881.29M CTO | $1904.404M CFO
    3
    		0x26d272188dddc0106b22e15599f1573e442ac6ac$1.18M$601.791K WCORE | $112.582K USDC | $98.911K USDT | $1.146 COREBTC
    4
    		0xdf90df9c95d86374376a1575c24f206bd6738894$1.11M$1.964M WCORE | $1.151 SolvBTC.CORE
    5
    		0x175ee339109c1c71755a4e025d276b5c2aafc03c$1.02M$518.436K WCORE | $489.272K stCORE
    5
    491B
    46s