mirror of
https://github.com/FlipsideCrypto/flow-models.git
synced 2026-02-06 18:26:49 +00:00
23 lines
417 B
SQL
23 lines
417 B
SQL
{{ config(
|
|
severity = "warn",
|
|
error_if = ">100",
|
|
enabled = False
|
|
) }}
|
|
|
|
SELECT
|
|
DATEDIFF(
|
|
SECOND,
|
|
A.block_timestamp,
|
|
b.block_timestamp
|
|
) AS avg_time_diff,
|
|
b.block_height AS bheight,
|
|
b.block_timestamp AS btime,
|
|
A.*
|
|
FROM
|
|
{{ ref('silver__blocks') }} A,
|
|
{{ ref('silver__blocks') }}
|
|
b
|
|
WHERE
|
|
A.block_height = b.block_height -1
|
|
AND avg_time_diff < 0
|