Query editor
WITH active_users AS (SELECTtrader_id,DATE(block_time) AS trade_date /* 用户每次交易的日期 */FROM dex_solana.tradesWHEREproject = 'raydium'AND block_time >= TRY_CAST('2024-01-01 00:00:00' AS TIMESTAMP)AND amount_usd > 1GROUP BYtrader_id,2)SELECTtrade_date, /* 活跃日期 */COUNT(DISTINCT trader_id) AS daily_active_users_count /* 每日活跃用户数量 */FROM active_usersGROUP BYtrade_dateORDER BYtrade_date