mirror of
https://github.com/FlipsideCrypto/berachain-models.git
synced 2026-02-06 13:17:03 +00:00
27 lines
460 B
SQL
27 lines
460 B
SQL
{{ config (
|
|
materialized = "ephemeral"
|
|
) }}
|
|
|
|
WITH max_time AS (
|
|
|
|
SELECT
|
|
MAX(block_timestamp) AS max_timestamp
|
|
FROM
|
|
{{ ref("silver_testnet__blocks") }}
|
|
)
|
|
SELECT
|
|
MIN(block_number) AS block_number
|
|
FROM
|
|
{{ ref("silver_testnet__blocks") }}
|
|
JOIN max_time
|
|
ON block_timestamp BETWEEN DATEADD(
|
|
'hour',
|
|
-25,
|
|
max_timestamp
|
|
)
|
|
AND DATEADD(
|
|
'hour',
|
|
-24,
|
|
max_timestamp
|
|
)
|