kaibladeAlgoand Daily unique USDC user volume
    Updated 2022-11-22
    WITH algo_usdc_data AS
    (SELECT *
    FROM algorand.core.ez_transfer
    WHERE asset_name = 'USDC'
    AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '2 months')


    SELECT DATE_TRUNC ('days', block_timestamp) AS "Days",
    COUNT(DISTINCT tx_sender) AS "User Volume"
    FROM algo_usdc_data
    GROUP BY "Days"


    Run a query to Download Data