select min(BLOCK_TIMESTAMP)as min_date

,TX_FROM

from osmosis.core.fact_transactions

group by 2),

tab2 as (

select BLOCK_TIMESTAMP

, POOL_ID[0] as pool_num

,LIQUIDITY_PROVIDER_ADDRESS

from osmosis.core.fact_liquidity_provider_actions

group by 1,2,3)

select

,count(distinct LIQUIDITY_PROVIDER_ADDRESS)as lpers

from tab1

left join tab2

on min_date=BLOCK_TIMESTAMP

and TX_FROM=LIQUIDITY_PROVIDER_ADDRESS

group by 1