0-MIDsrc chain by swaps
    Updated 2024-08-20

    select split_part(TO_ASSET,'.',1) as dst_chain
    ,count(distinct TX_ID) as swaps
    from thorchain.defi.fact_swaps
    where AFFILIATE_ADDRESS='lifi'
    and BLOCK_TIMESTAMP::date>=current_date-60
    and BLOCKCHAIN='BSC'
    and split_part(TO_ASSET,'.',1) not in ('THOR')
    group by 1


    QueryRunArchived: QueryRun has been archived