SELECT
DATE_TRUNC('day', block_timestamp) AS DAY,
COUNT(DISTINCT tx_hash) AS TRANSFERS_COUNT,
COUNT(DISTINCT account_address) as address
FROM
APTOS.core.fact_transfers
WHERE
token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' --USDC LayerZero address
AND block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
AND success = TRUE
AND transfer_event = 'DepositEvent'
GROUP BY
DAY
ORDER BY
DAY DESC