mmdrezaDaily transactions and unique users
    Updated 2022-10-03
    with tab1 as (select
    distinct tx_hash AS tx,
    block_timestamp,
    origin_from_address AS depositer
    from optimism.core.fact_event_logs
    where origin_to_address =lower('0x794a61358d6845594f94dc1db02a252b5b4814ad'))
    select
    date_trunc('day',block_timestamp) as date,
    count(distinct depositer) AS unique_users,
    count(tx) as transactions
    from tab1
    group by 1
    order by 1 asc
    Run a query to Download Data