-- How many total Metamask wallet holders are there?
-- What’s the average value of ETH held in wallets?
-- What percentage of wallets are engaging in a higher order activity, like staking?
WITH mm_daily AS (
SELECT from_address
, MIN(block_timestamp)::DATE AS date
FROM ethereum.core.fact_transactions
WHERE to_address = '0x881d40237659c251811cec9c364ef91dc08d300c'
GROUP BY from_address
)
SELECT DISTINCT date
, COUNT(from_address) OVER(ORDER BY date) AS daily_cumulative_count
FROM mm_daily
ORDER BY date