-- Generate the last 7 days from the current date

SELECT

DATEADD(DAY, 1 - ROW_NUMBER() OVER (ORDER BY NULL), CURRENT_DATE()) AS day_date

FROM

TABLE(GENERATOR(ROWCOUNT => 7))

),

combined_transfers AS (

SELECT

user_address,

block_timestamp,

d.day_date,

balance / POWER(10, 18) AS balance -- Adjusting for 18 decimals

FROM

ethereum.core.fact_token_balances tb

LEFT JOIN days d

ON tb.block_timestamp::DATE <= d.day_date

WHERE

LOWER(tb.contract_address) = LOWER('0xaaeE1A9723aaDB7afA2810263653A34bA2C21C7a')

AND LOWER(tb.user_address) != LOWER('0x000000000000000000000000000000000000dead')

),

ranked_transfers AS (

SELECT

user_address,

block_timestamp,

balance,

d.day_date,

ROW_NUMBER() OVER (PARTITION BY d.day_date, user_address ORDER BY block_timestamp DESC) AS rn

FROM combined_transfers ct

JOIN days d ON ct.day_date = d.day_date

),

filtered_transfers AS (

SELECT