deposit_hashs AS (

SELECT

TX_HASH AS hashes

FROM external.tokenflow_starknet.decoded_events ev

WHERE ev.CHAIN_ID = 'mainnet'

AND ev.NAME = 'Deposit'

AND ev.CONTRACT = '0x02e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067' --EkuboDeposits

, first_time_deposits AS (

SELECT

CONTRACT AS depositerAddress

, MIN(TIMESTAMP) AS firstDepositedDate

FROM external.tokenflow_starknet.decoded_transactions

WHERE CHAIN_ID = 'mainnet'

AND TX_HASH IN (SELECT hashes FROM deposit_hashs)

GROUP BY 1)

SELECT * FROM (

SELECT

DATE_TRUNC('{{Time_Frame}}', firstDepositedDate) AS "Date"

, COUNT(DISTINCT(depositerAddress)) AS "# New LPers"

, SUM(COUNT(DISTINCT(depositerAddress))) OVER(ORDER BY DATE_TRUNC('{{Time_Frame}}', firstDepositedDate) ) "Total # LPers"

FROM first_time_deposits

GROUP BY 1)

WHERE "Date" >= '2023-09-11'