Query editor
-- WXRP: 0x39fBBABf11738317a448031930706cd3e612e1B9WITH daily_data AS (SELECTdate,xrp_txn_volume_xrp,xrp_txn_volume_xrp * price AS txn_volume_usd,xrp_payment_volume_xrp,xrp_payment_volume_xrp * price AS payment_volume,dex_xrp_pair_volume_xrp,dex_xrp_pair_volume_xrp * price AS dex_xrp_pair_vol_usd ,dex_traders_count_daily,amm_tvl_xrp,amm_tvl_xrp * price AS amm_tvl_usdFROMxrpl.aggregated_metrics_daily xrpLEFT JOINprices.day pON p.contract_address = 0x39fBBABf11738317a448031930706cd3e612e1B9AND p.blockchain = 'ethereum'AND DATE(xrp.date) = DATE(p.timestamp)WHEREdate >= CURRENT_DATE - INTERVAL '12' month)SELECT*,-- XTR Tx VolumeSUM(xrp_txn_volume_xrp) OVER (ORDER BY date) AS cumulative_xrp_txn_volume_xrp,SUM(txn_volume_usd) OVER (ORDER BY date) AS cumulative_txn_volume_usd,AVG(txn_volume_usd) OVER (ORDER BY date ROWS BETWEEN 13 PRECEDING AND CURRENT ROW) AS MA_2W_txs_vol_usd,-- XRT PaymentsSUM(xrp_payment_volume_xrp) OVER (ORDER BY date) AS cumulative_xrp_payment_volume_xrp,SUM(payment_volume) OVER (ORDER BY date) AS cumulative_payment_volume,AVG(payment_volume) OVER (ORDER BY date ROWS BETWEEN 13 PRECEDING AND CURRENT ROW) AS MA_2W_payment_volume,-- DEX Volume on XRP pairsSUM(dex_xrp_pair_volume_xrp) OVER (ORDER BY date) AS cumulative_dex_xrp_pair_volume_xrp,SUM(dex_xrp_pair_vol_usd) OVER (ORDER BY date) AS cumulative_dex_xrp_pair_vol_usd,AVG(dex_xrp_pair_vol_usd) OVER (ORDER BY date ROWS BETWEEN 13 PRECEDING AND CURRENT ROW) AS MA_2W_dex_xrp_pair_vol_usd,-- DEX TradersAVG(dex_traders_count_daily) OVER (ORDER BY date ROWS BETWEEN 13 PRECEDING AND CURRENT ROW) AS MA_2W_dex_traders_count_daily/*AVG(xrp_txn_volume_xrp) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS average_xrp_txn_volume_xrp,SUM(xrp_payment_volume_xrp) OVER (ORDER BY date) AS cumulative_payment_volume_xrp,AVG(xrp_payment_volume_xrp) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS average_xrp_payment_volume_xrp,SUM(dex_xrp_pair_volume_xrp) OVER (ORDER BY date) AS cumulative_dex_xrp_pair_volume_xrp,AVG(dex_xrp_pair_volume_xrp) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS average_dex_xrp_pair_volume_xrp,SUM(amm_xrp_volume_xrp) OVER (ORDER BY date) AS cumulative_amm_xrp_volume_xrp,AVG(amm_xrp_volume_xrp) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS average_amm_xrp_volume_xrp,amm_xrp_volume_xrp - LAG(amm_xrp_volume_xrp, 7) OVER (ORDER BY date) AS change_7d_amm_volume,amm_tvl_xrp - LAG( amm_tvl_xrp, 7) OVER (ORDER BY date) AS change_7d_amm_tvl,amm_pools_count_daily - LAG(amm_pools_count_daily, 7) OVER (ORDER BY date) AS change_7d_amm_pools_count,amm_xrp_pools_count_daily - LAG(amm_xrp_pools_count_daily, 7) OVER (ORDER BY date) AS change_7d_amm_xrp_pools_count_daily,amm_users_count_daily - LAG(amm_users_count_daily, 7) OVER (ORDER BY date) AS change_7d_amm_users_count_daily,dex_xrp_pair_volume_xrp - LAG(dex_xrp_pair_volume_xrp, 7) OVER (ORDER BY date) AS change_7d_dex_xrp_pair_volume_xrp,