banterlyticsbanana-overview
    Updated 17 hours ago
    select * from
    (select * 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 from_address = lower('0x0000000000000000000000000000000000000000') and block_timestamp > current_date - 30 then raw_amount/pow(10,18) end),0) as eBanana_claim_30,
    COALESCE(sum(case when from_address = lower('0x0000000000000000000000000000000000000000') and block_timestamp > current_date - 7 then raw_amount/pow(10,18) end),0) as eBanana_claim_7
    from ethereum.core.fact_token_transfers
    where block_timestamp > '2022-02-27'
    and contract_address = lower('0x94e496474F1725f1c1824cB5BDb92d7691A4F03a')) a

    union all

    select * from
    (SELECT
    COALESCE(sum(case when to_address = lower('0x0000000000000000000000000000000000000000') then raw_amount/pow(10,18) end),0) as eBanana_burnt,
    COALESCE(sum(case when to_address = lower('0x0000000000000000000000000000000000000000') and block_timestamp > current_date - 30 then raw_amount/pow(10,18) end),0) as eBanana_burnt_30,
    COALESCE(sum(case when to_address = lower('0x0000000000000000000000000000000000000000') and block_timestamp > current_date - 7 then raw_amount/pow(10,18) end),0) as eBanana_burnt_7

    from ethereum.core.fact_token_transfers
    where block_timestamp > '2022-02-27'
    and contract_address = lower('0x94e496474F1725f1c1824cB5BDb92d7691A4F03a')) b

    union all

    select * from
    (SELECT
    COALESCE(sum(case when to_address = lower('0x000000000000000000000000000000000000dead') then raw_amount/pow(10,18) end),0) as pBanana_burnt,
    COALESCE(sum(case when to_address = lower('0x000000000000000000000000000000000000dead') and block_timestamp > current_date - 30 then raw_amount/pow(10,18) end),0) as pBanana_burnt_30,
    COALESCE(sum(case when to_address = lower('0x000000000000000000000000000000000000dead') and block_timestamp > current_date - 7 then raw_amount/pow(10,18) end),0) as pBanana_burnt_7
    from polygon.core.fact_token_transfers
    where block_timestamp > '2022-02-27'
    and contract_address = lower('0xbC91347e80886453F3f8bBd6d7aC07C122D87735')) c

    union all
    select * from
    Last run: about 17 hours agoAuto-refreshes every 24 hours
    EBANANA_CLAIM
    EBANANA_CLAIM_30
    EBANANA_CLAIM_7
    1
    12470343.8444363132835.01944444420332.231944444
    2
    152548110110
    3
    2312160.4727494700
    4
    285000000
    5
    925301.75481119600
    5
    130B
    19s