alirsopbvs-01
Updated 2022-09-03
9
1
2
3
4
5
6
7
8
9
›
⌄
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