theericstoneAlchemist (Loan Vault) TVL
    Updated 2021-03-24
    SELECT
    DISTINCT date_trunc('hour', block_timestamp) as block_hour,
    last_value(value_numeric / 1e18) OVER (PARTITION BY block_hour ORDER BY block_timestamp RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as total_deposited
    FROM ethereum.reads
    WHERE contract_address = '0xc21d353ff4ee73c572425697f4f5aad2109fe35b'
    AND function_name = 'totalDeposited'
    ORDER BY 1 DESC
    Run a query to Download Data