chispasDeposits USDC LayerZero
    Updated 2023-12-09
    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
    Run a query to Download Data