-- forked from Near Latency - Live @ https://flipsidecrypto.xyz/edit/queries/9bcac25e-71e9-4b77-b83c-04706e689db2

-- forked from Flow Latency - Live @ https://flipsidecrypto.xyz/edit/queries/8b6a8991-90ed-46a1-8c22-61cd0671d1b8

-- forked from Ethereum Latency - Live @ https://flipsidecrypto.xyz/edit/queries/d14442cc-1b9b-47d1-b85d-21943b3943e9

-- forked from ethereum Latency - Live @ https://flipsidecrypto.xyz/edit/queries/665e44a5-aed3-4207-a1a5-d1d16429107c

-- forked from ethereum Latency - Live @ https://flipsidecrypto.xyz/edit/queries/9f739c4b-00cf-4550-9461-c7926d8885f6

-- forked from ethereum Latency - Live @ https://flipsidecrypto.xyz/edit/queries/b8f63300-e92f-456e-8110-7cd834736467

with

bitcoin as (

select

datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,

'bitcoin' as chain,

'fact_blocks' as table_name

from

bitcoin.core.fact_blocks

union

select

datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,

'bitcoin' as chain,

'fact_transactions' as table_name

from

bitcoin.core.fact_transactions

union

select

datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,

'bitcoin' as chain,

'fact_inputs' as table_name

from

bitcoin.core.fact_inputs