select 1 as index, 'ethereum.core.fact_transactions' as flipside_table, max(block_timestamp) as last_entry

from ethereum.core.fact_transactions

union

select 2, 'ethereum.core.fact_event_logs', max(block_timestamp)

from ethereum.core.fact_event_logs

union

select 3, 'ethereum.core.ez_nft_sales', max(block_timestamp)

from ethereum.core.ez_nft_sales

union

select 4, 'ethereum.core.ez_dex_swaps', max(block_timestamp)

from ethereum.core.ez_dex_swaps

union

select 5, 'ethereum.core.ez_nft_mints', max(block_timestamp)

from ethereum.core.ez_nft_mints

ORDER by 1

SELECT *,

TO_TIMESTAMP_NTZ(current_timestamp) as last_query_run,

datediff('minute', TO_TIMESTAMP_NTZ(current_timestamp), last_entry) as lag_in_minutes

from cte