SELECT

DATE_TRUNC('Week', BLOCK_TIMESTAMP::DATE) AS Week,

SUM(SWAP_FROM_AMOUNT_USD) AS "Volume swapped from",

COUNT(DISTINCT SWAPPER) AS "Number of Users",

COUNT(DISTINCT TX_ID) As "Transactions"

FROM solana.defi.ez_dex_swaps

WHERE PROGRAM_ID = '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8'

AND BLOCK_TIMESTAMP::DATE BETWEEN '2024-12-01' AND '2024-12-31'

GROUP BY Week

SELECT DISTINCT EVENT_NAME

FROM ethereum.defi.ez_liquid_staking_deposits

SELECT

TB.POOL_NAME,

CONCAT(TC.SYMBOL, '-', TC.SYMBOL) AS TOKEN_PAIR, -- Combine token symbols as pairs

MIN(TB.CREATION_TIME) AS FIRST_CREATION_TIME

FROM ethereum.defi.dim_dex_liquidity_pools TB

JOIN ethereum.core.ez_token_transfers TC

ON TB.POOL_ADDRESS = TC.CONTRACT_ADDRESS

GROUP BY TB.POOL_NAME, TOKEN_PAIR -- Grouping by pool and token pairs

ORDER BY FIRST_CREATION_TIME ASC -- Order by earliest creation time

LIMIT 50; -- Limit the results to the top 50

WITH PoolCreation AS (

SELECT

TB.POOL_NAME,

TB.CREATION_TIME,

TB.POOL_ADDRESS,