(select -1 + row_number() over(order by 0) i, start_date + i generated_date, 0 as new_nodes_d

from (select '2021-04-10'::date start_date, '2022-01-19'::date end_date)

join table(generator(rowcount => 10000 )) x

qualify i < 1 + end_date - start_date ),

new_nodes as (select

date_trunc('day', block_timestamp) as block_day,

count(distinct(node_address)) as new_node

from thorchain.new_node_events

group by 1 ),

temp_table as (select

days_generator.generated_date as date,

iff(new_nodes.new_node = null, days_generator.new_nodes_d, new_nodes.new_node) as count_new_node

from days_generator

left join new_nodes

on days_generator.generated_date = new_nodes.block_day)

select date, ifnull(count_new_node, 0) as new_nodes_final

from temp_table