select

dateadd(

day,

'-' || row_number() over (order by null),

dateadd(day, '+1', current_date())

) as date

from table (generator(rowcount => 36))

),

contract_stablecoin as

(select *

from (SELECT

distinct blockchain,

token_address,

symbol,

name,

decimals,

avg(price) as avg_price

crosschain.price.ez_prices_hourly

GROUP BY

1,

2,

3,

4,

5

avg_price > 0.95

AND avg_price < 1.05)

where blockchain = 'ethereum'),

user_bal as

(select date(block_timestamp) as datetime,

to_address as address,

contract_address,