kaibladeEthereum USDC Users Stats
    Updated 2022-11-22
    WITH eth_usdc_data AS
    (SELECT *, from_address AS sender
    FROM ethereum.core.ez_token_transfers
    WHERE contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
    AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '2 months'
    ),

    senders_data AS
    (SELECT sender,
    COUNT(tx_hash) AS transfer_volume
    FROM eth_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



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

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