Query editor
selectcount(*) as number_of_transfers,sum(b.usd_value) as usd_volume,count(distinct source_chain || '->' || destination_chain) as pathways,count(distinct source_chain || '-' || addr_from) as unique_addressesfrom layerzero.messages aleft join layerzero.transfers b on a.primary_key = b.messages_foreign_keywhere symbol || '-' || project = '{{OFT Analyzer OFT Name}}';