with dates AS (

SELECT CAST('2022-02-10' 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),

axl_stakers_balance_change as (

select * from

(select date_trunc(day, block_timestamp) as date,

user,

sum(amount)/1e6 as balance_change

from

(

select block_timestamp, DELEGATOR_ADDRESS as user, -1* amount as amount, TX_ID as tx_hash

from axelar.gov.fact_staking

where action='undelegate' and TX_SUCCEEDED=TRUE

union all

select block_timestamp, DELEGATOR_ADDRESS, amount, TX_ID

from axelar.gov.fact_staking

where action='delegate' and TX_SUCCEEDED=TRUE)

group by 1,2)),

axl_stakers_historic_holders as (

select user

from axl_stakers_balance_change

group by 1),

user_dates as (

select start_date, user

from date_start, axl_stakers_historic_holders),