Active addresses breakdown by TX Count

Abbas_ra21 Active addresses breakdown by TX Count

Updated 4 days ago

-- forked from Daily Active addresses breakdown by TX Count @ https://flipsidecrypto.xyz/studio/queries/2ec6bb01-0999-48b3-93f6-05a716cb6ee8

WITH daily_tx_counts AS (

SELECT

from_address as address,

COUNT(*) as daily_tx_count

FROM swell.core.fact_transactions

GROUP BY 1

)

SELECT

CASE

WHEN daily_tx_count = 1 THEN 'Single TX'

WHEN daily_tx_count BETWEEN 2 AND 5 THEN '2-5 TXs'

WHEN daily_tx_count BETWEEN 6 AND 10 THEN '6-10 TXs'

WHEN daily_tx_count BETWEEN 11 AND 20 THEN '11-20 TXs'

ELSE '20+ TXs'

END as tx_category,

COUNT(DISTINCT address) as unique_addresses

FROM daily_tx_counts

GROUP BY 1

Last run: 4 days ago

90B