SELECT

DISTINCT liquidity_provider_address AS address

FROM osmosis.core.fact_liquidity_provider_actions

WHERE block_timestamp >= '2022-01-01' AND tx_status = 'SUCCEEDED'

), stakers_distinct AS (

SELECT

DISTINCT delegator_address AS address

FROM osmosis.core.fact_staking

WHERE block_timestamp >= '2022-01-01' AND tx_status = 'SUCCEEDED'

), lpers_stakers AS (

SELECT * FROM stakers_distinct

UNION

SELECT * FROM lpers_distinct

), hodlers_distinct AS (

SELECT

DISTINCT tx_from AS address

FROM osmosis.core.fact_transactions

WHERE block_timestamp >= '2022-01-01' AND tx_status = 'SUCCEEDED' AND tx_from NOT IN (SELECT address FROM lpers_stakers)

), hodlers AS (

SELECT

TO_DATE(block_timestamp) AS date,

COUNT(*) AS hodlers

FROM osmosis.core.fact_transfers

WHERE date >= '2022-01-01' AND transfer_type = 'IBC_TRANSFER_IN' AND tx_status = 'SUCCEEDED' and receiver IN (SELECT address FROM hodlers_distinct)

GROUP BY date

), lpers AS (

SELECT

TO_DATE(block_timestamp) AS date,

COUNT(*) AS lpers

FROM osmosis.core.fact_transfers

WHERE date >= '2022-01-01' AND transfer_type = 'IBC_TRANSFER_IN' AND tx_status = 'SUCCEEDED' and receiver IN (SELECT address FROM lpers_distinct)

GROUP BY date

), stakers AS (

SELECT

TO_DATE(block_timestamp) AS date,