Query editor
selectsymbol || '-' || project as symbol_project,sum(b.usd_value) as usd_volume,count(*) as number_of_transfersfrom layerzero.messages aleft join layerzero.transfers b on a.primary_key = b.messages_foreign_keywhere date(ts_source) >= cast('{{OFT Start Date}}' as timestamp)and date(ts_source) <= cast('{{OFT End Date}}' as timestamp)and type_transfer = 'oft'group by symbol, project;