WITH op_transfers AS ( SELECT block_timestamp::date AS date, tx_hash, from_address AS wallet, -raw_amount / power(10,18) AS amount,

'send' AS tx_type, from_address AS _from_address, to_address AS _to_address

FROM optimism.core.fact_token_transfers

WHERE contract_address = '0x4200000000000000000000000000000000000042' --op token

AND from_address != '0x0000000000000000000000000000000000000000' --not minted

UNION ALL

SELECT block_timestamp::date AS date, tx_hash, to_address AS wallet, raw_amount / power(10,18) AS amount,

'receive' AS tx_type, from_address AS _from_address, to_address AS _to_address

FROM optimism.core.fact_token_transfers

WHERE contract_address = '0x4200000000000000000000000000000000000042'

AND to_address != '0x0000000000000000000000000000000000000000'),

op_airdrop_claims AS ( SELECT *

FROM op_transfers

WHERE _from_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' --airdrop address

AND wallet != '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de')

SELECT sum(amount) AS op_claimed, count(distinct wallet) AS op_claimers, 100.000 * op_claimed / 214748364.8 AS P_op_claimed, 100.000 * op_claimers / 248699 AS P_claimers

FROM op_airdrop_claims