alirsVelodrome Health-part-16
    Updated 2022-08-17
    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