BANANA_CIRC | |
---|---|
1 | 8081485.13066467 |
banterlyticsbanana in circulation coin gecko
Updated 3 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
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
1
20B
22s