MLDZMNstake1
    Updated 2023-01-10
    select
    BLOCK_TIMESTAMP::DATE as date,
    case
    when BLOCK_TIMESTAMP>='2022-12-25' then 'Holidays and new year'
    else 'Before holidays' end as days,
    sum(AMOUNT) as volume,
    count(*) as number
    from terra.core.ez_staking
    where action='Delegate'
    and BLOCK_TIMESTAMP>='2022-12-01'
    group by 1,2
    Run a query to Download Data