date_trunc('day', BLOCK_TIMESTAMP) AS Time,

SUM(AMOUNT)/1000 AS "DeadGod UPGRADES", --1000: DUST Price of DEADGODS

(SUM(AMOUNT)/1000 / 9465) * 100 AS "PERCENT CONVERTED" --9465: MAX DEGODS/DEADGODS Available

FROM solana.core.fact_transfers

WHERE TX_TO = 'DEADDUq3NrfqUqDMwsshpqbsqpPhjtJ4AYvyCoYq2SXo'

AND MINT = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

AND AMOUNT > 999

GROUP BY Time