eferLido_Total_90
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH Lido_daily_deposits AS(
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS datetime,
SUM(ETH_VALUE) AS val
FROM ethereum.core.fact_traces
WHERE TO_ADDRESS='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
AND datetime > CURRENT_DATE - 90
AND INPUT LIKE '0xa1903eab%'
GROUP BY datetime
ORDER BY datetime DESC
)
SELECT sum(val) FROM Lido_daily_deposits;
/* SELECT CONCAT(sum(val), 'Ξ') FROM Lido_daily_deposits; */
Run a query to Download Data