SELECT FROM_ADDRESS,

BLOCK_TIMESTAMP,

n/POWER(10,18) AS claim_amount

FROM (

SELECT

FROM_ADDRESS,

EVENT_INPUTS:"value" AS n,

t."TX_HASH",

t.BLOCK_TIMESTAMP

FROM optimism.core.fact_transactions t

INNER JOIN optimism.core.fact_event_logs l

ON t."TX_HASH" = l."TX_HASH"

WHERE TO_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

AND TOPICS[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

AND t.BLOCK_TIMESTAMP > '2022-05-25'

AND STATUS = 'SUCCESS'

) a

)

SELECT time

, op_claimers AS "Hourly claimers"

, op_claimed AS "Hourly claimed"

, SUM(op_claimed) OVER (ORDER BY time RANGE UNBOUNDED PRECEDING) AS "Total claimed"

, 100*(SUM(op_claimed) OVER (ORDER BY time RANGE UNBOUNDED PRECEDING))/214748365 AS "OP % claimed"

, SUM(op_claimers) OVER (ORDER BY time RANGE UNBOUNDED PRECEDING) AS "Total claimers"

, (SUM(op_claimers) OVER (ORDER BY time RANGE UNBOUNDED PRECEDING))/2486.99 AS "OP % claimers"

FROM (

SELECT date_trunc('hour', BLOCK_TIMESTAMP) AS time

, SUM(claim_amount) AS op_claimed

, COUNT(DISTINCT FROM_ADDRESS) AS op_claimers

FROM op_claims

GROUP BY time

) a