Query editor
WITH bonk_referral_payments AS (SELECTcall_block_time AS block_time,call_block_date AS block_date,amount / 1e5 AS amount_bonk, -- BONK has 5 decimalsaccount_destination AS reward_wallet,token_balance_owner AS reward_wallet_owner,call_tx_id AS tx_idFROMspl_token_solana.spl_token_call_transferCheckedLEFT JOIN solana_utils.token_accounts taON ta.address = account_destinationWHEREaccount_mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263' -- BONK mintAND account_authority = '84DGj4Qpypcaa5uxdzphYzkutEUTvxLWSuWq3BoJLxkp' -- BonkBot authority walletAND call_block_time >= TIMESTAMP '2023-08-17'),aggregated_rewards AS (SELECTCOALESCE(reward_wallet_owner, reward_wallet) AS wallet,COUNT(DISTINCT tx_id) AS reward_tx_count,SUM(amount_bonk) AS total_bonk_received,MIN(block_time) AS first_reward_time,MAX(block_time) AS last_reward_timeFROMbonk_referral_paymentsGROUP BYCOALESCE(reward_wallet_owner, reward_wallet))SELECTRANK() OVER (ORDER BY total_bonk_received DESC) AS rank_position,wallet,ROUND(total_bonk_received, 2) AS total_bonk_received,reward_tx_count,first_reward_time,last_reward_timeFROMaggregated_rewardsORDER BYtotal_bonk_received DESCLIMIT 500;