Query editor
WITH fee_tx AS (SELECTaa.block_date,aa.tx_id,aa.balance_change / 1e9 AS fee_solFROM solana.account_activity aaWHERE aa.address = 'uxtoRPdPjRekYmxs1uUqVRZWh38iqonc9KgPuZXPeSY'AND aa.tx_success = trueAND aa.token_mint_address IS NULLAND aa.balance_change > 0AND aa.block_date >= current_date - interval '7' day),tx_user AS (SELECTid,signerFROM solana.transactionsWHERE block_date >= current_date - interval '7' day)SELECTf.block_date,COUNT(*) AS created_token_count,COUNT(DISTINCT t.signer) AS active_users,SUM(f.fee_sol) AS total_fee_sol,SUM(f.fee_sol) * 85 AS total_fee_usdFROM fee_tx fLEFT JOIN tx_user tON f.tx_id = t.idGROUP BY 1ORDER BY 1 DESC