SELECT
DATE_TRUNC('day', block_timestamp) AS day,
SUM(amount) AS total_xgrnd_issued
FROM
kaia.core.ez_token_transfers
WHERE
contract_address = LOWER('0x9bcb2efc545f89986cf70d3adc39079a1b730d63')
AND block_timestamp >= '2023-11-01'
GROUP BY
day
ORDER BY
day DESC;