> ## Documentation Index
> Fetch the complete documentation index at: https://docs.neynar.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Counting signups by day

<Info>
  **Pre-requisites** - Read access to a replicator database
</Info>

To count the number of signups by day, we can use the `chain_events` table to query the number
of [`ID_REGISTER`](https://snapchain.farcaster.xyz/reference/datatypes/events#onchaineventtype) events
and group by day.

```sql theme={"system"}
SELECT DATE_TRUNC('day', created_at) AS day, COUNT(*) AS count
FROM chain_events
WHERE type = 3 -- ID_REGISTER (see event types reference page)
GROUP BY day
ORDER BY day desc;
```

For more information on the schema, see the [replicator schema](/farcaster/reference/replicator/schema).


## Related topics

- [Accounts](/farcaster/learn/what-is-farcaster/accounts.md)
- [Tier Registry](/farcaster/reference/contracts/reference/tier-registry.md)
- [Kafka Stream: Real-Time Farcaster Events via Neynar](/docs/from-kafka-stream.md)
- [Managing Onchain Wallets](/docs/managing-onchain-wallets.md)
- [From Parquet Exports](/docs/parquet.md)