nitsNew Users Joining Optimism Over Time
    Updated 2022-11-04
    with op as
    (SELECT date(first_use) as day, count(DISTINCT origin_from_address) as total_addresses,
    sum(total_addresses) over (order by day rows BETWEEN 6 preceding and CURRENT row) as moving_avg_addresses, 'op' as type
    from
    (SELECT origin_from_address,min(block_timestamp) as first_use from optimism.sushi.ez_swaps
    GROUP by 1 )
    GROUP by 1
    ORDER by 1 DESC
    LIMIT 183 ),
    eth as
    (SELECT date(first_use) as day, count(DISTINCT origin_from_address) as total_addresses,
    sum(total_addresses) over (order by day rows BETWEEN 6 preceding and CURRENT row) as moving_avg_addresses, 'eth' as type
    from
    (SELECT origin_from_address,min(block_timestamp) as first_use from ethereum.sushi.ez_swaps
    GROUP by 1 )
    GROUP by 1
    ORDER by 1 DESC
    LIMIT 183 )
    SELECT * from eth
    UNION ALL
    SELECT * FROM op
    Run a query to Download Data