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

lp_action,

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 = '{{Specific_Pool}}'

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

group by 1,2,3

order by 1 desc