recent_wallet_creations AS (

SELECT

tx_signer AS total_wallet,

MIN(block_timestamp) AS time

FROM

near.core.fact_transactions

WHERE

tx_receiver = 'nethmap.near'

AND block_timestamp > '2022-12-01'

GROUP BY

tx_signer

),

daily_tx_counts AS (

SELECT

DATE(block_timestamp) AS date ,

tx_signer AS total_wallet,

COUNT(DISTINCT tx_hash) AS tx_count

FROM

near.core.fact_transactions

INNER JOIN recent_wallet_creations

ON recent_wallet_creations.total_wallet = fact_transactions.tx_signer

GROUP BY

1,2

)

SELECT

date,

total_wallet,

tx_count

FROM

daily_tx_counts

ORDER BY

date DESC,

tx_count DESC;