sarathOv_ertime_markt3
    Updated 2022-08-25
    select trunc(block_timestamp, 'day') as date, count(DISTINCT FROM_ADDRESS) as "Unique user", count(DISTINCT tx_hash) as Tx
    from optimism.core.fact_transactions
    where TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'
    and BLOCK_TIMESTAMP > CURRENT_DATE - 14
    group by 1
    order by 1
    Run a query to Download Data