0xallyzachLens Engagements
Updated 2025-01-07
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
›
⌄
SELECT
date_trunc('day', block_timestamp) AS date,
COUNT(*) AS count,
SUM(COUNT(*)) OVER (PARTITION BY type ORDER BY date) AS cumulative_count,
type
FROM (
SELECT
block_timestamp,
CASE
WHEN origin_function_signature IN ('0xfb78ae6c', '0x8e4fd6a9') THEN 'follow'
-- WHEN origin_function_signature IN ('0x23b872dd', '0x42842e0e') THEN 'transfer'
WHEN origin_function_signature IN ('0x84114ad4', '0xb48951e4') THEN 'collect'
WHEN origin_function_signature IN ('0x963ff141', '0x3b508132') THEN 'post'
WHEN origin_function_signature IN ('0x2faeed81', '0xdf457c34') THEN 'mirror'
WHEN origin_function_signature IN ('0xb6f32d2b', '0x7a375716') THEN 'comment'
ELSE NULL
END AS type
FROM
polygon.core.fact_event_logs
WHERE
contract_address LIKE LOWER('0xDb46d1Dc155634FbC732f92E853b10B288AD5a1d')
) AS subquery
WHERE
type IS NOT NULL
GROUP BY date, type
ORDER BY date desc
QueryRunArchived: QueryRun has been archived