nitsStake details min, max stats
    Updated 2022-09-06
    with lido as
    (SELECT count(DISTINCT tx_hash) as total_txs,
    avg(amount) as avg_amt, avg(amount_usd) as avg_amt_usd,
    median(amount) as median_amt, avg(amount_usd) as median_amt_usd,
    max(amount) as max_amt, max(amount_usd) as max_amt_usd,
    min(amount) as min_amt, min(amount_usd) as min_amt_usd,
    count(DISTINCT origin_from_address) as unique_depositors, 'lido' as platform
    from ethereum.core.ez_eth_transfers
    where eth_to_address ilike '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'),
    stakewise as
    (SELECT count(DISTINCT tx_hash) as total_txs,
    avg(amount) as avg_amt, avg(amount_usd) as avg_amt_usd,
    median(amount) as median_amt, avg(amount_usd) as median_amt_usd,
    max(amount) as max_amt, max(amount_usd) as max_amt_usd,
    min(amount) as min_amt, min(amount_usd) as min_amt_usd,
    count(DISTINCT origin_from_address) as unique_depositors, 'stakewise' as platform
    from ethereum.core.ez_eth_transfers
    where eth_to_address ilike '0xC874b064f465bdD6411D45734b56fac750Cda29A'),
    str as
    (SELECT count(DISTINCT tx_hash) as total_txs,
    avg(amount) as avg_amt, avg(amount_usd) as avg_amt_usd,
    median(amount) as median_amt, avg(amount_usd) as median_amt_usd,
    max(amount) as max_amt, max(amount_usd) as max_amt_usd,
    min(amount) as min_amt, min(amount_usd) as min_amt_usd,
    count(DISTINCT origin_from_address) as unique_depositors, 'Ankr' as platform
    from ethereum.core.ez_eth_transfers
    where eth_to_address ilike '0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
    ,
    direct as
    (SELECT count(DISTINCT tx_hash) as total_txs,
    avg(amount) as avg_amt, avg(amount_usd) as avg_amt_usd,
    median(amount) as median_amt, avg(amount_usd) as median_amt_usd,
    max(amount) as max_amt, max(amount_usd) as max_amt_usd,
    min(amount) as min_amt, min(amount_usd) as min_amt_usd,
    count(DISTINCT origin_from_address) as unique_depositors, 'direct' as platform
    from ethereum.core.ez_eth_transfers
    Run a query to Download Data