Query editor
WITHstaked AS (SELECTDATE_TRUNC('day', evt_block_time) AS period,SUM(TRY_CAST(value AS DOUBLE)) / 1e6 AS staked_amount,count(distinct "from") as daily_deposit_userFROM erc20_arbitrum.evt_TransferWHERE contract_address IN (0xaf88d065e77c8cc2239327c5edb3a432268e5831 -- USDC-- 0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9, -- USDT-- 0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8 -- USDC.e)AND "to" = 0x2df1c51e09aecf9cacb7bc98cb1742757f163df7GROUP BY 1),redeemed AS (SELECTDATE_TRUNC('day', evt_block_time) AS period,-- contract_address,SUM(TRY_CAST(value AS DOUBLE)) / 1e6 AS redeemed_amount,count(distinct "to") as daily_withdraw_userFROM erc20_arbitrum.evt_TransferWHERE contract_address IN (0xaf88d065e77c8cc2239327c5edb3a432268e5831 -- USDC-- 0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9, -- USDT-- 0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8 -- USDC.e)AND "from" = 0x2df1c51e09aecf9cacb7bc98cb1742757f163df7GROUP BY 1),combined AS (SELECTs.period,(s.staked_amount - COALESCE(r.redeemed_amount, TRY_CAST(0 AS DOUBLE))) AS amount,daily_deposit_user,daily_withdraw_userFROM staked sLEFT JOIN redeemed rON s.period = r.period)SELECTperiod,amount,SUM(amount) OVER (ORDER BY period) / 1e9 AS cumulative_amount_b,SUM(amount) OVER (ORDER BY period) AS cumulative_amount,daily_deposit_user,daily_withdraw_user,usdc_arb.total_amount as usdc_on_arb,usdc_arb.total_amount - SUM(amount) OVER (ORDER BY period) as usdc_non_hype,SUM(amount) OVER (ORDER BY period) / usdc_arb.total_amount * 100 as percentageFROM combinedleft join query_4430461 usdc_arb using(period)order by 1 desc