alirsRUNE-01
    Updated 2022-09-06
    SELECT POOL_NAME,
    iff(len(POOL_NAME)>10,(SUBSTRING(POOL_NAME, 0, charindex('-', POOL_NAME, 0)-1)),POOL_NAME)as Pool_Name,
    sum(SWAP_VOLUME_RUNE_USD) as Swap_Volume_USD,
    sum(SWAP_VOLUME_RUNE) as Swap_Volume_RUNE,
    sum(SWAP_COUNT) as Number_of_Swap,
    sum(RUNE_LIQUIDITY) as RUNE_LIQUIDITY,
    sum(TO_RUNE_SWAP_COUNT) as Number_of_Swap_from_asset__to_RUNE,
    sum(TO_ASSET_SWAP_COUNT) as Number_of_Swap_from_RUNE__to_Asset,
    sum(TO_ASSET_SWAP_VOLUME) as Volume_of_Swap_from_RUNE_to_Asset,
    sum(TO_RUNE_SWAP_VOLUME) as Volume_of_Swap_From_Asset_to_RUNE,
    sum(TOTAL_SWAP_FEES_RUNE) as Total_swap_fees_in_RUNE,
    sum(TOTAL_SWAP_FEES_USD) as Total_swap_fees_in_USD,
    sum(UNIQUE_SWAPPER_COUNT) as Number_of_unique_Swapper
    from flipside_prod_db.thorchain.daily_pool_stats
    where SWAP_VOLUME_RUNE_USD>0 and SWAP_VOLUME_RUNE>0
    GROUP by POOL_NAME

    Run a query to Download Data