SELECT BLOCK_TIMESTAMP::date as DAY,

COUNT (DISTINCT TX_HASH) as staking

FROM optimism.velodrome.ez_staking_actions

WHERE STAKING_ACTION_TYPE = 'deposit'

AND (TOKEN0_SYMBOL = 'OP' or TOKEN1_SYMBOL = 'OP')

GROUP BY DAY

),

active_user as (

SELECT BLOCK_TIMESTAMP::date as DAY,

COUNT (DISTINCT TX_HASH) as Totaltransaction

FROM optimism.core.fact_transactions

GROUP BY DAY

SELECT *,

(staking/Totaltransaction)*100 as Percentage

FROM staking_daily t1 JOIN active_user t2 on t1.day = t2.day