ramishoowUntitled Query
Updated 2023-01-10
9
1
2
3
›
⌄
select date_trunc('day', block_timestamp) as date1, case when date1 >= '2023-01-01' then '2023' else '2022' END as Year_to_date,
--select date_trunc('day', block_timestamp) as date1, case when date1 >= '2023-01-01' then '2023' else '2022' END as Year_to_date,
count(distinct from_address) as value from ethereum.core.fact_transactions where date1 > current_date - 60 group by 1 order by 1
Run a query to Download Data