nitsEth Staked
Updated 2022-04-08
9
1
2
3
4
5
6
7
8
›
⌄
SELECT day, count(DISTINCT origin_address) as unique_stakers, sum(amt) as total_amt,sum(total_amt) over (order by day) as cumulative_amt,
sum(amt_usd) as total_amt_usd, sum(total_amt_usd) over (order by day) as cumulative_amt_usd
from
(SELECT date(block_timestamp) as day,tx_id,origin_address, max(amount) as amt, max(amount_usd) as amt_usd from ethereum.udm_events
where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84') and from_address = '0x0000000000000000000000000000000000000000'
and amount is not NULL and amount_usd is not NULL
GROUP by 1 , 2,3 )
GROUP by 1
Run a query to Download Data