12 Total Active Wallets Across Chain

yasmin12 Total Active Wallets Across Chain

Updated 3 hours ago

WITH

standard_chains AS (

-- SELECT

-- 'Base' AS blockchain,

-- COUNT(DISTINCT from_address) AS users

-- FROM base.core.fact_transactions

-- WHERE block_timestamp::date >= '2025-03-10'

-- AND TX_SUCCEEDED = 'TRUE'

-- GROUP BY blockchain

-- UNION ALL

SELECT

'Polygon' AS blockchain,

COUNT(DISTINCT from_address) AS users

FROM polygon.core.fact_transactions

WHERE block_timestamp::date >= '2025-03-10'

AND TX_SUCCEEDED = true

GROUP BY blockchain

UNION ALL

-- SELECT

-- 'Avalanche' AS blockchain,

-- COUNT(DISTINCT from_address) AS users

-- FROM avalanche.core.fact_transactions

-- WHERE block_timestamp::date >= '2025-03-10'

-- AND status = 'SUCCESS'

-- GROUP BY blockchain

-- UNION ALL

SELECT

'Ronin' AS blockchain,

COUNT(DISTINCT FROM_ADDRESS) AS users

FROM ronin.core.fact_transactions

WHERE block_timestamp::date >= '2025-03-10'

AND TX_SUCCEEDED = true

GROUP BY blockchain

UNION ALL

SELECT

'Arbitrum' AS blockchain,

Last run: about 3 hours agoAuto-refreshes every 24 hours

131B

76s

flipside