0-MIDdst chain by volume
    Updated 2024-10-07
    select split_part(TO_ASSET,'.',1) as dst_chain
    ,sum(FROM_AMOUNT_USD) as volume
    from thorchain.defi.fact_swaps
    where AFFILIATE_ADDRESS='lifi'
    and BLOCK_TIMESTAMP::date>=current_date-90
    and BLOCKCHAIN='BSC'
    and split_part(TO_ASSET,'.',1) not in ('THOR')
    group by 1
    QueryRunArchived: QueryRun has been archived