Query editor
WITHuni_airdrop_recipients as (SELECTDISTINCT(`account`) as recipients,amount/POW(10, 18) as uni_claimed,evt_block_time as time_claimedFROMuniswap_ethereum.MerkleDistributor_evt_Claimed),recipients_trades as (SELECTCOALESCE(token_a_symbol, token_a_address) as token_a,COALESCE(token_b_symbol, token_b_address) as token_b,trader,version,COUNT(tx_hash) as swaps_num,SUM(usd_amount) as swap_valueFROM(SELECTtoken_a_address,token_a_symbol,token_b_address,token_b_symbol,trader_a as trader,version,tx_hash,usd_amountFROM uniswap.trades dINNER JOINuni_airdrop_recipients urON d.trader_a = ur.recipients) recGROUP BY 1, 2, 3, 4ORDER BY 2 DESC)SELECTCASEWHEN token_a > token_b THEN CONCAT(token_a,'/', token_b)WHEN token_a < token_b THEN CONCAT(token_b, '/', token_a)END as `Pair`,CASEWHEN version = 'v2' THEN 'V2'WHEN version = 'v3' THEN 'V3'END as `Uniswap Version`,SUM(swaps_num) as `No of Swaps`,COUNT(trader) as `No of Traders`,SUM(swap_value) as `Total Swapped Volume`FROMrecipients_tradesGROUP BY 1, 2ORDER BY 5 DESCLIMIT 100