kaibladeAlgorand Transfer Volume vs Price Volume
    Updated 2022-11-21
    WITH algo_usdc_data AS
    (SELECT *
    FROM algorand.core.ez_transfer
    WHERE asset_name = 'USDC'
    AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '2 months'),
    algo_daily_transfer AS
    (SELECT DATE_TRUNC ('days', block_timestamp) AS "Days",
    COUNT(tx_id) AS "Transfer Volume"
    FROM algo_usdc_data
    GROUP BY "Days"),

    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