iboo-jbj2MVStablecoin Popularity
    Updated 2022-02-03
    with USDC1 AS( SELECT date_trunc(day,block_timestamp) as dat, count(tx_id) as USDC
    from solana.transactions where (PRE_MINT= 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or post_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
    and block_timestamp >= '2022-01-01' and succeeded = 'TRUE' group by 1
    ),
    USDT1 AS( SELECT date_trunc(day,block_timestamp) as dat, count(tx_id) as USDT
    from solana.transactions where (PRE_MINT= 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or post_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
    and block_timestamp >= '2022-01-01' and succeeded = 'TRUE' group by 1
    ),
    UST1 as( SELECT date_trunc(day,block_timestamp) as dat, count(tx_id) as UST
    from solana.transactions where(PRE_MINT= '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' or post_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i')
    and block_timestamp >= '2022-01-01' and succeeded = 'TRUE' group by 1
    )
    select UST1.dat as day,
    USDC,
    USDT,
    UST
    from UST1 JOIN USDT1 ON UST1.dat = USDT1.dat JOIN USDC1 ON UST1.dat = USDC1.dat GROUP by 1,2,3,4
    Run a query to Download Data