alirsopbvs-06
Updated 2022-09-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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