SELECT

BLOCK_TIMESTAMP::date AS date,

ROW_NUMBER() OVER (ORDER BY date) AS row_id,

CASE

WHEN row_id = 1 THEN 'TGE day (2022-05-31)'

WHEN row_id = 2 THEN 'One day after TGE'

WHEN row_id = 3 THEN 'Two days after TGE'

WHEN row_id = 4 THEN 'Three days after TGE'

WHEN row_id = 5 THEN 'Four days after TGE'

WHEN row_id = 6 THEN 'Fifth days after TGE'

ELSE 'Other'

END as day_alias,

COUNT(FROM_ADDRESS) AS claimers,

SUM(claimers) OVER(ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative

FROM

optimism.core.fact_transactions

WHERE

TO_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

AND STATUS = 'SUCCESS'

AND ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef'

GROUP BY date

ORDER BY date

SELECT * FROM main

ORDER BY date DESC