damidezCandy box token distribution
    Updated 2024-08-05
    WITH sender_logs_users AS (
    SELECT
    BLOCK_TIMESTAMP,
    try_parse_json(CLEAN_LOG) AS log,
    TX_HASH
    FROM
    near.core.fact_logs
    WHERE
    RECEIVER_ID = 'signin2.sendercommunity.near'
    AND log:event = 'open_box'
    AND log:data[0]:meme != ''
    AND to_number(log:data[0]:amount) > 0
    AND BLOCK_TIMESTAMP::date >= '2024-05-22'
    ),
    meme_covert AS (
    SELECT
    BLOCK_TIMESTAMP,
    log:data[0]:meme AS meme,
    CASE log:data[0]:meme
    WHEN 'token.lonkingnearbackto2024.near' THEN 'Lonk'
    WHEN 'nearnvidia.near' THEN 'Nearvidia'
    WHEN 'touched.tkn.near' THEN 'Touched'
    WHEN 'blackdragon.tkn.near' THEN 'BlackDragon'
    WHEN 'ftv2.nekotoken.near' THEN 'Neko'
    WHEN 'token.v2.ref-finance.near' THEN 'Ref Finance (REF)'
    WHEN '802d89b6e511b335f05024a65161bce7efc3f311.factory.bridge.near' THEN 'Linear
    (LNR)'
    WHEN 'token.burrow.near' THEN 'Burrow Token
    (BRRR)'
    ELSE 'Near'
    END AS Meme_Token
    FROM
    sender_logs_users
    )
    SELECT
    Meme_Token,
    QueryRunArchived: QueryRun has been archived