PLATFORM as "Platform",

date_trunc('day', block_timestamp::date) as "Date",

case

when "Date" >= '2022-12-16' and "Date" < '2023-01-01' then 'First Time Period'

else 'Second Time Period (Target)' end as "Timeline",

count(distinct TX_HASH) as "Number of Transaction",

sum("Number of Transaction") over (partition by "Platform" order by "Date") as "Cumulative Number of Transactions",

count(distinct ORIGIN_FROM_ADDRESS) as "Number of Users",

("Number of Transaction"/"Number of Users") as "Average Number of Txs per User",

ROW_number () over (partition by "Platform" order by "Date") as "Days Order"

FROM ethereum.core.ez_dex_swaps

WHERE block_timestamp >= '2022-12-16'

and block_timestamp <= '2023-01-17'

GROUP by 1 , 2 , 3

order by 2 , 1)

union all

(SELECT

PLATFORM_NAME as "Platform",

date_trunc('day', block_timestamp::date) as "Date",

case

when "Date" >= '2022-12-16' and "Date" < '2023-01-01' then 'First Time Period'

else 'Second Time Period (Target)' end as "Timeline",

count(distinct TX_HASH) as "Number of Transaction",

sum("Number of Transaction") over (partition by "Platform" order by "Date") as "Cumulative Number of Transactions",

count(distinct BUYER_ADDRESS) as "Number of Users",

("Number of Transaction"/"Number of Users") as "Average Number of Txs per User",

ROW_number () over (partition by "Platform" order by "Date") as "Days Order"

FROM ethereum.core.ez_nft_sales

WHERE block_timestamp >= '2022-12-16'

and block_timestamp <= '2023-01-17'

GROUP by 1 , 2 , 3

order by 2 , 1)