jeffy2030prizes
    Updated 2025-01-26
    WITH all_txs AS (
    SELECT
    flattened.VALUE AS val,
    flattened.VALUE:parsed:info:lamports / 1000000000 AS eth,
    LOG_MESSAGES,
    f.ACCOUNT_KEYS,
    flattened.*,
    TX_ID,
    SIGNERS,
    SUCCEEDED
    FROM
    eclipse.core.fact_transactions f,
    TABLE(FLATTEN(input => INSTRUCTIONS)) AS flattened
    WHERE
    f.ACCOUNT_KEYS[1]:pubkey = 'H8ypTdHmhn95ytZSanT1yzmDWW2aiQVVundsqbiAczEd'
    ORDER BY
    f.BLOCK_TIMESTAMP::DATE DESC
    ),

    info AS (
    SELECT
    '4.2M LAIKA' AS name, 'sideprize_49_4.2M LAIKA' AS prize, 'Laika' AS token, 4.2 * 1000000 AS amount, 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx' AS contract
    UNION ALL
    SELECT
    '5M LAIKA', 'sideprize_4_5M LAIKA' AS prize, 'Laika' AS token, 4.5 * 1000000 AS amount, 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx' AS contract
    UNION ALL
    SELECT
    '10M LAIKA', 'sideprize_24_10M LAIKA' AS prize, 'Laika' AS token, 10 * 1000000 AS amount, 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx' AS contract
    UNION ALL
    SELECT
    '2.5M MOON', 'sideprize_14_2.5M MOON' AS prize, 'MoonCoin' AS token, 2.5 * 1000000 AS amount, 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL' AS contract
    UNION ALL
    SELECT
    '5M MOON', 'sideprize_40_5M MOON' AS prize, 'MoonCoin' AS token, 5 * 1000000 AS amount, 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL' AS contract
    UNION ALL
    SELECT
    QueryRunArchived: QueryRun has been archived