transactions
Schema: public
Description
All transactions (e.g. smart contract calls, native token transfers, etc.) on supported chains. This table includes the high-level transaction metadata standard on all transactions. If you're looking for specific contract calls, logs, etc. see the contract_calls and contract_logs tables.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| id | bpchar(44) | The unique identifier for the transaction. |
| consensus_time | timestamptz | The timestamp of the transaction's consensus time. |
| transaction_hash | text | The unique hash of the transaction. |
| sender | text | The sender of the transaction aka "from". |
| recipient | text | The recipient of the transaction aka "to". |
| metric_name | text | The name of the metric associated with the transaction. |
| val | numeric | The value associated with the transaction. |
| string_val | text | The string value associated with the transaction. |
| chain | text | The blockchain this transaction belongs to. |
| block_hash | text | The unique hash of the block containing the transaction. |
Examples
Get hourly transaction send count for a specific address
select
time_bucket('1 hour'::interval, t.consensus_time) as time,
count(1) as val
from transactions t
where t.consensus_time > now() - '3 days'::interval
and t.sender = lower('0x339d413CCEfD986b1B3647A9cfa9CBbE70A30749')
and t.metric_name = 'transferAmount'
group by time;