banterlyticsbanana in circulation coin gecko
    Updated 3 hours ago
    SELECT (sum(eBanana_claim)- (sum(eBanana_burnt)+ sum(pBanana_burnt))- (sum(vBanana) - sum(vBanana_out))) as banana_circ


    from
    (SELECT
    COALESCE(SUM(CASE WHEN from_address = LOWER('0x0000000000000000000000000000000000000000') THEN raw_amount / POW(10, 18) END), 0) AS eBanana_claim,
    COALESCE(SUM(CASE WHEN to_address = LOWER('0x0000000000000000000000000000000000000000') THEN raw_amount / POW(10, 18) END), 0) AS eBanana_burnt,
    0 AS pBanana_burnt,
    COALESCE(SUM(CASE WHEN to_address = LOWER('0x266a647b991123770dc23b42151e85f563e07359') THEN raw_amount / POW(10, 18) END), 0) AS vBanana,
    COALESCE(SUM(CASE WHEN from_address = LOWER('0x266a647b991123770dc23b42151e85f563e07359') THEN raw_amount / POW(10, 18) END), 0) AS vBanana_out
    FROM
    ethereum.core.fact_token_transfers
    WHERE
    block_timestamp > '2022-02-27'
    AND contract_address = LOWER('0x94e496474F1725f1c1824cB5BDb92d7691A4F03a')
    UNION ALL
    SELECT
    0 AS eBanana_claim,
    0 AS eBanana_burnt,
    COALESCE(sum(case when to_address = lower('0x000000000000000000000000000000000000dead') then raw_amount/pow(10,18) end),0) as pBanana_burnt,
    0 AS vBanana,
    0 AS vBanana_out
    FROM
    polygon.core.fact_token_transfers
    WHERE
    block_timestamp > '2022-02-27'
    AND contract_address = LOWER('0xbC91347e80886453F3f8bBd6d7aC07C122D87735'))

    Last run: about 3 hours agoAuto-refreshes every 6 hours
    BANANA_CIRC
    1
    8081485.13066467
    1
    20B
    22s