flipside

    The Merge Daily Deposits (105 days before Past 105 days )
    nitsThe Merge Daily Deposits (105 days before Past 105 days )
    Updated 2022-03-20
    select date(block_timestamp) as day , count(DISTINCT tx_id) as total_txs, count(DISTINCT origin_address) as unique_depositors
    ,sum(total_txs) over(order by day) as cumulative_txs
    ,sum(unique_depositors) over(order by day) as cumulative_unique_depositors_daily
    from ethereum.udm_events
    where contract_address ilike '0x00000000219ab540356cbb839cbe05303d7705fa' and day> CURRENT_DATE -210 and day <= CURRENT_DATE -105
    GROUP by 1
    Run a query to Download Data