Query editor
WITH Prices AS (SELECTcontract_address, blockchain, symbol, decimals, AVG(price) AS PriceFROM prices.usd_latestGROUP BY 1,2,3,4),Arb AS (SELECT evt_block_time, contract_address, amount, 'Deposit' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.Silo_ARB_evt_DepositUNION ALLSELECT evt_block_time, contract_address, -amount AS amount, 'Withdraw' AS Action, asset, depositor AS user, evt_tx_hash, 'arbitrum' AS blockchain, collateralOnly FROM silo_finance_arbitrum.Silo_ARB_evt_WithdrawUNION ALLSELECT evt_block_time, contract_address, -amount AS amount, 'Borrow' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.Silo_ARB_evt_BorrowUNION ALLSELECT evt_block_time, contract_address, amount, 'Repay' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.Silo_ARB_evt_RepayUNION ALLSELECT evt_block_time, contract_address, - seizedCollateral AS amount, 'Liquidate' AS Action, asset, user, evt_tx_hash, 'arbitrum' AS blockchain, NULL AS collateralOnly FROM silo_finance_arbitrum.Silo_ARB_evt_Liquidate),Arb_Data AS (SELECTevt_block_time, a.blockchain, a.contract_address, collateralOnly, amount/(POW(10,COALESCE(decimals,18))) AS amount, (amount * (CASE WHEN asset = 0xd7c9f0e536dc865ae858b0c0453fe76d13c3beac THEN 1 ELSE Price END))/(POW(10,COALESCE(decimals,18))) AS amount_usd, CASE WHEN asset = 0xd7c9f0e536dc865ae858b0c0453fe76d13c3beac THEN 'XAI' ELSE symbol END AS symbol, Action, asset, user, evt_tx_hashFROM Arb aLEFT JOIN Prices b ON a.blockchain = b.blockchain AND asset = b.contract_addressWHERE a.contract_address = 0x0696e6808ee11a5750733a3d821f9bb847e584fb),users AS (SELECT distinct user from Arb),ENS_Nmaes AS (SELECTa.address, MAX(a.name) AS EnsFROM ens.resolver_latest aINNER JOIN users b ON a.address = b.userGROUP BY 1)SELECTevt_block_time, amount, amount_usd, symbol, Action, collateralOnly, user, Ens, evt_tx_hash, '<a href="https://arbiscan.io/tx/' || cast(evt_tx_hash AS VARCHAR) || '" target="_blank">' || '📶' as ArbiScan, SUM(amount_usd) OVER (ORDER BY evt_block_time) AS Cum_Deposit_USD