with main AS (

SELECT a_pos_owner.tx_id, a_pos_owner.block_timestamp,

a_pos_owner.attribute_value AS trader

FROM

osmosis.core.fact_msg_attributes AS a_pos_owner

WHERE a_pos_owner.msg_type like 'wasm-position%'

AND a_pos_owner.attribute_key = 'pos-owner' and block_timestamp::Date BETWEEN '{{START_DATE}}' and '{{END_DATE}}')

, time_periods AS (

SELECT

DATE(block_timestamp) AS date,

COUNT(DISTINCT trader) AS unique_traders

FROM main

WHERE block_timestamp >= DATEADD(DAY, -90, CURRENT_TIMESTAMP)

GROUP BY DATE(block_timestamp)

),

aggregated_periods AS (

SELECT

COUNT(DISTINCT trader) AS unique_traders,

'24h' AS period

FROM main

WHERE block_timestamp >= DATEADD(DAY, -1, CURRENT_TIMESTAMP)

UNION ALL

SELECT

COUNT(DISTINCT trader) AS unique_traders,

'7d' AS period

FROM main

WHERE block_timestamp >= DATEADD(DAY, -7, CURRENT_TIMESTAMP)

UNION ALL