8 | yasmin | Flipside

Updated 6 hours ago

----------------------- Base, Polygon, Solana, Ronin blockchain data-----------

WITH

standard_chains AS (

-- SELECT

-- 'Base' AS blockchain,

-- block_timestamp::date AS date,

-- COUNT(DISTINCT from_address) AS users

-- FROM

-- base.core.fact_transactions

-- WHERE

-- block_timestamp::date >= DATEADD(DAY, -{{period}}, CURRENT_DATE)

-- AND TX_SUCCEEDED = 'TRUE'

-- GROUP BY

-- blockchain, date

-- UNION ALL

SELECT

'Polygon' AS blockchain,

block_timestamp::date AS date,

COUNT(DISTINCT from_address) AS users

FROM

polygon.core.fact_transactions

WHERE

block_timestamp::date >= DATEADD(DAY, -{{period}}, CURRENT_DATE)

AND TX_SUCCEEDED = true

GROUP BY

blockchain, date

UNION ALL

-- SELECT

-- 'avalanche' AS blockchain,

-- block_timestamp::date AS date,

-- COUNT(DISTINCT from_address) AS users

-- FROM

-- avalanche.core.fact_transactions

-- WHERE

-- block_timestamp::date >= DATEADD(DAY, -{{period}}, CURRENT_DATE)

-- AND status = 'SUCCESS'

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

...

214

9KB

51s

flipside