theericstonemultichain retention
    Updated 2024-04-29
    -- 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