,sum(AMOUNT/1e6) as lp_amount

,rank()over(order by lp_amount) as rank

from terra.core.fact_lp_actions

where ACTION='provide_liquidity'

and CURRENCY='uluna'

and TX_SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP>='2022-12-25' and BLOCK_TIMESTAMP<'2023-01-07'

group by 1

order by 2 desc

limit 10