Query editor
SELECTCOUNT(DISTINCT a.addr_from) AS unique_users,SUM(b.usd_value) AS total_usd_volume,COUNT(*) AS total_transfers,AVG(b.usd_value) AS avg_tx_volume_usd,approx_percentile(b.usd_value, 0.5) AS median_tx_volume_usdFROM layerzero.messages aLEFT JOIN layerzero.transfers bON a.primary_key = b.messages_foreign_keyWHEREb.type_transfer = 'oft'AND (a.source_chain = 'Etherlink'OR a.destination_chain = 'Etherlink')AND a.ts_source >= NOW() - INTERVAL '7' DAY;