banterlyticsbanana stats overview
    Updated 2022-11-29
    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 - 7 then raw_amount/pow(10,18) end),0) as eBanana_claim_7,
    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,
    eBanana_claim-eBanana_claim_7 as eebanana_last_7,
    eBanana_claim-eBanana_claim_30 as eebanana_last_30
    from ethereum.core.fact_token_transfers
    where block_timestamp > '2022-01-01'
    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 - 7 then raw_amount/pow(10,18) end),0) as eBanana_burnt_7,
    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,
    eBanana_burnt-eBanana_burnt_7 as ebanana_last_7,
    eBanana_burnt-eBanana_burnt_30 as ebanana_last_30
    from ethereum.core.fact_token_transfers
    where block_timestamp > '2022-01-01'
    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 - 7 then raw_amount/pow(10,18) end),0) as pBanana_burnt_7,
    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,
    pBanana_burnt-pBanana_burnt_7 as pbanana_last_7,
    pBanana_burnt-pBanana_burnt_30 as pbanana_last_30
    from polygon.core.fact_token_transfers
    where block_timestamp > '2022-02-28'
    Run a query to Download Data