Query editor
WITH usdv_trades AS (SELECTdate_trunc('minute', block_time) as minute,CASEWHEN token_bought_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C'THEN token_bought_amount / NULLIF(token_sold_amount, 0)ELSE token_sold_amount / NULLIF(token_bought_amount, 0)END as price,CASEWHEN token_bought_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C'THEN token_bought_amountELSE token_sold_amountEND as usdv_volume,amount_usdFROM dex_solana.tradesWHERE ((token_bought_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C'AND token_sold_mint_address IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'))OR(token_sold_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C'AND token_bought_mint_address IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')))AND block_time >= CURRENT_DATE - INTERVAL '90' DAY),vwap_series AS (SELECTminute,SUM(price * usdv_volume) / NULLIF(SUM(usdv_volume), 0) as vwap_price,SUM(amount_usd) as trade_volume_usd,COUNT(*) as trade_countFROM usdv_tradesWHERE price IS NOT NULLGROUP BY minute),time_bounds AS (SELECTdate_trunc('day', MIN(minute)) as start_day,date_trunc('day', MAX(minute)) as end_dayFROM vwap_series),day_series AS (SELECT CAST(day_ts AS TIMESTAMP) as dayFROM time_boundsCROSS JOIN UNNEST(SEQUENCE(CAST(start_day AS TIMESTAMP),CAST(end_day AS TIMESTAMP),INTERVAL '1' DAY)) AS t(day_ts)),minute_grid AS (SELECT CAST(minute_ts AS TIMESTAMP) as minuteFROM day_series