binhachonUntitled Query
Updated 2022-05-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with blocks as (
select
date_trunc('day', block_timestamp) as time,
count(distinct block_id) as number_of_blocks
from polygon.transactions
group by 1
)
select
date_day,
coalesce(number_of_blocks, 0) as number_of_blocks
from ethereum_core.dim_dates
left join blocks on (date_day = time)
where date_day >= '2021-01-01'
and date_day < getdate()
Run a query to Download Data