datavortexDaily invitations
    Updated 2025-02-27
    WITH event_data AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS event_date,
    origin_from_address,
    tx_hash,
    CASE
    WHEN contract_address = '0xd37f28c6c51420054b1fb1362288d07ba40440e8' THEN 'invited 10 friends'
    WHEN contract_address = '0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2' THEN 'invited 5 friends'
    END AS invitation_status
    FROM kaia.core.fact_event_logs
    WHERE
    contract_address IN ('0xd37f28c6c51420054b1fb1362288d07ba40440e8', '0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2')
    AND tx_succeeded = TRUE
    )

    SELECT
    event_date,
    COUNT(DISTINCT tx_hash) AS total_invitations,
    COUNT(DISTINCT CASE WHEN invitation_status = 'invited 10 friends' THEN origin_from_address END) AS invited_10_friends,
    COUNT(DISTINCT CASE WHEN invitation_status = 'invited 5 friends' THEN origin_from_address END) AS invited_5_friends,
    COUNT(DISTINCT origin_from_address) AS unique_senders
    FROM event_data
    GROUP BY event_date
    ORDER BY event_date;



    Last run: 2 months ago
    EVENT_DATE
    TOTAL_INVITATIONS
    INVITED_10_FRIENDS
    INVITED_5_FRIENDS
    UNIQUE_SENDERS
    1
    2025-01-19 00:00:00.0002111
    2
    2025-01-20 00:00:00.0002111
    3
    2025-01-21 00:00:00.0004111
    4
    2025-01-22 00:00:00.00014325100101
    5
    2025-01-23 00:00:00.00024728168177
    6
    2025-01-24 00:00:00.00065932627637
    7
    2025-01-25 00:00:00.00070025628633
    8
    2025-01-26 00:00:00.00032067828292841
    9
    2025-01-27 00:00:00.000528715247964812
    10
    2025-01-28 00:00:00.000607115859135930
    11
    2025-01-29 00:00:00.000347011633543398
    12
    2025-01-30 00:00:00.000476510646594683
    13
    2025-01-31 00:00:00.000591916157585777
    14
    2025-02-01 00:00:00.00010184188999610029
    15
    2025-02-02 00:00:00.000494213448084859
    16
    2025-02-03 00:00:00.000813514179928017
    17
    2025-02-04 00:00:00.000105912041038710449
    18
    2025-02-05 00:00:00.0009191091
    19
    2025-02-06 00:00:00.0001171170117
    20
    2025-02-07 00:00:00.0005959059
    40
    2KB
    1s