essential-indigo copy

cloudr3nessential-indigo copy

Updated 2025-03-05

-- forked from yasmin / essential-indigo @ https://flipsidecrypto.xyz/yasmin/q/jrxbhgXHN3oV/essential-indigo

select '1'

-- WITH all_tx AS (

-- SELECT

-- 'Arbitrum' AS blockchain,

-- block_timestamp::date AS date,

-- tx_hash AS tx,

-- from_address AS user

-- FROM arbitrum.core.fact_transactions

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

-- AND status = 'SUCCESS'

-- UNION ALL

-- SELECT

-- 'Axelar' AS blockchain,

-- block_timestamp::date AS date,

-- tx_id AS tx,

-- tx_from AS user

-- FROM axelar.core.fact_transactions

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

-- AND TX_SUCCEEDED = 'TRUE'

-- UNION ALL

-- SELECT

Last run: about 2 months ago

	'1'
1	1