Query editor
-- 5. UPSHIFT USER ACTIVITY (-> table)-- One row per SUCCESS stake/unstake through Yield.xyz, newest first.-- Vault names from the Yield API (GET /v1/yields/{id}); unknown IDs fall back to the raw ID.-- tx_hash = the action's last transaction (the deposit/withdrawal; any approval comes before it).-- =====================================================================SELECTCAST(action_date AS DATE) AS day,partner,action_type,address AS wallet,network,CASE integration_idWHEN 'ethereum-usdc-0x18ee038c114a07f4b08b420fb1e4149a4f357249-upshift-multi-asset-vault' THEN 'Upshift Wildcat USD'WHEN 'ethereum-usdc-0x73b04b604df15a6d920ee62e228548cd88dd3549-upshift-multi-asset-vault' THEN 'SingularV USDC Max Yield'WHEN 'ethereum-usdc-0xe9b725010a9e419412ed67d0fa5f3a5f40159d32-upshift-vault' THEN 'Upshift Core USDC'WHEN 'ethereum-wbtc-0x3cc0d33b1aeac3d23ea89214b3ac5b4607032167-upshift-multi-asset-vault' THEN 'Sentora wBTC'WHEN 'monad-ausd-0x36edbf0c834591bfdfcac0ef9605528c75c406aa-upshift-multi-asset-vault' THEN 'earnAUSD'WHEN 'monad-ausd-0xd793c04b87386a6bb84ee61d98e0065fde7fda5e-upshift-vault' THEN 'Savings AUSD'ELSE integration_idEND AS vault,ROUND(CAST(amount AS DOUBLE), 4) AS native_amount,ROUND(CAST(usd_amount AS DOUBLE), 2) AS usd_volume,tx_hashFROM dune.yieldxyz.dataset_upshift_actionsWHERE CAST(is_partner_facing AS VARCHAR) IN ('true', 't', '1', 'TRUE')ORDER BY 1 DESC, usd_volume DESC;