tx_signer AS "Address",

MIN(block_timestamp) AS "Creation Date",

CURRENT_DATE - MIN(block_timestamp)::date AS "Age of Wallet (Day)",

COUNT(DISTINCT tx_hash) AS "Number of Transactions",

CASE

WHEN CURRENT_DATE - MIN(block_timestamp)::date <= 30 THEN 'Between 0 and 30 Days'

WHEN CURRENT_DATE - MIN(block_timestamp)::date <= 90 THEN 'Between 31 and 90 Days'

WHEN CURRENT_DATE - MIN(block_timestamp)::date <= 180 THEN 'Between 91 and 180 Days'

WHEN CURRENT_DATE - MIN(block_timestamp)::date <= 365 THEN 'Between 181 and 365 Days'

ELSE 'More than 365 Days'

END AS "Wallet Age Range"

FROM

near.core.fact_transactions

WHERE

tx_receiver = 'nethmap.near'

GROUP BY

tx_signer

ORDER BY

"Creation Date" ASC)

SELECT

"Wallet Age Range",

count(DISTINCT "Address" ) as "Number of Wallets"

from t1

GROUP by 1