each chain

yasmineach chain

Updated 2025-02-19

-- WITH all_tx AS (

-- SELECT

-- 'base' AS blockchain,

-- block_timestamp::date AS date,

-- tx_hash AS tx,

-- from_address AS user

-- FROM base.core.fact_transactions

-- WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)

-- AND TX_SUCCEEDED = 'TRUE'

-- -- UNION ALL

-- -- SELECT

-- -- 'Polygon' AS blockchain,

-- -- block_timestamp::date AS date,

-- -- tx_hash AS tx,

-- -- from_address AS user

-- -- FROM polygon.core.fact_transactions

-- -- WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)

-- -- AND status = 'SUCCESS'

-- -- UNION ALL

-- -- SELECT

-- -- 'Solana' AS blockchain,

-- -- block_timestamp::date AS date,

-- -- tx_id AS tx,

-- -- signers[0] AS user

-- -- FROM solana.core.fact_transactions

-- -- WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)

-- -- AND succeeded = true

-- UNION ALL

-- SELECT

-- 'ronin' AS blockchain,

-- block_timestamp::date AS date,

-- TX_HASH AS tx,

-- FROM_ADDRESS AS user

-- FROM ronin.core.fact_transactions

-- WHERE block_timestamp::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)

-- AND TX_SUCCEEDED = true

QueryRunArchived: QueryRun has been archived

flipside