alirsopbvs-06
    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
    block_timestamp::date>='2022-08-05' and block_timestamp::date<='2022-09-02' and
    STAKING_ACTION_TYPE='deposit'
    GROUP BY 1
    order by 2 DESC
    limit 10
    Run a query to Download Data