kaibladeAlgorand USDC Users Stats
    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'),

    senders_data AS
    (SELECT tx_sender AS sender,
    COUNT(tx_id) AS transfer_volume
    FROM algo_usdc_data
    GROUP BY sender)

    -- repeat_senders AS
    -- (SELECT )

    SELECT (SELECT COUNT(sender)
    FROM senders_data WHERE transfer_volume > 1) AS total_repeat_users,
    (SELECT COUNT(sender) FROM senders_data) AS total_senders,
    total_repeat_users*100/total_senders AS percent_repeat_users



    -- algo_daily_price AS
    -- (SELECT DATE_TRUNC ('days', block_timestamp) AS "Days",
    -- SUM(amount) AS "Price Volume in USD"
    -- FROM algo_usdc_data
    -- GROUP BY "Days")

    -- SELECT transfer.*, price."Price Volume in USD"
    -- FROM algo_daily_transfer transfer
    -- FULL JOIN algo_daily_price price
    -- ON transfer."Days" = price."Days"
    Run a query to Download Data