--https://bscscan.com/tx/0x006945588f5892e65c113a35aaa80941cae142394cc6e21d76db8ea7329e8326

a as (

select

ORIGIN_FROM_ADDRESS as user ,

RAW_AMOUNT/pow(10,18) as volume ,

BLOCK_TIMESTAMP ,

TX_HASH

from bsc.core.fact_token_transfers

where

ORIGIN_TO_ADDRESS ='0x3c11e74d8996508c62f1ee0dd2e07a5b1ec36edb'

and

CONTRACT_ADDRESS = '0x9029fdfae9a03135846381c7ce16595c3554e10a'

and

ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'

--tx_hash ='0x006945588f5892e65c113a35aaa80941cae142394cc6e21d76db8ea7329e8326'

select

BLOCK_TIMESTAMP::date as date ,

count(distinct TX_HASH) as trxs ,

count(distinct user) as claimers ,

sum(volume) as ooe ,

sum(ooe) over (order by date ) as cum_ooe ,

sum(trxs) over (order by date ) as cum_trxs ,

sum(claimers) over (order by date ) as cum_claimers ,

avg(volume) as avg ,

19000000-cum_ooe as remaning_ooe ,

172000-cum_claimers as remaining_claimer