ashamed-blush copy

vendettaashamed-blush copy

Updated 2024-08-01

-- forked from Jor-el / ashamed-blush @ https://flipsidecrypto.xyz/Jor-el/q/iaS1K8gmyH8A/ashamed-blush

--WITH user_activity_july AS (

-- SELECT

-- from_address AS user,

-- COUNT(DISTINCT tx_hash) AS total_transactions

-- FROM

-- base.core.fact_transactions

-- WHERE

-- block_timestamp BETWEEN '2024-07-01' AND '2024-07-31'

--GROUP BY

--from_address

--),

--active_users_july AS (

-- SELECT

-- user

-- FROM

-- user_activity_july

-- WHERE

--total_transactions > 1

--),

--new_users_july AS (

-- SELECT

-- user

--FROM

-- user_activity_july

-- WHERE

--total_transactions = 1

--),

--metrics_july AS (

-- SELECT

-- COUNT(DISTINCT user_activity_july.user) AS total_users_july,

-- COUNT(DISTINCT active_users_july.user) AS total_active_users_july,

-- COUNT(DISTINCT new_users_july.user) AS total_new_users_july

-- FROM

--user_activity_july

QueryRunArchived: QueryRun has been archived