datavortexrestaked usd
    Updated 2025-04-25
    WITH daily_supply AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS day,
    SUM(
    CASE
    WHEN decoded_log:from = '0x0000000000000000000000000000000000000000' THEN decoded_log:value
    ELSE 0
    END
    ) / 1e18 AS daily_mints,
    SUM(
    CASE
    WHEN decoded_log:to = '0x0000000000000000000000000000000000000000' THEN decoded_log:value
    ELSE 0
    END
    ) / 1e18 AS daily_burns,
    SUM(
    SUM(
    CASE
    WHEN decoded_log:from = '0x0000000000000000000000000000000000000000' THEN decoded_log:value
    ELSE 0
    END
    ) - SUM(
    CASE
    WHEN decoded_log:to = '0x0000000000000000000000000000000000000000' THEN decoded_log:value
    ELSE 0
    END
    )
    ) OVER (ORDER BY DATE_TRUNC('day', block_timestamp)) / 1e18 AS circulating_supply
    FROM
    ethereum.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0xfae103dc9cf190ed75350761e95403b7b8afa6c0')
    AND event_name = 'Transfer'
    GROUP BY
    DATE_TRUNC('day', block_timestamp)
    ),
    Last run: 11 days ago
    Date
    Circulating Supply (RSWETH)
    Avg Daily Price (USD)
    Daily Market Cap (USD)
    1
    2024-01-29 00:00:00.000945.430796285
    2
    2024-01-30 00:00:00.0002822.3360881142338.5784667956600254.40171971
    3
    2024-01-31 00:00:00.0004216.8854775922305.5550891949722261.77341193
    4
    2024-02-01 00:00:00.0005253.1210253872258.03149337411861712.7138302
    5
    2024-02-02 00:00:00.0006492.1784287332291.85806886914879151.5164279
    6
    2024-02-03 00:00:00.0008158.1246745582296.81451712818737699.1850622
    7
    2024-02-04 00:00:00.00010064.7936434712287.12557522923019446.9513814
    8
    2024-02-05 00:00:00.00010890.2773557552289.29045685924931008.0230756
    9
    2024-02-06 00:00:00.00012845.090953422312.21413930429700600.9231466
    10
    2024-02-07 00:00:00.00013418.1565476032368.67391783131783237.4396797
    11
    2024-02-08 00:00:00.00013856.9040504032418.33025662833510570.3282775
    12
    2024-02-09 00:00:00.00015823.1622514242458.59359488738902725.3622136
    13
    2024-02-10 00:00:00.00015949.0973321042484.30699412439622454.0521126
    14
    2024-02-11 00:00:00.00016273.0313868452508.66638790440823606.8694823
    15
    2024-02-12 00:00:00.00016458.7932670862524.44825092741549371.8754584
    16
    2024-02-13 00:00:00.00016693.0157449132637.10356181344021211.2783113
    17
    2024-02-14 00:00:00.00018403.0686962962688.11832110349469626.1270273
    18
    2024-02-15 00:00:00.00019142.2888785332795.78365011253517698.2723168
    19
    2024-02-16 00:00:00.00020277.6591728722808.1221027556942142.9153685
    20
    2024-02-17 00:00:00.00021313.0410767762772.05757349959080976.9311635
    ...
    453
    33KB
    33s