flipside

    USDT Volume daily
    nitsUSDT Volume daily
    Updated 2022-02-17
    SELECT trunc(block_timestamp, 'day') as day , avg(amt)/pow(10,12) as avg_amt_in_K, sum(amt)/pow(10,12) as total_amt_in_K, count(*) as total_txs
    from
    (
    (SELECT
    *, abs(posttokenbalances[0]:uiTokenAmount:amount - pretokenbalances[0]:uiTokenAmount:amount) as amt
    from solana.events
    where posttokenbalances[0]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or
    posttokenbalances[0]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' )
    UNION ALL
    (SELECT
    *, abs(posttokenbalances[1]:uiTokenAmount:amount - pretokenbalances[1]:uiTokenAmount:amount) as amt
    from solana.events
    where posttokenbalances[1]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or
    posttokenbalances[1]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' )
    UNION all
    (SELECT
    *, abs(posttokenbalances[2]:uiTokenAmount:amount - pretokenbalances[2]:uiTokenAmount:amount) as amt
    from solana.events
    where posttokenbalances[2]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or
    posttokenbalances[2]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' )
    UNION ALL
    (SELECT
    *, abs(posttokenbalances[3]:uiTokenAmount:amount - pretokenbalances[3]:uiTokenAmount:amount) as amt
    from solana.events
    where posttokenbalances[3]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or
    posttokenbalances[3]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' )
    UNION ALL
    (SELECT
    *, abs(posttokenbalances[4]:uiTokenAmount:amount - pretokenbalances[4]:uiTokenAmount:amount) as amt
    from solana.events
    where posttokenbalances[4]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or
    posttokenbalances[4]:mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' )
    UNION ALL
    (SELECT
    *, abs(posttokenbalances[5]:uiTokenAmount:amount - pretokenbalances[5]:uiTokenAmount:amount) as amt
    from solana.events
    Run a query to Download Data