shadilDAI Volume (May 13) transactions volume
    Updated 2022-05-13
    SELECT
    date_trunc('week', block_timestamp) as date,
    sum(amount) as total_amount,
    count(DISTINCT TX_ID) as trx_count,
    'DAI' as type
    FROM ethereum.udm_events
    WHERE event_name = 'transfer'
    AND amount > 0
    AND symbol = 'DAI'
    AND to_label_type is not NULL
    GROUP by date having total_amount < 50000000000

    UNION

    SELECT
    date_trunc('week', block_timestamp) as date,
    sum(amount) as total_amount,
    count(DISTINCT TX_ID) as trx_count,
    'USDC' as type
    FROM ethereum.udm_events
    WHERE event_name = 'transfer'
    AND amount > 0
    AND symbol = 'USDC'
    AND to_label_type is not NULL
    GROUP by date

    UNION

    SELECT
    date_trunc('week', block_timestamp) as date,
    sum(amount) as total_amount,
    count(DISTINCT TX_ID) as trx_count,
    'USDT' as type
    FROM ethereum.udm_events
    WHERE event_name = 'transfer'
    AND amount > 0
    Run a query to Download Data