SELECT

DATE_TRUNC(

'day',

block_timestamp

) AS DATE,

velo_action,

COUNT(tx_hash) AS num_txs_d,

SUM(velo_amount) AS velo_deposit,

SUM(velo_amount_usd) AS velo_usd_deposit

FROM optimism.velodrome.ez_velo_locks

WHERE velo_action ILIKE 'deposit'

GROUP BY DATE, velo_action

ORDER BY DATE DESC

),

withdraws AS (

SELECT

DATE_TRUNC(

'day',

block_timestamp

) AS DATE,

velo_action,

COUNT(tx_hash) AS num_txs_w,

SUM(velo_amount)*-1 AS velo_withdraw,

SUM(velo_amount_usd)*-1 AS velo_usd_withdraw

FROM optimism.velodrome.ez_velo_locks

WHERE velo_action ILIKE 'withdraw'

GROUP BY DATE, velo_action

ORDER BY DATE DESC

),

daily_vesting AS (

SELECT

a.DATE,

CASE