check_skedAVERAGE USDT TRANSFER SIZE
    Updated 2023-05-11
    WITH daily_avg AS (
    SELECT
    DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS dt,
    CASE
    WHEN DATE_TRUNC('DAY', BLOCK_TIMESTAMP) >= '2023-03-08' AND DATE_TRUNC('DAY', BLOCK_TIMESTAMP) <= '2023-03-13' THEN 'SVB_COLLAPSE'
    ELSE 'USDT_VOLUME'
    END AS bar_name,
    AVG(AMOUNT_USD) AS avg_transfer
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    DATE_TRUNC('DAY', BLOCK_TIMESTAMP) >= '2023-01-01'
    AND CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7'
    GROUP BY
    dt,
    bar_name
    )
    SELECT
    dt,
    bar_name,
    avg_transfer,
    AVG(avg_transfer) OVER (ORDER BY dt ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS avg_transfer_30sma
    FROM
    daily_avg
    ORDER BY
    dt;

    Run a query to Download Data