flipside

    label
    datavortexlabel
    Updated 2025-02-24
    /*
    WITH game_projects AS (
    SELECT
    DISTINCT project_name,
    address
    FROM
    kaia.core.dim_labels
    WHERE
    label_type = 'games'
    )
    SELECT
    gp.project_name,
    COUNT(DISTINCT tx.tx_hash) AS total_transactions,
    COUNT(DISTINCT tx.from_address) AS unique_users
    FROM
    game_projects gp
    JOIN
    kaia.core.fact_transactions tx
    ON gp.address = tx.to_address
    GROUP BY
    gp.project_name
    ORDER BY
    total_transactions DESC;
    */
    /*
    WITH game_projects AS (
    SELECT
    DISTINCT project_name,
    address
    FROM
    kaia.core.dim_labels
    WHERE
    label_type = 'games'
    ),
    filtered_transactions AS (
    SELECT
    Last run: 2 months ago
    BLOCKCHAIN
    CREATOR
    ADDRESS
    ADDRESS_NAME
    LABEL_TYPE
    LABEL_SUBTYPE
    PROJECT_NAME
    DIM_LABELS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		kaiaflipside0x0d0966da8e610376f723e42fdfc7a7383a1efd05elderglade: play 2 gamesgamesgeneral_contracteldergladee93031944d331a47b7b6054992cbf0002025-02-13 03:18:51.0812025-02-15 03:18:52.009
    2
    		kaiaflipside0x2f0bcecce06b6eb32a83073984d0b793640aeaf6elderglade: guardians of eldergladegamesnf_token_contractelderglade449b95c26c298d8cb58454bb4ec79e502025-02-13 03:18:51.0812025-02-15 03:18:52.009
    3
    		kaiaflipside0xd37f28c6c51420054b1fb1362288d07ba40440e8elderglade: invite 10 friendsgamesgeneral_contractelderglade16fdbfa31331fed96bce95428d27f0f42025-02-13 03:18:51.0812025-02-15 03:18:52.009
    4
    		kaiaflipside0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2elderglade: invite 5 friendsgamesgeneral_contracteldergladea665ea4899911d017b72439c4f64ca7f2025-02-13 03:18:51.0812025-02-15 03:18:52.009
    5
    		kaiaflipside0x97fa0937b99896f2415baf37ce002623dc3b905delderglade: in-game item purchase contractgamesgeneral_contracteldergladebbf587d307d27324014cf5bf3c36c0d82025-02-13 03:18:51.0812025-02-15 03:18:52.009
    6
    		kaiaflipside0x2e930f07b30c566e8ac7dd018ee895cfa0732a71elderglade: daily log ingamesgeneral_contractelderglade7eaa66d119bda2a458f0e2223ad095a02025-02-13 03:18:51.0812025-02-15 03:18:52.009
    6
    1KB
    2s