datavortexNe Supprime Pas
    Updated 2025-04-25
    WITH mints_and_burns AS (
    SELECT
    decoded_log:from AS from_address,
    decoded_log:to AS to_address,
    decoded_log:value::FLOAT / 1e18 AS token_amount,
    block_timestamp,
    tx_hash
    FROM
    ethereum.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0xfae103dc9cf190ed75350761e95403b7b8afa6c0')
    AND event_name = 'Transfer'
    AND (
    decoded_log:from = '0x0000000000000000000000000000000000000000' OR
    decoded_log:to = '0x0000000000000000000000000000000000000000'
    )
    ),
    price_per_hour AS (
    SELECT
    symbol,
    hour,
    price
    FROM
    ethereum.price.ez_prices_hourly
    WHERE
    symbol = 'RSWETH'
    ),
    mint_burn_with_price AS (
    SELECT
    mb.*,
    p.price,
    CASE
    WHEN mb.from_address = '0x0000000000000000000000000000000000000000' THEN 'mint'
    WHEN mb.to_address = '0x0000000000000000000000000000000000000000' THEN 'burn'
    END AS action,
    mb.token_amount * p.price AS usd_value
    Last run: about 1 month ago
    First Restake Day
    STAKERS
    UNSTAKERS
    MINTS
    MINT_USD
    BURNS
    BURN_USD
    CIRCULATING_SUPPLY
    ETH_PRICE_USD
    MARKETCAP_USD
    RESTAKE_TXNS
    1
    2024.0129386201145380.745821252462843511.27783105085.797388746303117053.15250640294.9484325061825.8473572128.646006551390
    1
    135B
    27s