zakkisyedTVL Inflow in ETH mainnet
Updated 2024-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH daily_eth_sums AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS date,
SUM(value) AS daily_sum
FROM
ethereum.core.fact_traces
WHERE
LOWER(to_address) = LOWER('0x036676389e48133b63a802f8635ad39e752d375d')
AND block_timestamp >= '2024-05-08 04:30:00.000'
GROUP BY
DATE_TRUNC('hour', block_timestamp)
ORDER BY
DATE_TRUNC('hour', block_timestamp) ASC
)
SELECT
date,
daily_sum,
SUM(daily_sum) OVER (ORDER BY date ASC) AS cumulative_eth
FROM
daily_eth_sums
ORDER BY
date DESC;
QueryRunArchived: QueryRun has been archived