sinahosseinzadehUntitled Query
    Updated 2022-08-16

    with claiming_rewards as (select
    date_trunc('day', block_timestamp) as day,
    origin_from_address as users,
    'claiming rewards' as label
    from optimism.velodrome.ez_claimed_rewards),

    lp_actions as (select
    date_trunc('day', block_timestamp) as day,
    origin_from_address as users,
    'lp actions' as label
    from optimism.velodrome.ez_lp_actions),

    staking as (select
    date_trunc('day', block_timestamp) as day,
    origin_from_address as users,
    'staking' as label
    from optimism.velodrome.ez_staking_actions),

    swaps as (select
    date_trunc('day', block_timestamp) as day,
    origin_from_address as users,
    'swapping' as label
    from optimism.velodrome.ez_swaps),

    locks as (select
    date_trunc('day', block_timestamp) as day,
    origin_from_address as users,
    'locking' as label
    from optimism.velodrome.ez_velo_locks),

    votes as (select
    Run a query to Download Data