block_timestamp::date as date,

sum(amount/1e18) as "Total Deposit",

count(distinct liquidity_provider_address) as "Number Depositor",

count(distinct tx_id) "Number Deposits",

case when currency = 'ibc/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5' then 'axlWETH'

when currency = 'ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5' then 'gvWETH'

end as Deposits

from osmosis.core.fact_liquidity_provider_actions

where action = 'pool_joined'

and currency in ('ibc/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5' , 'ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5')

and tx_status = 'SUCCEEDED'

group by 1,5