eferLido Analysis
Updated 2022-06-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH Lido_daily_deposits AS(
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS datetime,
SUM(ETH_VALUE) AS val,
COUNT(*) AS deposits,
COUNT(DISTINCT FROM_ADDRESS) AS unique_sender
FROM ethereum.core.fact_traces
WHERE TO_ADDRESS='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
AND datetime > CURRENT_DATE - 90
AND INPUT LIKE '0xa1903eab%'
GROUP BY datetime
)
SELECT
CAST(datetime AS DATE) AS formatted_date,
CAST(val AS INT) AS ETH_submitted,
deposits, unique_sender
FROM Lido_daily_deposits
ORDER BY 1 DESC;
/* LIMIT 90; */
Run a query to Download Data