ramishoowUntitled Query
    Updated 2023-01-10
    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,
    sum(eth_value) from ethereum.core.fact_transactions where date1 > current_date - 60 and ETH_value is not null group by 1, 2
    Run a query to Download Data