SELECT

DATE_TRUNC('DAY', ft.BLOCK_TIMESTAMP) AS DEPOSIT_DATE,

SUM(ft.AMOUNT) AS TOTAL_DEPOSIT

FROM solana.core.fact_transfers ft

WHERE

ft.BLOCK_TIMESTAMP >= DATEADD(DAY, -6, CURRENT_DATE) -- Adjusted date range for rolling 7 days

AND ft.BLOCK_TIMESTAMP < DATEADD(DAY, 1, CURRENT_DATE)

AND ft.TX_TO = 'HxVZLwAaXH6p6ANkJjQxNXStd3jbKhnd5wdzYvNRqVT3'

AND ft.MINT = '3dgCCb15HMQSA4Pn3Tfii5vRk7aRqTH95LJjxzsG2Mug'

AND ft.TX_FROM != '3LcKTdV47hLhXmaqDqzCqby7Y2pPbvW91RME99rCVQSG'

GROUP BY DEPOSIT_DATE

DATE_TRUNC('DAY', DEPOSIT_DATE) AS DATE,

COALESCE(SUM(TOTAL_DEPOSIT), 0) AS TOTAL_DEPOSIT

FROM DEPOSIT_DATA

GROUP BY DATE

ORDER BY DATE;