Abbas_ra21Fuel Point Leaderboard
    Updated 2024-10-14
    WITH token_points AS (
    SELECT
    ORIGIN_FROM_ADDRESS AS user_address,
    SYMBOL,
    AMOUNT_USD,
    BLOCK_TIMESTAMP,
    CURRENT_DATE AS current_date,
    DATEDIFF('day', BLOCK_TIMESTAMP, CURRENT_DATE) AS days_since_deposit,
    CASE
    WHEN SYMBOL IN ('ETH', 'WETH', 'eETH', 'rsETH', 'rETH', 'wbETH', 'USDT', 'USDC', 'USDe', 'sUSDe', 'stETH') THEN 1.5
    WHEN SYMBOL = 'ezETH' AND BLOCK_TIMESTAMP BETWEEN '2024-07-08' AND '2024-07-22' THEN 3
    ELSE 1.5 -- Default multiplier for all other tokens
    END AS multiplier,
    AMOUNT_USD * CASE
    WHEN SYMBOL IN ('ETH', 'WETH', 'eETH', 'rsETH', 'rETH', 'wbETH', 'USDT', 'USDC', 'USDe', 'sUSDe', 'stETH') THEN 1.5
    WHEN SYMBOL = 'ezETH' AND BLOCK_TIMESTAMP BETWEEN '2024-07-08' AND '2024-07-22' THEN 3
    ELSE 1.5
    END * DATEDIFF('day', BLOCK_TIMESTAMP, CURRENT_DATE) AS total_points
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    SYMBOL IN ('WETH', 'eETH', 'rsETH', 'rETH', 'wbETH', 'USDT', 'USDC', 'USDe', 'sUSDe', 'ezETH', 'stETH')
    and to_address=lower('0x19b5cc75846BF6286d599ec116536a333C4C2c14')
    ),

    native_points AS (
    SELECT
    ORIGIN_FROM_ADDRESS AS user_address,
    'ETH' AS SYMBOL,
    AMOUNT_USD,
    BLOCK_TIMESTAMP,
    CURRENT_DATE AS current_date,
    DATEDIFF('day', BLOCK_TIMESTAMP, CURRENT_DATE) AS days_since_deposit,
    1.5 AS multiplier,
    AMOUNT_USD * 1.5 * DATEDIFF('day', BLOCK_TIMESTAMP, CURRENT_DATE) AS total_points
    FROM
    QueryRunArchived: QueryRun has been archived