eferI > Optimism Airdrop Claimers
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH main AS (
SELECT
BLOCK_TIMESTAMP::date AS date,
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
Run a query to Download Data