alirsVelodrome Health-part-13
Updated 2022-08-17
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT BLOCK_TIMESTAMP::date as date,count(DISTINCT TX_HASH) as lock_count,
count(DISTINCT ORIGIN_FROM_ADDRESS) as wallet_count,
sum(VELO_AMOUNT_USD) as lock_amount,VELO_ACTION
-- sum(lock_amount) over (order by date asc) as cum_growth_amount,
-- sum(lock_count) over (order by date asc) as cum_growth_lock_count,
--sum(wallet_count) over (order by date asc) as cum_growth_Wallet_count
from optimism.velodrome.ez_velo_locks
where Date>CURRENT_DATE-30
group by DATE,VELO_ACTION
order by DATE
Run a query to Download Data