0xaimanUntitled Query
Updated 2021-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
⌄
⌄
/*select date_trunc('day',t0) as date, count(distinct tx_from_address) as nu_address,
sum(nu_address) OVER(ORDER BY date asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_new_address
from
(
*/
select * --tx_from_address, min(block_timestamp) as t0
from ethereum.erc20_balances
where tx_to_label='paraswap' and tx_succeeded='TRUE'
limit 100
/*group by 1 order by 2
)
where date>'2021-10-01'
group by 1 order by 1
*/
Run a query to Download Data