datavortexTvl Per Chain
    Updated 2025-03-02
    WITH events AS (
    -- Ethereum Mint
    SELECT
    'Ethereum' AS chain,
    date_trunc('day', block_timestamp) AS date,
    decoded_log:value / 1e8 AS minted_amount,
    NULL AS burned_amount
    FROM ethereum.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0x8236a87084f8B84306f72007F36F2618A5634494')
    AND decoded_log:from = '0x0000000000000000000000000000000000000000'
    AND event_name = 'Transfer'

    UNION ALL
    -- Ethereum Burn
    SELECT
    'Ethereum' AS chain,
    date_trunc('day', block_timestamp) AS date,
    NULL AS minted_amount,
    decoded_log:value / 1e8 AS burned_amount
    FROM ethereum.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0x8236a87084f8B84306f72007F36F2618A5634494')
    AND decoded_log:to = '0x0000000000000000000000000000000000000000'
    AND event_name = 'Transfer'

    UNION ALL
    -- Base Mint
    SELECT
    'Base' AS chain,
    date_trunc('day', block_timestamp) AS date,
    decoded_log:value / 1e8 AS minted_amount,
    NULL AS burned_amount
    FROM base.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')
    Last run: 2 months ago
    DATE
    CHAIN
    CUMULATIVE_SUPPLY
    TVL_USD
    1
    2024-06-04 00:00:00.000Ethereum0.00185.918
    2
    2024-06-05 00:00:00.000Ethereum0.0010892.79144
    3
    2024-06-06 00:00:00.000Ethereum0.001194.5098
    4
    2024-06-17 00:00:00.000Ethereum0.00139999120.28434082
    5
    2024-06-28 00:00:00.000Ethereum0.00139999120.28434082
    6
    2024-07-08 00:00:00.000Ethereum0.1786999915353.54574082
    7
    2024-07-11 00:00:00.000Ethereum0.1793029915405.35429482
    8
    2024-07-16 00:00:00.000Ethereum0.1813029915577.19029482
    9
    2024-07-18 00:00:00.000Ethereum0.1823029915663.10829482
    10
    2024-07-24 00:00:00.000Ethereum0.1821019915645.83877682
    11
    2024-07-26 00:00:00.000Ethereum0.1831019915731.75677682
    12
    2024-07-29 00:00:00.000Ethereum0.1829209915716.20561882
    13
    2024-08-02 00:00:00.000Ethereum0.1831219915733.47513682
    14
    2024-08-09 00:00:00.000Ethereum0.1840019915809.08297682
    15
    2024-08-12 00:00:00.000Ethereum0.1838009915791.81345882
    16
    2024-08-15 00:00:00.000Ethereum0.1846049915860.89153082
    17
    2024-08-16 00:00:00.000Ethereum0.1844189915844.91078282
    18
    2024-08-19 00:00:00.000Ethereum0.1846799915867.33538082
    19
    2024-08-20 00:00:00.000Ethereum0.1859799915979.02878082
    20
    2024-08-21 00:00:00.000Ethereum8.85758708761026.16673944
    ...
    420
    27KB
    66s