nitsTokeMak Daily Usage
Updated 2022-02-26
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT date(block_timestamp) as day, count(DISTINCT addresses ) as unique_addr, count(*) as total_txs, sum(amt_net)/pow(10,18) as net_deposits,
sum(net_deposits) over (order by day) as cumulative_deposits
from
(SELECT *, case when origin_function_name = 'withdraw' then amount*(-1) else amount end as amt_net ,
case when origin_function_name = 'withdraw' then from_address else to_address end as addresses
from ethereum.udm_events
where contract_address ilike '0x15A629f0665A3Eb97D7aE9A7ce7ABF73AeB79415' and (origin_function_name = 'deposit' or origin_function_name = 'withdraw'))
GROUP by 1
-- limit 100
Run a query to Download Data