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

# Raw

> The standardized Base blocks, transactions, logs and internal calls.

The `base` dataset holds the standardized Base tables.

Every column is documented at [EVM ▸ Overview](/docs/catalog/chain-verticals/evm/index).

## Tables

<table>
  <thead>
    <tr>
      <th width="180">Table</th>
      <th>Description</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td><code>blocks</code></td>
      <td>One row per block, with its gas and fee totals.</td>
    </tr>

    <tr>
      <td><code>transactions</code></td>
      <td>One row per transaction, with its receipt fields on the same row.</td>
    </tr>

    <tr>
      <td><code>logs</code></td>
      <td>One row per event log a contract emitted.</td>
    </tr>

    <tr>
      <td><code>traces</code></td>
      <td>One row per internal call recorded during execution.</td>
    </tr>
  </tbody>
</table>

All four tables begin at the chain's 2023-06 launch.

## Sample queries

<Warning>
  The partition column differs by table: `transactions`, `logs` and `traces` split on `block_timestamp`, `blocks` splits on `timestamp`. Bound the right column in every query and keep it bare on the left of the comparison; wrapping it in a function reads every partition.
</Warning>

<Tabs>
  <Tab title="Daily transactions">
    **Count daily transactions and the accounts that sent them.**

    ```sql theme={null}
    select
        timestamp_trunc(block_timestamp, day) as day,
        count(*) as transactions,
        count(distinct from_address) as senders
    from `base.transactions`
    where block_timestamp >= timestamp('2026-08-16')
      and block_timestamp < timestamp('2026-08-23')
    group by day
    order by day
    ```
  </Tab>

  <Tab title="One contract's logs">
    **Count the logs one contract emitted on a single day.** A log is the record a contract writes when something happens inside it, and `address` is the contract that wrote it.

    ```sql theme={null}
    select
        count(*) as usdc_logs,
        count(distinct transaction_hash) as transactions
    from `base.logs`
    where block_timestamp >= timestamp('2026-08-20')
      and block_timestamp < timestamp('2026-08-21')
      and address = '0x833589fcd6edb6e08f4c7c32d4f71b54bda02913'
    ```
  </Tab>
</Tabs>