kidaConnext Daily TVL (ETH)
    Updated 2023-01-05
    with
    vaults as (
    select '0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09' as vault_address
    ),
    token_balances as (
    select
    date(block_timestamp) as date,
    user_address,
    contract_address,
    balance
    from ethereum.core.fact_token_balances
    where exists (select 1 from vaults where vault_address = user_address)
    qualify block_timestamp = last_value(block_timestamp) over (partition by date(block_timestamp), user_address, contract_address order by block_timestamp)
    order by block_timestamp desc
    ),

    cumulative_min_date as (
    SELECT user_address, contract_address, MIN(date) as min_date
    FROM token_balances
    GROUP BY contract_address, user_address
    ),

    date_dim as (select TO_DATE('20210512','YYYYMMDD') date_id )
    ,
    dates AS (
    SELECT DISTINCT
    date,
    user_address,
    contract_address
    FROM (
    SELECT DATEADD(DAY, 1*SEQ4(), date_dim.date_id ) AS date
    FROM date_dim,TABLE(GENERATOR(ROWCOUNT => (1500) ))
    WHERE date <= CURRENT_DATE
    )
    JOIN cumulative_min_date
    ON date >= min_date
    Run a query to Download Data