Yousefi_1994Velodrome Health (Redux) - Claimed Rewards
    Updated 2022-11-16
    with velodrome_claimed_rewards as (
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    concat(split(reward_type, '_')[0], ' ', split(reward_type, '_')[1]) as reward_type,
    claimed_amount_usd as rewards_amount
    from optimism.velodrome.ez_claimed_rewards
    where block_timestamp <= current_date - 1
    )

    select
    block_timestamp::date as "Days",
    reward_type as "Reward Type",
    count(tx_hash) as "Number of Claimed Rewards",
    count(tx_hash) as "Number of Rewards Claimer",
    sum(rewards_amount) as "Amount of Claimed Rewards"
    from velodrome_claimed_rewards
    group by "Days", "Reward Type"

    Run a query to Download Data