jp12Spindl Zed Run - Daily Active Racers
Updated 2023-04-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH raw as (
SELECT date_trunc('day', block_timestamp) as day, FROM_ADDRESS,
CASE
WHEN day < '2022-07-03' THEN 'Before Token Announcement'
WHEN day >= '2022-07-03' and day < '2022-07-28' THEN 'Token Announced'
WHEN day >= '2022-07-28' THEN 'Airdrop Claim Open'
END as type
FROM flipside_prod_db.polygon.udm_events
WHERE 1=1
and contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'
and TO_ADDRESS = '0x89aac1f5ccdd54dd8a09e5c858f19a665e4fa32b'
and ORIGIN_FUNCTION_SIGNATURE = '0x0c53c51c'
UNION
SELECT date_trunc('day', block_timestamp) as day, FROM_ADDRESS,
CASE
WHEN day < '2022-07-03' THEN 'Before Token Announcement'
WHEN day >= '2022-07-03' and day < '2022-07-28' THEN 'Token Announced'
WHEN day >= '2022-07-28' THEN 'Airdrop Claim Open'
END as type
FROM polygon.core.fact_token_transfers
WHERE 1=1
and contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'
and ORIGIN_TO_ADDRESS = '0x89aac1f5ccdd54dd8a09e5c858f19a665e4fa32b'
and ORIGIN_FUNCTION_SIGNATURE = '0x0c53c51c'
)
SELECT day, type, COUNT(DISTINCT FROM_ADDRESS) as weekly_racers
FROM raw
GROUP BY 1, 2
Run a query to Download Data