a as (

select

ORIGIN_FROM_ADDRESS as claimer ,

RAW_AMOUNT/pow(10,DECIMALS) as volume ,

AMOUNT_USD as USD ,

BLOCK_TIMESTAMP ,

TX_HASH

from ethereum.core.ez_token_transfers

where

ORIGIN_TO_ADDRESS ='0x090e53c44e8a9b6b1bca800e881455b921aec420' and

CONTRACT_ADDRESS = '0xcafe001067cdef266afb7eb5a286dcfd277f3de5' and

ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'

select date_trunc('month' ,BLOCK_TIMESTAMP) AS DATE ,date_trunc('day' ,BLOCK_TIMESTAMP) AS DATE1 ,

count(distinct TX_HASH) as trxs ,

count(distinct claimer) as claimers ,

sum(USD) as USD_ ,

avg(USD) AS avg_USD ,

median(USD) AS MEDIAN_USD ,

max(USD) as maxx_USD ,

min(USD) as minn_USD ,

sum(volume) as psp_ ,

avg(volume) as avg_PSP ,

median(volume) as median_PSP ,

max(volume) as maxx_PSP ,

min(volume) as minn_PSP ,

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

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

sum(PSP_) over (order by date ) as cum_PSP ,

19999-cum_claimers as remaining_claimers ,

19999 as "Eligible Claimers" ,

(cum_claimers / 19999 ) * 100 as "% Of Users Claimed" ,