Pine Analyticsripe-maroon
Updated 2024-11-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
week,
count(*) as new_creators,
sum(new_creators) over (order by week) as total_creators
FROM (
SELECT
ORIGIN_FROM_ADDRESS,
date_trunc('week', min(block_timestamp)) as week
from base.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS like lower('0x428aeF7fB31E4E86162D62d4530a4dd7232D953D')
AND origin_function_signature like '0x195cf3ce'
group by 1
)
GROUP BY 1
order 2
QueryRunArchived: QueryRun has been archived