-- Base

SELECT

to_address AS user,

SUM(amount) AS total_claimed,

--MIN(block_timestamp) AS first_claim_timestamp

FROM base.core.ez_token_transfers

WHERE symbol = 'ZRO'

AND origin_function_signature = '0x0c0c389e'

AND from_address = '0x0000000000000000000000000000000000000000'

AND DATEDIFF('week', '2024-06-20', block_timestamp) <= 1

GROUP BY to_address

UNION ALL

-- Optimism

SELECT

to_address AS user,

SUM(amount) AS total_claimed,

--MIN(block_timestamp) AS first_claim_timestamp

FROM optimism.core.ez_token_transfers

WHERE symbol = 'ZRO'

AND origin_function_signature = '0x0c0c389e'

AND from_address = '0x0000000000000000000000000000000000000000'

AND DATEDIFF('week', '2024-06-20', block_timestamp) <= 1

GROUP BY to_address

UNION ALL

-- Arbitrum

SELECT

to_address AS user,

SUM(amount) AS total_claimed,

--MIN(block_timestamp) AS first_claim_timestamp

FROM arbitrum.core.ez_token_transfers

WHERE symbol = 'ZRO'