Query token daily transfers

This tutorial queries the existing token.token_transfer.eth table to count daily USDC transfers on Ethereum mainnet.

Before you begin

Sign in to the Chaintable console. If you don’t have a Space yet, click New Space on the Spaces page, enter an Id, and click Create space.

New Space dialog with the Id field and Create space button

Open your new or existing Space. This example uses demo.

1. Create a query

Open Queries, click + in the upper right, name the query USDC daily transfers, and click Save and open.

2. Enter SQL

SELECT
    CAST(block_timestamp AS DATE) AS day,
    COUNT(*) AS transfer_count
FROM token.token_transfer.eth
WHERE token_id = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
  AND block_timestamp >= TIMESTAMP '2026-09-01 00:00:00'
  AND block_timestamp < TIMESTAMP '2026-09-08 00:00:00'
GROUP BY 1
ORDER BY 1

The query:

Filters for USDC using token_id.
Selects records from September 1 through 7, 2026, excluding the September 8 boundary.
Converts block timestamps to dates and counts transfer records with COUNT(*).
Sorts dates in ascending order.

The example groups dates in UTC. Change both time boundaries to query another period.

3. Run and save

Click Run and wait for Query results. Click Save at the top to save your changes. You can reopen the query and run it again.

USDC daily transfers returns seven rows with day and transfer_count columns

The query returns seven rows, one for each day from September 1 through 7.

4. Show the trend

In the results area, select New → Bar Chart and open the new chart tab. Set X Column to day and Y Column 1 to transfer_count. See Visualizations and dashboards for chart configuration and adding a chart to a dashboard.

Overview

Quickstart

Guides

Reference