flipside

    youngest-azure
    Movement Teamyoungest-azure
    Updated 2024-11-15
    select trunc(block_timestamp,'day') as daily,
    count(DISTINCT account_address) as "Deployer"
    from aptos.core.fact_events
    where event_resource = 'CoinRegisterEvent'
    and EVENT_MODULE = 'account'
    and tx_type = 'user_transaction'
    group by 1

    QueryRunArchived: QueryRun has been archived