primo_dataOpen Analyitics Bounty: Arbitrum - Daily Created Stealth Keys
    Updated 2024-04-05
    -- Generate and Publish Stealth Keys
    select
    date(block_timestamp) dt
    , case when dt >= date('2022-08-08') then 'after' else 'before' end tornado_cash_sanction
    , count(distinct tx_hash) txns
    , count(distinct from_address) users
    --, row_number() over(partition by from_address order by block_timestamp asc) rn
    from arbitrum.core.fact_transactions
    where lower(to_address) = lower('0x31fe56609C65Cd0C510E7125f051D440424D38f3')
    group by 1,2
    order by 1 asc


    QueryRunArchived: QueryRun has been archived