SELECT block_timestamp,

tx_hash, to_address as user_address, amount_usd

FROM

arbitrum.core.ez_native_transfers

WHERE

origin_function_signature IN ('0x6ba4c138')

AND from_address = lower('0x1cdc19b13729f16c5284a0ace825f83fc9d799f4')

AND block_timestamp >= '2024-06-26'

-- and tx_hash = '0x93bf4ddc63b1a61a507cb475df13f79652fba7abce16c7a96fa83f2246d484a1'

SELECT

DATE_TRUNC('Day', block_timestamp) AS Date,

COUNT(DISTINCT tx_hash) AS daily_claim,

SUM(amount_usd) AS daily_amount_usd,

SUM(COUNT(DISTINCT tx_hash)) OVER (ORDER BY date) AS cumulative_claim,

SUM(SUM(amount_usd)) OVER (ORDER BY date) AS cumulative_amount_usd,

COUNT(DISTINCT user_address) AS daily_claimer

FROM

claims_with_amount

GROUP BY

date

ORDER BY

date DESC;