SELECT

DATE_TRUNC('day', block_timestamp) AS day,

tx_hash,

event_name,

decoded_log:account::STRING AS claimer,

decoded_log:amount::INT / 1e18 AS amount_claimed

FROM

ethereum.core.fact_decoded_event_logs

WHERE

LOWER(contract_address) IN (

LOWER('0x035bdAeaB85E47710C27EdA7FD754bA80aD4ad02'),

LOWER('0xF532a5A35007804A9cA79E7Fa15D8f648F6D7F28'),

LOWER('0xa105C3AbeDBAf4295AC6149BF24D5311F629934c')

)

AND event_name = 'Claimed'

AND block_timestamp >= '2024-05-01'

),

daily_claims AS (

SELECT

day,

SUM(amount_claimed) AS claimed_this_day

FROM

raw

GROUP BY

day

),

cumulative_claims AS (

SELECT

day,

claimed_this_day,

SUM(claimed_this_day) OVER (ORDER BY day ASC) AS total_claimed

FROM

daily_claims