Query editor
WITHtokens AS (SELECTfrom_hex(json_query(ac.newConfig, 'strict $.tokenAddress' omit quotes)) AS contract_address,t.symbol AS symbol,'arbitrum' AS price_source,COALESCE(t.decimals, 18) AS decimalsFROM hmx_arbitrum.ConfigStorage_evt_LogSetCollateralTokenConfig AS ccINNER JOIN hmx_arbitrum.ConfigStorage_evt_LogSetAssetConfig AS acON ac.assetId = cc.assetIdLEFT JOIN prices.tokens AS tON from_hex(json_query(ac.newConfig, 'strict $.tokenAddress' omit quotes)) = t.contract_addressAND t.blockchain = 'arbitrum'),token_prices AS (SELECTdate_trunc('hour', p.minute) AS time,p.symbol,p.decimals,t.contract_address,AVG(p.price) AS avg_priceFROM prices.usd pINNER JOIN tokens tON p.contract_address = t.contract_addressAND p.blockchain = t.price_sourceWHERE p.minute >= TIMESTAMP '2023-06-21 00:00'GROUP BY 1, 2, 3, 4),hourly_hlp_rewards_usd AS (SELECTtp.time,SUM(f.feedAmount * tp.avg_price/ POWER(10, tp.decimals)/ date_diff('hour', date_trunc('hour', f.call_block_time), from_unixtime(CAST(f.expiredAt AS bigint)))) AS hourly_reward_usdFROM hmx_arbitrum.FeedableRewarder_call_feedWithExpiredAt fLEFT JOIN token_prices tpON tp.contract_address = 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 -- USDC.eAND tp.time >= date_trunc('hour', f.call_block_time)AND tp.time < from_unixtime(CAST(f.expiredAt AS bigint))GROUP BY tp.time),aum_updates AS (SELECTevt_block_time,aum / 1e30 AS aum_valueFROM (SELECT evt_block_time, aum FROM hmx_arbitrum.LiquidityService_evt_AddLiquidityUNION ALLSELECT evt_block_time, aum FROM hmx_arbitrum.LiquidityService_evt_RemoveLiquidity)),last_aum_in_hour AS (SELECTdate_trunc('hour', evt_block_time) AS time,