flipside

    Daily Stats of AVAX Pools In THORChain
    Ali3NDaily Stats of AVAX Pools In THORChain
    Updated 2024-07-08
    /*select distinct pool_name
    from thorchain.defi.fact_daily_pool_stats
    where pool_name ilike '%avax%'
    limit 100*/

    select day,
    pool_name,
    split(pool_name, '-')[0] as poolname,
    system_rewards_usd,
    asset_liquidity*asset_price as Asset_Liquidity_USD,
    rune_liquidity*rune_price as Rune_Liquidity_USD,
    Asset_Liquidity_USD + Rune_Liquidity_USD as Balance,
    add_asset_liquidity_usd,
    swap_count,
    total_swap_fees_usd
    from thorchain.defi.fact_daily_pool_stats
    where poolname in ('AVAX.USDC','AVAX.AVAX','AVAX.SOL')
    -- in ('AVAX.AVAX','AVAX/USDC-0XB97EF9EF8734C71904D8002F8B6BC66DD9C48A6E','AVAX.SOL-0XFE6B19286885A4F7F55ADAD09C3CD1F906D2478F','AVAX.USDT-0X9702230A8EA53601F5CD2DC00FDBC13D4DF4A8C7')
    and day >= '{{Start_Date}}' and day <= '{{End_Date}}'
    order by day DESC
    QueryRunArchived: QueryRun has been archived