0-MIDmonthly supplier
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date_trunc('month',BLOCK_TIMESTAMP)as month,count(distinct SUPPLIER)as monthly_supplier_count
, case
when month>='2019-05-01'and month<'2020-01-01'then '2019'
when month>='2020-01-01'and month<'2021-01-01'then '2020'
when month>='2021-01-01'and month<'2022-01-01'then '2021'
when month>='2022-01-01'then '2022' end as time_period
from ethereum.compound.ez_deposits
where month>='2019-05-01'
group by 1
order by 1
Run a query to Download Data