Query editor
WITH flo_transfer AS (SELECT"from" AS wallet,-SUM(TRY_CAST(value AS DOUBLE)) AS flo_balanceFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2eGROUP BY1HAVINGSUM(TRY_CAST(value AS DOUBLE)) > 0UNION ALLSELECT"to" AS wallet,SUM(TRY_CAST(value AS DOUBLE)) AS flo_balanceFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2eGROUP BY1), wallet_balances AS (SELECTwallet,SUM(flo_balance) AS flo_balanceFROM flo_transferGROUP BYwalletHAVINGSUM(flo_balance) > 0), latest_price AS (SELECTpriceFROM prices.usdWHEREsymbol = 'FLOKI' AND blockchain = 'ethereum'ORDER BYminute DESCLIMIT 1)SELECTwb.wallet,wb.flo_balance,wb.flo_balance * lp.price AS usd_valueFROM wallet_balances AS wbCROSS JOIN latest_price AS lpORDER BYusd_value DESCLIMIT 100