with date_start as (

with dates AS (

SELECT CAST('2024-05-04' AS DATE) AS start_date

UNION ALL

SELECT DATEADD(day, 1, start_date)

FROM dates

WHERE start_date < CURRENT_DATE())

SELECT date_trunc(day, start_date) AS start_date

FROM dates),

claimers as (

select distinct to_address as user

from base.core.ez_token_transfers

where FROM_ADDRESS='0xadf7c35560035944e805d98ff17d58cde2449389'

and BLOCK_TIMESTAMP>='2024-05-06 10:00:00.000'

group by 1),

spec_balance_change as (

select * from

(select date_trunc(day, block_timestamp) as date,

user,

sum(amount) as balance_change

from

(

select BLOCK_TIMESTAMP, TO_ADDRESS as USER, AMOUNT, TX_HASH

from base.core.ez_token_transfers

where CONTRACT_ADDRESS='0x96419929d7949d6a801a6909c145c8eef6a40431'

union all

select BLOCK_TIMESTAMP, FROM_ADDRESS, -AMOUNT, TX_HASH

from base.core.ez_token_transfers

where CONTRACT_ADDRESS='0x96419929d7949d6a801a6909c145c8eef6a40431')

group by 1,2)),

spec_historic_holders as (

select user