split(pool_name, '-')[0] as poolname,

count (distinct tx_id) as Transactions,

count (distinct from_address) as Users,

sum (coalesce (rune_amount_usd,asset_amount_usd)) as Volume,

avg (coalesce (rune_amount_usd,asset_amount_usd)) as Average_Volume,

sum (Transactions) over (partition by poolname order by date) as Cumulative_Transactions,

sum (Volume) over (partition by poolname order by date) as Cumulative_Volume

from thorchain.defi.fact_liquidity_actions

where poolname in ('AVAX.USDC','AVAX.AVAX','AVAX.SOL')

and block_timestamp >= '{{Start_Date}}' and block_timestamp <= '{{End_Date}}'

and lp_action = 'add_liquidity'

group by 1,2

order by 1 desc