Query editor
/*Table(s): ethereum.transactionsReason: Raw tables recommendedTable(s): ethereum.contracts_submittedReason: Curated dataset recommendations*/WITH filtered_transactions AS (SELECT"from",block_dateFROM ethereum.transactionsWHERE block_date IS NOT NULL AND "from" IS NOT NULLAND block_date BETWEEN DATE '2015-01-01' AND DATE '2024-08-20'), wallet_creation AS (SELECT"from" AS wallet,MIN(DATE_TRUNC('month', block_date)) AS creation_monthFROM filtered_transactionsGROUP BY "from"), wallet_activity AS (SELECT"from" AS wallet,DATE_TRUNC('month', block_date) AS month,COUNT(*) AS tx_countFROM filtered_transactionsGROUP BY "from", DATE_TRUNC('month', block_date)), active_wallets AS (SELECTwc.wallet,wc.creation_month AS activation_monthFROM wallet_creation AS wcJOIN wallet_activity AS waON wc.wallet = wa.walletAND wc.creation_month = wa.monthWHEREwa.tx_count > 4 AND wa.tx_count < 501), trend AS (SELECTactivation_month,COUNT(DISTINCT wallet) AS new_active_walletsFROM active_walletsGROUP BY activation_month)SELECTactivation_month,new_active_walletsFROM trendORDER BY activation_month