nitsETH inflows
    Updated 2022-05-01
    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