nitsETH inflows
Updated 2022-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT date(block_timestamp) as day,deposit_type,
count(DISTINCT tx_id) as total_txs,
sum(total_txs) over (partition by deposit_type order by day) as cumulative_total_txs,
sum(amount) as total_amt_deposited,
total_amt_deposited/total_txs as avg_amt_per_txs,
avg(avg_amt_per_txs) over (partition by deposit_type order by day) as avg_amt_per_txs_over_time
from (
SELECT *, case when amount >= '16' then 'maybe node' else 'deposit'end as deposit_type from ethereum.udm_events
where contract_address ilike '0xae78736cd615f374d3085123a210448e74fc6393' and from_address = '0x0000000000000000000000000000000000000000'
and origin_function_signature = '0xd0e30db0'and date(block_timestamp) >= CURRENT_DATE -93)
GROUP by 1 ,2
-- and tx_id = '0x6c43bd27115654147d2922aa8ba9adadaedb317d50992cb05cc0edfef2be2fbc'
LIMIT 300
Run a query to Download Data