2023-07-27 02:59 AM

sam2023-07-27 02:59 AM

Updated 2023-07-27

with raw as (

select *

-- block_number,

-- block_number - lag(block_number) over (order by block_number asc) as block_diff

from aurora.core.fact_blocks

where block_timestamp ='1970-01-01 00:00:00.000'

)

select *

from raw

limit 10

Run a query to Download Data

flipside