alirsopbvs-01
    Updated 2022-09-03
    SELECT block_timestamp::date as Date,
    case
    when block_timestamp::date >= '2022-07-07' and block_timestamp::date <= '2022-08-04' then 'A month befor 4 Aug'
    else 'A month after 4 Aug'
    end as type,pool_name,count(DISTINCT tx_hash) as stake_count,count(DISTINCT origin_from_address) as Stakers
    FROM optimism.velodrome.ez_staking_actions where date>='2022-07-07' and date<='2022-09-02' and
    STAKING_ACTION_TYPE='deposit'
    GROUP BY 1,2,3
    Run a query to Download Data