theericstonemultichain retention
Updated 2024-04-29
999
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
›
⌄
-- livequery together a bunch of retention analyses
--avalanche
with avalanche as (
with rawdata as (
select live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/005f1487-a00a-4cd1-9b7d-14964ed666ee/data/latest')
as raw
)
select
'avalanche' as chian,
value:COHORT_MONTH as cohort_month,
value:FOLLOW_UP_MONTH as follow_up_month,
value:COHORT_SIZE as cohort_size,
value:RETAINED_ADDRESSES as retained_addresses,
value:RETENTION_RATE_PERCENTAGE as retention_rate_percentage
FROM
rawdata, lateral flatten (input => raw:data)
),
sei as (
with rawdata as (
select live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/88356f9a-9024-4446-839f-a4b47a299d6c/data/latest')
as raw
)
select
'sei' as chian,
value:COHORT_MONTH as cohort_month,
value:FOLLOW_UP_MONTH as follow_up_month,
value:COHORT_SIZE as cohort_size,
value:RETAINED_ADDRESSES as retained_addresses,
value:RETENTION_RATE_PERCENTAGE as retention_rate_percentage
FROM
rawdata, lateral flatten (input => raw:data)
where follow_up_month > '2023-10-02'
),
aptos as (
with rawdata as (
QueryRunArchived: QueryRun has been archived