alirsVelodrome Health-part-16
Updated 2022-08-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with lp as( select BLOCK_TIMESTAMP::date as date,TX_HASH,ORIGIN_FROM_ADDRESS from optimism.velodrome.ez_lp_actions
where Date>CURRENT_DATE-30 ),
stacking as (SELECT BLOCK_TIMESTAMP::date as date,TX_HASH,ORIGIN_FROM_ADDRESS from optimism.velodrome.ez_staking_actions
where Date>CURRENT_DATE-30),
swap as (SELECT BLOCK_TIMESTAMP::date as date,TX_HASH,ORIGIN_FROM_ADDRESS from optimism.velodrome.ez_swaps
where Date>CURRENT_DATE-30),
lock as (SELECT BLOCK_TIMESTAMP::date as date,TX_HASH,ORIGIN_FROM_ADDRESS from optimism.velodrome.ez_velo_locks
where Date>CURRENT_DATE-30),
vote as (SELECT BLOCK_TIMESTAMP::date as date,TX_HASH,ORIGIN_FROM_ADDRESS from optimism.velodrome.ez_votes
where Date>CURRENT_DATE-30),
base as (select * from lp UNION ALL
select * from stacking UNION ALL
select * from swap UNION ALL
select * from lock UNION ALL
select * from vote )
select Date, count(DISTINCT tx_hash) as Num_TX, count(DISTINCT ORIGIN_FROM_ADDRESS) as num_user from base
group by 1
order by 1
Run a query to Download Data