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

SUM(claim_amount) AS "OP Claimed",

COUNT(DISTINCT FROM_ADDRESS) AS "Addresses Claimed",

100*COUNT(DISTINCT FROM_ADDRESS)/2486 AS "% of Addresses Claimed",

100*SUM(claim_amount)/2147483 AS "% of Airdrop Claimed"

FROM op_claims